Search Results

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

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

• 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

• Reading Excel by OLEDB reads strings as DBNull

  - by Sathish

  I am reading Excel file using OLEDB in Csharp i have shown the sample excel data what i have F1 F2 F3 F4 India 23 44 4 China 4 8 Month 6 USA 45 Neg 4 When i read this data and check in my DataTable i get Null values for "Month 6" and "Neg" where as i can be able get the F1 column correctly... my connection string is as shown Provider=Microsoft.ACE.OLEDB.12.0;Data Source=[XLSource];Extended Properties=Excel 12.0;

  Read the article

• SQL Query Theory Question...

  - by Keng

  I have a large historical transaction table (15-20 million rows MANY columns) and a table with one row one column. The table with one row contains a date (last processing date) which will be used to pull the data in the trasaction table ('process_date'). Question: Should I inner join the 'process_date' table to the transaction table or the transaction table to the 'process_date' table?

  Read the article

• How Do I Hide wpf datagrid row selector

  - by Tim Almond

  I'm using the WPF DataGrid control to show some details and a select button, and I don't need the grey selector column down the left hand side. It's also ruining the beauty of my design ;) Is there a way to remove it, or how can I style it to match if not?

  Read the article

• How to get data from database but from the exact row?

  - by Nitz

  Hey Guys, I am using mysql. Now I want to write that query in which i will give mysql the row number then mysql will data from that column no only. means.. if i have twenty rows in database but i want to get only 10th no of rows data? so how to write that kind query?

  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

• JQuery duplicate alerts on update? why?

  - by russp

  I have this JQuery function - that nearly works (so far!) BUT the alerts are duplicated, each appears twice any clues/ideas please $(function() { $("#col1, #col2, #col3").sortable({ connectWith: '.column', update : function () { serial = $('#col1').sortable('serialize'); serial1 = $('#col2').sortable('serialize'); serial2 = $('#col3').sortable('serialize'); alert(serial); alert(serial1); alert(serial2); } }); });

  Read the article

• How to find the row ID from datagridview, given a row value?

  - by user361108

  Hi, Can anyone help me please? I have to find the row number from 1 selected array which I stored in one separate array and randomly I'm trying to get the row number from datagridview http://serv8.enterupload.com/i/00246/aewglahmvpr5.jpg In other words: if I know a column value for a given row in a datagridview (e.g. for this row, FirstName == 'Bud'), how can I get the row ID?

  Read the article

• How to sort this rebol domain names block on date ?

  - by Rebol Tutorial

  I want to sort this block on date column: ["domain1.com" 18-Jan-2011 #"^/" "domain2.com" 20-Aug-2011 #"^/" "domain3.com" 23-Dec-2011 #"^/" "domain4.com" 22-Sep-2011 #"^/"] I can't see how to really do so with sort/skip function explained here, it's not crystal clear for me: http://www.rebol.com/docs/words/wsort.html

  Read the article

• Is relative positioning the ultimate alternative for the nightmare of writing thousands of IE hacks?

  - by janoChen

  I found this very interesting: http://matthewjamestaylor.com/blog/ultimate-3-column-holy-grail-pixels.htm He avoid using horizontal margin and paddings to avoid problems with IE. I think he "fakes" padding using relative positioning. Have you ever done something like this? I'm a missing a common trend against IE hacks? Does this practice have any drawbacks?

  Read the article

• How to create 2D jagged array

  - by Ram

  In my code an array is declared as follows private Object[,] cellInfos = new Object[20, 10]; I need to convert it into Jagged array so I wrote following code private Object[][] cellInfos = { new Object[20], new Object[10] }; But it gave me a array with 2 items each of type array. I need to create 2D array where new Object[20] would be first column and new Object[10] would be the second one. Thanks.

  Read the article

• Rails: Serializing objects in a database?

  - by keruilin

  I'm looking for some general guidance on serializing objects in a database. What are serialized objects? What are some best-practice scenarios for serializing objects in a DB? What attributes do you use when creating the column in the DB so you can use a serialized object? How to save a serialized object? And how to access the serialized object and its attributes? (Using hashes?)

  Read the article

• Problem with Oracle 10g for writing trigger that will create CSV file with the contents of the data

  - by kishore

  How can a trigger be written which is invoked after updating a particular column in the table and creates a CSV file with the contents of same table? I am using Oracle 10g.

  Read the article

• php code for inserting text file into the database

  - by rabeea

  hey i have form which has a file field. After selecting a file,i want to insert the selected file into the database column. how do i do it?

  Read the article

• SQL Server identity counterpart problem

  - by Guru

  Hi there, I'm using SQL Server and I want to use identity constraint in it I know how to use it in following manner create table mytable ( c1 int primary key identity(1,1); ) the above code works fine but what if i want the identity column to have values as EMP001, EMP002,... instead of 1,2.... Thanks in advance, Guru

  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

• pgSQL query error

  - by running4surival

  i tried using this query: "SELECT * FROM guests WHERE event_id=".$id." GROUP BY member_id;" and I'm getting this error: ERROR: column "guests.id" must appear in the GROUP BY clause or be used in an aggregate function can anyone explain how i can work around this?

  Read the article

• Enumerate through Grid cell in WPF

  - by netmajor

  hey, I have Grid with 10 rows and 10 column, and I want in code behind get to every of this grid cell to change this background or add image to cell, How can I do it ?

  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

• 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

• Question on jpa joined table inheritance

  - by soontobeared

  Hi, The 'DiscriminatorColumn' annotation isn't creating any column in my parent entity. Where am I going wrong ? Here's my code @Entity @Inheritance(strategy=InheritanceType.JOINED) @DiscriminatorColumn(name="TYPE", discriminatorType=DiscriminatorType.STRING,length=20) public class WorkUnit extends BaseEntityClass implements Serializable{ @Entity @DiscriminatorValue(value="G") @Table(name="Group_") @PrimaryKeyJoinColumn public class Group extends WorkUnit implements Serializable{

  Read the article

• TSQL to combine a date field and a time field

  - by justSteve

  Using logparser to import IIS logs to a db results in one column that has the date value and a second field for time: 2010-05-25 00:00:00.000 2010-01-01 11:11:58.000 I'd like to code an INSERT AFTER trigger that combines the 2 fields.

  Read the article

• Table in DB for generating primary keys?

  - by Sapphire

  Do you ever use a separate table for "generating" artificial primary keys for DB (and why)? What I mean is to have a table with two columns, table name and current ID - with which you could get new "ID" for some table by simply locking the row with that table name, getting the current value of the key, increment it by one, and unlock the row. Why would you prefer this over standard integer identity column? P.S. The "idea" is from Fowlers Patterns of Enterprise Application Architecture, btw...

  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

• The right way to write "ID" in columns in SQL

  - by radbyx

  My first question in here. I like the site so much :) I've a SQL table called Product. In that table I want to make a column for the ID of the product, and I really like to now the right way of write ID because I make alot of ID columns in the long run. So is it: "ID" or "Id" ? And also a foreign key in another table, is that called ProductID or ProductId? Thx guys.

  Read the article

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