Re: [sqlite] Results even if no rows

2006-07-13 Thread andrew gatt
> "andrew gatt" <[EMAIL PROTECTED]> writes: > > > I'm trying to come up with an SQL statement that works under sqlite that can > > return a list of rows depending if a list of ids exist. For individual > > checking i'm using: > > > > select 1 from table where id == 1; > > > > which returns a 1 if

Re: [sqlite] Results even if no rows

2006-07-13 Thread Derrell . Lipman
"andrew gatt" <[EMAIL PROTECTED]> writes: > I'm trying to come up with an SQL statement that works under sqlite that can > return a list of rows depending if a list of ids exist. For individual > checking i'm using: > > select 1 from table where id == 1; > > which returns a 1 if there is a row or

[sqlite] Results even if no rows

2006-07-13 Thread andrew gatt
Hi all, I'm trying to come up with an SQL statement that works under sqlite that can return a list of rows depending if a list of ids exist. For individual checking i'm using: select 1 from table where id == 1; which returns a 1 if there is a row or no rows if it doesn't exist. However i have