Search Results

Search found 6257 results on 251 pages for 'columns'.

Page 18/251 | < Previous Page | 14 15 16 17 18 19 20 21 22 23 24 25  | Next Page >

• Sqlite table constraint - unique on multiple columns

  - by Rich

  I can find syntax "charts" on this on the sqlite website, but no examples and my code is crashing. I have other tables with unique constraints on a single column, but I want to add a constraint to the table on two columns. This is what I have that is causing a SQLiteException with the message "syntax error". CREATE TABLE name (column defs) UNIQUE (col_name1, col_name2) ON CONFLICT REPLACE I'm doing this based on the following: table-constraint

  Read the article

• finding the keyword in multiple columns and show the text around it

  - by hao

  If I want to do a search on multiple columns for the keyword abc using like %abc%, how would I show some of the text around that keyword. Similar to what Google does with its search results.

  Read the article

• WPF DataGrid Columns not auto sizing when not visible

  - by Dave

  I have a datagrid inside an expander that are initially closed. When the expander is opened, the columns are all at the minimum width. Is there a way to force a recalculation of the widths? Thanks!

  Read the article

• WPF ListView example showing all possible kinds of columns including hypelink and checkbox

  - by MicMit

  Could anyone help with a link to comprehensive example or book with all possible kinds of columns for ListView. ListView is bound to Observable collection but read-only ( except checkboxes which are primarily to drive certain actions for selected rows for the application ).

  Read the article

• MYSQL - Rows to Columns

  - by Bob Rivers

  Hi, I tried to search posts, but I only found solutions for SQL Server/Access. I need a solution to MYSQL (5.X). I have a table with 3 columns: hostid, itemname, itemvalue. If I do a select, it will return 1 A 10 1 B 3 2 A 9 2 C 40 How do I query the database to return something like A B C 1 10 3 2 9 40

  Read the article

• Windows Form - List View - Removing lines between columns

  - by gary

  I need to display a listview in winforms which should not have any lines between columns. I tried GridLines=false and also tried setting HeaderStyle to ColumnHeaderStyle.None. But this is not working. I want to remove the 2 vertical lines coming in the middle.

  Read the article

• When I remove rows in Cassandra I delete only columns not row keys

  - by Matroska

  Hi, If I delete every keys in a ColumnFamily in a Cassandra db using remove(key), then if I use get_range_slices, rows are still there but without columns. How could I remove entire rows? Thanks Tobia Loschiavo

  Read the article

• Select statement always execute/select columns in order?

  - by Aseem Gautam

  Does all the columns in select statement gets selected one after another as listed? Declare @X, @Y SELECT @X = ColumnA*.25 + ColumnB*2.5, @Y = ColumnA*.5 + ColumnC*1.33, TOTAL = @X + @Y FROM SomeTable Is the above query safe to use? Will total always be selected after @X and @Y are calculated?

  Read the article

• Windows Form - ListView - Removing lines between columns

  - by gary

  I need to display a ListView in WinForms which should not have any lines between columns. I tried GridLines=false and also tried setting HeaderStyle to ColumnHeaderStyle.None. But this is not working. I want to remove the 2 vertical lines coming in the middle.

  Read the article

• SQL storing data about columns

  - by Chris

  I'm learning SQL Server Compact for a program I'm writing that requries a local database. I have multiple tables, each with different columns and I'd like to mark each column as being a certain type (not a data type, just an integer tag) to let the program know what to do with it. I'm clueless about SQL. How does one do this?

  Read the article

• Change the precision of all decimal columns in every table in the database

  - by Jon

  Hi all, I have a rather large database that has alot of decimal columns in alot of tables, the customer has now changed their mind and wants all the numbers (decimals) to have a precision of 3 d.p. instead of the original two. Is there any quick way of going through all the tables in a database and changing any decimal column in that table to have 3.d.p instead of 2 d.p? The db is on sql 2005. Any help would be great.

  Read the article

• VB.net Reading from ListViews with Multiple Columns

  - by xzerox

  Alright. So I was able to find out how to read from the first column but I need to read from both of them. I am using full row select which I need on there. Here is the code I am using to get it for the first column. Dim I As Integer For I = 0 To ListView1.SelectedItems.Count - 1 MsgBox(ListView1.SelectedItems(I).Text) Next MessageBox.Show(ListView1.Columns(0).Text)

  Read the article

• SQL - How to join on similar (not exact) columns

  - by BlueRaja

  I have two tables which get updated at almost the exact same time - I need to join on the datetime column. I've tried this: SELECT * FROM A, B WHERE ABS(DATEDIFF(second, A.Date_Time, B.Date_Time) = ( SELECT MIN(ABS(DATEDIFF(second, A.Date_Time, B2.Date_Time))) FROM B AS B2 ) But it tells me: Multiple columns are specified in an aggregated expression containing an outer reference. If an expression being aggregated contains an outer reference, then that outer reference must be the only column referenced in the expression. How can I join these tables?

  Read the article

• NHibernate: Select entire entity plus aggregate columns

  - by cbp

  I want to return an entire entity, along with some aggregate columns. In SQL I would use an inner select, something like this: SELECT TOP 10 f.*, inner_query.[average xxx] FROM ( SELECT f.Id, AVG(fb.xxx) AS [average xxx] FROM foobar fb INNER JOIN foo f ON f.FoobarId = fb.Id ) AS inner_query INNER JOIN foo f ON f.Id = inner_query.Id Is this possible with CreateCriteria?

  Read the article

• sorting advance datagrid columns in flex

  - by david

  Having four columns in advance datagrid like company,contact_person,product and date. In this, first i want to sort by product followed by company and followed by date. how can i do it in Advance datagrid. Anybody knows please reply me asap. Advance thanks to u.

  Read the article

• multiple columns in xsl-fo apache fop

  - by Thunder

  Is it possible to make multi-column text as in newspaper in using Apache FOP? It is continuos flow of text and not a table with two columns.

  Read the article

• Need to transform the rows into columns for the similar ID's in oracle

  - by Siva

  Hi, I need to transform the rows into columns for the similar ID's in oracle e.g. The following is the result I will get if i query my database Col1 Col2 Col3 1 ABC Yes 1 XYZ NO 2 ABC NO I need to transform this into Col1 Col2 Col3 Col4 Col5 1 ABC Yes XYZ No 2 ABC NO NULL NULL Someone please help me in solving this issue Thanks, Siv

  Read the article

• print webpage in two columns

  - by machaa

  Hi, How to print a webpage in two columns or one column as per the user input/choice. And when a take a print out I'm getting the website url on the top left side, How can we stop printing this? Regards

  Read the article

• how to retrieve distinct values from multiple columns

  - by ANIL MANE

  Hello Experts, I have a flat text file data which I import into MSSQL table. It creates and table with specified name along with multiple columns as per data file. now I need a query which will return the data and its count. e.g. data file : BREAD,MILK BREAD,DIAPER,BEER,EGGS MILK,DIAPER,BEER,COKE BREAD,MILK,DIAPER,BEER BREAD,MILK,DIAPER,COKE BREAD,ICE,MANGO JUICE,BURGER Result should be BREAD | 5 MILK | 4 DIAPER| 4 and so on.

  Read the article

• SQL Query To Get Multiple Max Values From Multiple Columns

  - by Sheridan

  I am trying to figure out how to pull multiple max values from multiple columns. Here is some sample data: DATE | A | B | C 4/4/2011 | 64.4 | 62.1 | 33.3 4/5/2011 | 34.6 | 33.5 | 32.3 4/6/2011 | 33.1 | 49.4 | 32.1 4/7/2011 | 55.2 | 32.8 | 33.5 4/8/2011 | 31.2 | 50.1 | 30.4 4/9/2011 | 31.7 | 31.1 | 30.4 I want the top 5 so: 4/4/2011 | 64.4 4/4/2011 | 62.1 4/7/2011 | 55.2 4/8/2011 | 50.1 4/6/2011 | 49.4 Thanks

  Read the article

• linq, selecting columns as IEnumerable<DataRow>

  - by joe

  how can i do in linq: IEnumerable<DataRow> query = from rec in dt.AsEnumerable() where rec.Field<decimal>("column2") == 1 && foo(rec.Field<decimal>("column1")) select new { column1 = rec.Field<decimal>("column1"), column2 = rec.Field<decimal>("column2"), column3 = rec.Field<decimal>("column3")} ; this does not work. Im trying to select some columns as new datatable then join it later with some other datatable.

  Read the article

• SQL SERVER - Detecting non-indexed columns but used in WHERE clause

  - by Vadi

  How to detect a column included in WHERE clause but used in indexed? Little Background: Until the time the table has few number of records things will be okay, once it started having millions of records then index should be created for a column which is used in WHERE clauses in stored procs, inline queries etc., Since we have hundreds of stored procs and queries that often gets changed by the devs I wanted to have a automated way of identifying those columns that are used in WHERE clauses but not an index is created. How to do that in SQL SERVER 2008?

  Read the article

• Parsing pipe delimited string into columns?

  - by DMS

  Hello, I have a column with pipe separated values such as: '23|12.1| 450|30|9|78|82.5|92.1|120|185|52|11' I want to parse this column to fill a table with 12 corresponding columns: month1, month2, month3...month12. So month1 will have the value 23, month2 the value 12.1 etc... Is there a way to parse it by a loop or delimeter instead of having to separate one value at a time using substr? Thanks.

  Read the article

• Mysql count columns

  - by Sergio

  I have a table for image gallery with four columns like: foid | uid | pic1 | pic2 | pic3 | date | ----------------------------------------------- 104 | 5 | 1.jpg | 2.jpg | 3.jpg | 2010-01-01 105 | 14 | 8.jpg | | | 2009-04-08 106 | 48 | x.jpg | y.jpg | | 2010-08-09 Mysql query for the user's galleries looks like: SELECT * FROM foto WHERE uid = $id order by foid DESC The thing that I want to do is count the number of images (PIC1, PIC2, PIC3) in every of the listed galleries. What is the best way for doing that?

  Read the article

• One DataGrid Item Renderer for multiple columns

  - by user329650

  Hey, I'm trying to create a Flex DataGrid where the firstname and lastname are shown under each other, but in the DataGridColumn Ideally I would want to do something like <mx:columns> <mx:DataGridColumn headerText="Column 2" dataField="time"/> <mx:DataGridColumn headerText="Column 2" dataField="firstname,lastname" itemRenderer="renderers.FirstNameLastName"/> so that both values get passed to the itemrenderer, is this possible? Dennis

  Read the article

< Previous Page | 14 15 16 17 18 19 20 21 22 23 24 25  | Next Page >