Search Results

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

Page 314/492 | < Previous Page | 310 311 312 313 314 315 316 317 318 319 320 321  | Next Page >

• How Can i Populate Bulk of Data from a DB Table into a Combo Box? - C#.NET

  - by peace

  MenuItem menus = new MenuItem(); GridView1.DataSource = menus.GetDataTable(); GridView1.DataBind(); menus.GetDataTable() returns a DataTable. In the above case, we are returning to GridView. I need to populate the data into a combo box. How can i do it? NOTE: Assume GetDataTable only returns records of a single column.

  Read the article

• MySQL: count enumerated values?

  - by John Isaacks

  If my table looks like this: daily_individual_tracking', 'CREATE TABLE `daily_individual_tracking` ( `daily_individual_tracking_id` int(10) unsigned NOT NULL auto_increment, `daily_individual_tracking_date` date NOT NULL default ''0000-00-00'', `sales` enum(''no'',''yes'') NOT NULL COMMENT ''no'', `repairs` enum(''no'',''yes'') NOT NULL COMMENT ''no'', `shipping` enum(''no'',''yes'') NOT NULL COMMENT ''no'', PRIMARY KEY (`daily_individual_tracking_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 basically the fields can be either yes or no. How can I count how many yes's their are for each column over a date range? Thanks!!

  Read the article

• SQL - First row inserted every day for the past X days

  - by okie.floyd

  A tough SQL question (I'm using postgres by the way). I need the first row inserted every day for the past X days. one of my columns is a timestamp, which i hold the time inserted, and another column is the row id. If it's not possible to get the first row inserted every day, i at least need a unique one; a single row for every day for the past x days. Any suggestions? Thanks okie

  Read the article

• Changing GORM table name

  - by Matthias Hryniszak

  Hi I'm fighting to get the following mapping working in Grails 1.3.1 and MySQL: class Login { int id String email static mappings = { table 'my_table' id column: "Mgr_id" version: false } } No matter what I do the queries that are being issued refer to "schema.login" table instead of "schema.my_table". This is very frustrating... Can anyone answer why this might not be working?

  Read the article

• How to count how many items for distinct items in mysql?

  - by Vincent Duprez

  Imagine a have a table with a column named status: status ------ A A A B C C D D D How can I count how many rows have A, how many rows have B etc? this kind of output: A |B |C |D |E ------------------ 3 |1 |2 |3 |0 As for E = O , this will always be A,B,C,D and E Output should be one row (thus 1 query). When doing a distinct count (most returning answer on my searches, it does return how many different elements there are, 4 in this case...)

  Read the article

• What method can I override in GridViewHeaderRowPresenter to prevent it from drawing some columns?

  - by Carlo

  The thing is that I created a custom column that inherits from GridViewColumn, and I added a Visibility dependency property to it. Now I want to create a custom GridViewHeaderRowPresenter, that does not draw the columns when their visibility is hidden or collapsed, but other than the OnRender() method, I can't think of anything else. Thanks. Btw, the reason I'm doing this is because removing or adding columns doesn't work like we would expect it (some specs for our app) and I believe what I'm trying to do here would work if pulled out correctly.

  Read the article

• How to create textbox in Microsoft Reporting Service?

  - by user351684

  I have create a report in Microsoft Reporting Service that is presented in a browser. I would like to create button that opens a textbox where the user can fill in text. This text should be saved in column in the underlying database.

  Read the article

• Load a .bin file in SQL server 2005 Express database in vc++ application

  - by Feroz Khan

  I would like to put a binary file in varbinary(MAX) column using _RecordsetPtr in a vc++ application.I am sure that lot of people have done this before. But I am new to database programming. Help is urgently needed ...Thanks in advance.

  Read the article

• How to solve - Illegal mix of collations in mysql?

  - by rocksolid

  Am getting the below error when trying to do a select through a Stored procedure in mysql. Illegal mix of collations (latin1_general_cs,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=' Any idea on what might be going wrong here? The collation of the table is latin1_general_ci and that of the column in the where clause is latin1_general_cs Thanks!

  Read the article

• Arrangement of n objects in a n x n square

  - by Hwang

  if have multiples object, how to arrange it so that each number of object in row x column will form a near square? exp:14 objects arrange to something like this: 0 0 0 0 0 0 0 0 0 0 0 0 0 0

  Read the article

• Rails 3: How to validate that A < B where A and B are both model attributes ?

  - by Misha Moroshko

  I would like to validate that customer_price >= my_price. I tried the following: class Product < ActiveRecord::Base attr_accessor :my_price validates_numericality_of :customer_price, :greater_than_or_equal_to => my_price ... end (customer_price is a column in the Products table in the database, while my_price isn't.) Here is the result: NameError in ProductsController#index undefined local variable or method `my_price' for #<Class:0x313b648> What is the right way to do this in Rails 3 ?

  Read the article

• problem with reading arabic in jsp page?

  - by sword101

  Hey there i have a column in the databsePostgreSQL which contains arabic data when reading the data from the database in the controller it's read fine, encoding is good but when sending the data to the jsp page and trying to read it it appears something like ????????? any ideas why something like this occur?

  Read the article

• Data table in win form

  - by Lumpy

  I want to copy two columns from excel and work on them in a c# program. What component is the best to use to mimic an excel column in a win form?

  Read the article

• Return dataset in dataflow

  - by praveen

  Hi All, Could I get ideas on retrieving the dataset using lookup method. Basically, my scenario as I have source data needs to lookup for other source table and on matching column from source I need to get all the records from other source data. its a one to many relations. I tried Lookup but gives only one record on matching condition, OLE DB command don't retrieve any data as it will do only Insert/Update operations. Thanks prav

  Read the article

• What's an efficient way to convert month and year string to a date?

  - by adam0101

  I have column with varchar values like "022008" that I need to convert into a datetime like "02/01/2008". This will run on millions of records for a conversion process. What is an efficient select statement for doing this?

  Read the article

• Jasper Report.....................

  - by vipul

  Hello Friends, Actually I am working on Pdf by using IReport Software. This software provided two detail section but i want this two detail section with Column Header .then say me how i changes it reply me on [email protected]

  Read the article

• How can I make a list in a Repeater Section?

  - by JPJedi

  I need to create a repeater section that will show 4 columns - First Name, Last Name, a link based off of stored column data that says. All the data plus some extra not being used is in a players profile. How do I link the data on the code-behind to the repeater control with the databinders? I am using visual studio 2008, VB.NET for the code behind.

  Read the article

• How to use split in SQL Server 2005?

  - by meenakshi

  Table column has values with comma separated for ex: (1,2,3) How to split this like 1 2 3 or 1 2 3 in SQL Server 2005.

  Read the article

• sort arrow is always showing up once sorting is used

  - by kksachin

  we have several pages as tabs where datatable is used in most of the pages.when we sort on a particular coulmn and exit the page and re enter this page the arrow appears(up /down based on how we left) Although the data is not sorted in the direction the arrow shows.i have set preserveSort and preserveDataMode to false. The arrow is set to true in the column's t:commandSortHeader tag in all the pages. is this a bug or am i missing any setting?I have tried to set forceId to false in t:commandSortHeader but of now use.

  Read the article

• Customview like tableview in iphone SDK?

  - by senthilmuthu

  hi, I want to do custom tableview which scrolls horizontally.If you see this URL If you go to SUPERLIST tab in flash iphone simulator,you can see one column is differed from other columns which scrolls horizontally.any idea to do this?any help please?

  Read the article

• Is there any query in sqlite to choose a substring ?

  - by john terry

  Hey, Lets say I have a table Y with column X. There is one row of "X" with the string "abcdefg", and another row with "qwerty". Can I make a SELECT query in sqlite to choose the row which contains the substring "abcd" ? Thanks in advance.

  Read the article

• Jquery's a FREE grid display

  - by mmcgrail

  I have been using Flesigrid for my CMS and I like it except there are some things I think it could do better like get the column headers from the ajax results rather then in the setup of the flexigrid or having the ability to change the buttons on reload things of that nature. I've been considering a mod of the plugin though I'm not sure i really want to do that. But the question is ... is there something that might be better that I somehow missed when I was looking for grid display ?

  Read the article

• Save Field Names in Microsoft SQL Query Analyzer

  - by Michael Shnitzer

  When you save the results of a SQL query using "Microsoft SQL Query Analyzer" (version 8), the results of the query are saved but the column headers (field names) are not. Any idea how to save the field names to the results file as well?

  Read the article

• Character encoding issues?

  - by Santosh

  We had a a clob column in DB. Now when we extract this clob and try to display it (plain text not html), it prints junk some characters on html screen. The character when directly streamed to a file looks like ” (not the usual double quote on regular keyboard) One more observation: System.out.println("”".getBytes()[0]); prints -108. Why a character byte should be in negative range ? Is there any way to display it correctly on a html screen ?

  Read the article

• Performance with timestamp conditions

  - by Tim Whitlock

  Which of the following is faster, or are they equivalent? (grabbing recent most records from a TIMESTAMP COLUMN) SELECT UNIX_TIMESTAMP(`modified`) stamp FROM `some_table` HAVING stamp > 127068799 ORDER BY stamp DESC or SELECT UNIX_TIMESTAMP(`modified`) stamp FROM `some_table` WHERE UNIX_TIMESTAMP(`modified`) > 127068799 ORDER BY `modified` DESC or even another combination?

  Read the article

< Previous Page | 310 311 312 313 314 315 316 317 318 319 320 321  | Next Page >