Search Results

Search found 10060 results on 403 pages for 'column'.

Page 234/403 | < Previous Page | 230 231 232 233 234 235 236 237 238 239 240 241  | Next Page >

• Oracle row change time stamp

  - by IMHO

  Is there a system column - timestamp - in Oracle table to determine when was it changed last time? I would assume there must be one to let mat views pull changes only ...

  Read the article

• Get records using left outer join

  - by Devendra Gohil

  I have two tables as given below Table A Table B Table C ============= ============== ========= Id Name Id AId CId Id Name 1 A 1 1 1 1 x 2 B 2 1 1 2 y 3 C …

  Read the article

• How can i interpret a time value in ascii into a numerical value?

  - by Bilal

  I have a file which is as follows: 15:03:21 II 0.88 0.64 15:03:31 II 0.88 0.64 15:03:42 II 0.40 0.40 etc. after loading the file in matlab, I want to be able to read the first column (which corresponds to time) and interpret them as numerical values. At the moment, they are interpreted as a string of ascii characters and i can't…

  Read the article

• Load test results VSTS 2008

  - by Julia

  Can anybody explain why load test result on Graph are different form load test result on Table Page. If compare Min and Avg page response time they are the same. But if we compare figures in Max column they are different for the same page and the same load rest run. see linked images for more details.…

  Read the article

• DateField in a gridpanel

  - by manale

  i have a gridpanel with a datefield column, when my application is in english the datefield is working fine, but when my application is using french my datefield language is changed to french but the time doesn't change in the gridpanel cell. so any idea?

  Read the article

• MySQL don't want to store unicode charecter

  - by Qiao

  Why MySQl don't wont to store unicode character ??? Yes, it is rare hieroglyph, you wouldn't see it in the browser. UTF16 is U+2B5EE Warning: #1366 Incorrect string value: '\xF0\xAB\x97\xAE' for column 'ch' at row 1 Is it possible to store this character in MySQL?

  Read the article

• Sort data in GtkTreeView non-alphabetically?

  - by paultop6

  I'm trying to sort a column of data in a GTK tree view non-alphabetically. I can't seem to find a function in the GTK+ libraries that cant do such a thing. Does anyone here know of a way to do this?

  Read the article

• Where clause in Fluent NHibernate Many-to-Many

  - by Adam Albrecht

  I am trying to setup a many-to-many mapping in Fluent Nhibernate that has a where clause attached to the child table. This is basically how it should work: HasManyToMany(p => p.Images) .Table("ProductImages") .ParentKeyColumn("ProductID") .ChildKeyColumn("ImageID") .Where("ImageTypeID =…

  Read the article

• Django save method

  - by Marijus

  So I have a model with a FileField for excel spreadsheet. What I need to do this add another column in this spreadsheet, in each row let user pick from a drop-down list then save it and display it in html. All the picking and uploading will happen through the admin interface. So I have figured out…

  Read the article

• IF statement error

  - by Jasl

  I have the following columns in TableA TableA Column1 varchar Column2 int Column3 bit I am using this statement IF Column3 = 0 SELECT Column1, Column2 FROM TableA WHERE Column2 > 200 ELSE SELECT Column1, Column2 FROM TableA WHERE Column2 < 200 But the statment…

  Read the article

• How to set default date time as system date time in mysql

  - by Shantanu Gupta

  I am trying to set my columns default date time to system datetime. It shows me an error Invalid default value for 'InsertionDate' alter table `vts`.`tblpickpoint` add column `InsertionDate` datetime DEFAULT 'Now()' NULL after `PickPointLatLong`

  Read the article

• Saving any file to in the database, just convert it to a byte array?

  - by Blankman

  Is converting a file to a byte array the best way to save ANY file format to disk or database var binary column? So if someone wants to save a .gif or .doc/.docx or .pdf file, can I just convert it to a bytearray UFT8 and save it to the db as a stream of bytes?

  Read the article

• how can I insert value into a table in sql server 2000 , 2005, 2008?

  - by ricky roy

  I have a table having a single auto Auto Incremented column. How Can i insert the value. Using Insert into table or some other way Thanks Waiting for your replay..

  Read the article

• SEC_TO_TIME() convert to java.sql.Time error

  - by chun

  hi I have a aggregate column present the microsecond, a report(with jasper) have to show HH:mm:ss of this indicator What I did is using SEC_TO_TIME(sum(col)/1000) , but when mapping to java.sql.Time, i doesn't work when the value of hour in result pass over 24(ex:36:33:33) Then I think…

  Read the article

• SQL CASE WHEN NULL - question

  - by cc0

  Ok, so I'm trying to select an amount of rows from a column that holds the value 3, but only if there are no rows containing 10 or 4, if there are rows containing 10 or 4 I only want to show those. What would be a good syntax to do that? So far I've been attempting a CASE WHEN statement,…

  Read the article

• get a simple list from sqlite in python (not a list of tuples)

  - by Jeremiah Rose

  it's annoying how sqlite always returns a list of touples! i can see the why this is necessary, but when i am querying a single column, how do i get a plain list? e.g cursor.fetchall() returns [(u'one',), (u'two',), (u'three',)] from this, how do i get the simple list [u'one', u'two',…

  Read the article

• mysql select two prior to and one after NOW()

  - by Flavius

  Hi I have a table with a column event_time. How can I select two rows right before NOW() and the next one after NOW(), ordered by event_time? Is is possible with a single query?

  Read the article

• Overriding an ActiveRecord attribute

  - by jspooner

  I have a model with a completed:boolean column that I'd like override so I can add some conditional code. I've never override an ActiveRecord attribute before and wanted to know if the method below is good practice? class Article < ActiveRecord::Base def completed=(b) …

  Read the article

• Saving an XML that has invalid characters

  - by BDotA

  there are code snippets that strip the invalid characters inside a string before we save it as an XML ... but I have one more problem: Let's say my user wants to have a column name like "[MyColumnOne] ...so now I do not want to strip these "[","] well because these are the ones…

  Read the article

• Can you send a full result set to an SQL function?

  - by PylonsN00b

  I am working in Postgres and I need to send in a full result set with many rows and column into a stored procedure or a function. Is this possible? If so, where can I see resources for syntax?

  Read the article

• Query a stored procedure for it's parameter names and types

  - by ho1

  Is there any easy way to query a stored procedure (Oracle - PL/SQL) for what parameters it expects? I know that I can query USER_SOURCE to get the whole procedure but I'd then have to parse the whole procedure, and if the parameter is of type [table].[column]%TYPE I'd then have…

  Read the article

• not single-group grouping function while using regr_slope

  - by Peter Kaleta

  HI I try to run : select year, regr_slope(sum(sale_count),year) as slope, from products group by year It throws "00937. 00000 - "not a single-group group function"" .When i delete year from select clause problem disapears. Shouldn't I be able to select column with…

  Read the article

• How to access SysListView32 elements in QTP?

  - by Onnesh

  We are having a table of elements in SysListView32. Actually they are a table arranged under 5 columns. How to access 3rd column in the table in SysListView32?

  Read the article

• Animate cell within a table

  - by amok

  That's what I have: - A table with a few rows, one column only What I am trying to accomplish: Double tap on any row should produce an animation of the cell. The animation that I want is a flip vertically of the row. I am displaying some data in each row and what I want…

  Read the article

• generic Mysql stored procedure

  - by psu

  Hi, I have the fallowing stored procedure: CREATE PROCEDURE `get`(IN tb VARCHAR(50), IN id INTEGER) BEGIN SELECT * FROM tb WHERE Indx = id; END// When I call get(user,1) I get the following: ERROR 1054 (42S22): Unknown column 'user' in 'field list'

  Read the article

< Previous Page | 230 231 232 233 234 235 236 237 238 239 240 241  | Next Page >