[sqlite] how can i bound signed integer (negative) to an identifier in select query

Hi, I have a table with one of the columns storing negative integers in it. There is one function that performs different query operations on this table based on input range for those negative integers. When I try to use a select where query with an inequality using negative number semantics, the

Re: [sqlite] how can i bound signed integer (negative) to an identifier in select query

Is it possible that the data type of the column in the CREATE TABLE statement is not INTEGER but some other string? This web page: http://www.sqlite.org/datatype3.html describes the data type affinities applied for the various values of the data type in the create table statement, and if the

RE: [sqlite] how can i bound signed integer (negative) to an identifier in select query

Thanks for your reply Andrew, No, the column is defined as integer primary key. Regards, -shashikant -Original Message- From: Andrew Finkenstadt [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 7:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] how can i bound signed integer

Re: [sqlite] how can i bound signed integer (negative) to an identifier in select query

On Mon, 2007-07-23 at 19:33 -0700, Shashikant Shukla wrote: Hi, I have a table with one of the columns storing negative integers in it. There is one function that performs different query operations on this table based on input range for those negative integers. When I try to use a select