Search Results

Search found 12287 results on 492 pages for 'column oriented'.

Page 325/492 | < Previous Page | 321 322 323 324 325 326 327 328 329 330 331 332  | Next Page >

• How to determine whether there is date in the string or not with different date format ?

  - by Harikrishna

  I am parsing table information from the html table.Now I want to check whether there is date in the records for one particular column.Means I want to check whether there is date in the string or not .And date can be in different format like the string can be FUTIDX 26FEB2009 NIFTY 0 -- There is date in the string. FUTIDX MINIFTY 30 Jul 2009 -- There is date in the string. FUTSTK ONGC 27 Mar 2008 -- There is date in the string. How can I do that ?

  Read the article

• Android: Sorting a merged cursor

  - by tonyc

  Hi, I'm wondering if there's any way to merge two cursors together and then resort them. I can easily merge two cursors together by using a MergedCursor, but that doesn't sort them. I have two sets of contacts in two separate cursors (with totally different schemas) and I want to merge them and sort them by name (the name column is different in the two cursors). Is this possible? Thanks, Tony

  Read the article

• ListView Control and Details

  - by j-t-s

  Hi All, I'm a bit confused by a few tutorials that I read about the ListView. I have a ListView control and on the left hand side should be a name, and to the right of that name should be like another column with some more text in it. For example: ListView: jason blah blah blah item2 more blahs item3 jupiter item4 uranus How can this be done? Is there a simple way of doing this? Thank you

  Read the article

• element-wise lookup on one ndarray to another ndarray of different shapes

  - by fahhean

  Hi, I am new to numpy. Am wonder is there a way to do lookup of two ndarray of different shapes? for example, i have 2 ndarrays as below: X = array([[0, 3, 6], [3, 3, 3], [6, 0, 3]]) Y = array([[0, 100], [3, 500], [6, 800]]) and would like to lookup each element of X in Y, then be able to return the second column of Y: Z = array([[100, 500, 800], [500, 500, 500], [800, 100, 500]]) thanks, fahhean

  Read the article

• ruby-on-rails: string, decimal or float for price field?

  - by fayer

  i've got a price field/column and i wonder should the rails datatype be string, decimal or float? eg. 15.50 USD. thanks

  Read the article

• How to display HTML-like table data on iPhone?

  - by Jason

  I have a set of data in a matrix which I would like to display in my iPhone app with all of the rows and columns intact. Everything I can find on the web dealing with "tables iPhone" gives me information on UITableView, which only lets you show a list of items to the user - not an actual table in the HTML sense. What's the best way on the iPhone to display an actual table of data to the user, with column & row headings and table cells?

  Read the article

• MSSQL variable columns name?

  - by Petr

  Hi, I am wondering why I cannot use variable column name like that: declare @a as varchar; set @a='TEST' select @a from x; Thank you

  Read the article

• What is wrong with this SQL syntax?

  - by Finbarr

  UPDATE files SET filepath = REPLACE(filepath, `sites/somedomain.com/files/`, `sites/someotherdomain.com/files/`); I have a table called files with a field called filepath. MySQL returns this error: Unknown column 'sites/somedomain.com/files/' in 'field list'

  Read the article

• mysql join table - selecting the newest row

  - by cmancre

  Hi, I have the following two MySQL tables TABLE NAMES NAME_ID NAME 1 name1 2 name2 3 name3 TABLE STATUS STATUS_ID NAME_ID TIMESTAMP 1 1 2010-12-20 12:00 2 2 2010-12-20 10:00 3 3 2010-12-20 10:30 4 3 2010-12-20 14:00 I would like to select all info from table NAMES and add most recent correspondent TIMESTAMP column from table STATUS RESULT NAME_ID NAME TIMESTAMP 1 name1 2010-12-20 12:00 2 name2 2010-12-20 10:00 3 name3 2010-12-20 14:00 Am stuck on this one. How do I left join only on the newer timestamp?

  Read the article

• What could be the Consequence of inserting "id" in any autoincrementing 'id' containing table?

  - by Parth

  What could be the Consequence of inserting "id" in any autoincrementing 'id' containing table? If I have a Tabe in which I have configured the column "id" as the auto incrmented, But still I am using an INSERT query in which id is defined, like wise INSERT INTO XYZ (id) values ('26'); How does it going to effect the table and the process related to it.. Is it "no issues" to do this? or it should be avoided?

  Read the article

• Calculate value from two field in third field

  - by terence6

  I'm trying to create a query, that will calculate sum of products on invoice. I have 3 tables : Product (with product's price) Invoice (with invoice id) Products on invoice (with invoice id, product id and number of particular products) So in my query I take invoice_id (from invoice), price (from product),number of products sold and invoice_id (from products on invoice) and calculate their product in fourth column. I know I sohuld use 'Totals' but how to achieve that ? Model:

  Read the article

• How does a database handle auto-number field if it's limit is reached?

  - by Nitesh Panchal

  Hello, In my tables, i have selected id column to be of type int (4 bytes). The answer i want to know is how will any database handle it once it's limits are reached? Will the database refuse to insert any more records in table? or what exactly will happen? Also how should i tackle this type of problem (if the database doesn't handle it by itself)?

  Read the article

• Adding Names to columns in a matrix

  - by Jeff

  I have my matrix I have created, a pic found here. http://s816.photobucket.com/albums/zz83/gavakie/?action=view&current=matrix.jpg The first three column what whats being grouped by but I can had the names of those columns, how can I do that in Reporting Services?

  Read the article

• IntegrityError with Booleand Fields and Postgresql

  - by xRobot

  I have this simple Blog model: class Blog(models.Model): title = models.CharField(_('title'), max_length=60, blank=True, null=True) body = models.TextField(_('body')) user = models.ForeignKey(User) is_public = models.BooleanField(_('is public'), default = True) When I insert a blog in admin interface, I get this error: IntegrityError at /admin/blogs/blog/add/ null value in column "is_public" violates not-null constraint Why ???

  Read the article

• Saving Double.MinValue in SQLServer

  - by PatrickL

  Using a TSQL update command against a SQLServer database, how can I update a column of type FLOAT with the smallest possible double value? The smallest possible double value in hex notation being 3ff0 0000 0000 0001 (http://en.wikipedia.org/wiki/Double%5Fprecision)

  Read the article

• How to manage and make look of complex data <table> identical in all browser?

  - by metal-gear-solid

  What are helpful CSS properties which can be helpful for table? I have to make so many complex tables which have different type of colors in columns, thead, borders, padding, alternate row and column colors etc. I want to use as less as possible of css classes. How to make complex tables design with combination of as much as possible of HTML tags and CSS properties? and should look identical in all browsers.

  Read the article

• LINQ to SQL selecting fields

  - by user3686904

  I am trying to populate more columns in the query below, could someone assist me? QUERY: var query = from r in SQLresults.AsEnumerable() group r by r.Field<string>("COLUMN_ONE") into groupedTable select new { c1 = groupedTable.Key, c2 = groupedTable.Sum(s => s.Field<decimal>("COLUMN_TWO")), }; How could I get a column named COLUMN_THREE in this query ? Thanks in advance

  Read the article

• how to increase the size of the jquery grid row..

  - by kumar

  how to increase row size using jquery.. I have column like this. { name: 'Comments', index: 'Comments', editable: true, editype: 'textarea', editoptions: { rows: "2", cols: "10"} } Thanks

  Read the article

• Group mysql query by 15 min intervals

  - by gsiener

  I've got a monitoring system that is collecting data every n seconds (n ~=10 but varies). I'd like to aggregate the collected data by 15 minute intervals. Is there a way to corral the timestamp column into 15 minute chunks to allow for grouping to work?

  Read the article

• How do I map to a parent or child in the same table with NHibernate?

  - by adolfojp

  Lets suppose that I have a Category table with a column that holds the id of a parent or child category from the same table. This design would allow me to have unlimited levels of Categories, or unlimited levels in a thread, for example. How can I map this relationship with NHibernate? Are there any disadvantages or warnings that I should take into consideration when doing this?

  Read the article

• How can this SQL be wrong? What am I not seeing?

  - by ropstah

  Can anybody please spot my error, this should be a legal query in SQL shouldn't it?? Unknown column u.usr_auto_key in the ON clause This is the database schema: User: (usr_auto_key, name, etc...) Setting: (set_auto_key, name etc..) User_Setting: (usr_auto_key, set_auto_key, value) And this is the query... SELECT `u`.`usr_auto_key` AS `u__usr_auto_key`, `s`.`set_auto_key` AS `s__set_auto_key`, `u2`.`usr_auto_key` AS `u2__usr_auto_key`, `u2`.`set_auto_key` AS `u2__set_auto_key`, `u2`.`value` AS `u2__value` FROM `User` `u`, `Setting` `s` LEFT JOIN `User_Setting` `u2` ON `u`.`usr_auto_key` = `u2`.`usr_auto_key` WHERE (`s`.`sct_auto_key` = 1 AND `u`.`usr_auto_key` = 1 AND admin_property is null)

  Read the article

• how to select only first td of first colgroup of table?

  - by metal-gear-solid

  how to select only first td of first colgroup of table? if i have table with 5 column and using 5 colgroup?

  Read the article

• Using C# to read/write from excel spreadsheet.

  - by Aaron

  Hi there, I need to make a program that writes some data to an excel spreadsheet. Something basic along the lines of First name, last name, phone number, e-mail per row with each category in its own column. I don't even know where to start. If someone could tell me which assemblies to reference and maybe point me to a website or a book that covers writing/reading data from an excel spreadsheet via a c# program that would be great. Many thanks.

  Read the article

• How to find size of individual columns and indexes in mysql/innodb database?

  - by taw

  SHOW TABLE STATUS LIKE 'foo' returns Data_length - size of all data, and Index_length - size of all indexes. What's the best way to get per-column and per-index breakdown?

  Read the article

• activating scrolling in UITableview through programming ?

  - by senthilmuthu

  hi, i i want to activate scrolling vertically through programming for UITableview?is it possible ?In one Viewcontroller's view i have scrollview, on that i have two tableviews(instead of one,like two column)..how can i scroll vertically both at same time?any help please?

  Read the article

< Previous Page | 321 322 323 324 325 326 327 328 329 330 331 332  | Next Page >