[sqlite] newbie problem with select statement using 'AND'

I'm using sqlite for my perl cgi website but I've got a problem with the following select statement... SELECT userID FROM members WHERE userName='John' AND userOccupation='Carpenter' Yet if I input this statement from the sqlite3 command prompt it works! The problem seems to be with the 'and', t

Re: [sqlite] newbie problem with select statement using 'AND'

On 9/18/08, hugh11 <[EMAIL PROTECTED]> wrote: > > I'm using sqlite for my perl cgi website but I've got a problem with the > following select statement... > > SELECT userID FROM members WHERE userName='John' AND > userOccupation='Carpenter' > > Yet if I input this statement from the sqlite

Re: [sqlite] newbie problem with select statement using 'AND'

Hi P Kishor-3 Thanks for your reply. I have altered my script according to your recommendation, unfortunately the problem remains. I have also used the eval{ } function to capture the log messages. The log said "no such column: userOccupation(1)" Not sure why it should append (1) to my column name

Re: [sqlite] newbie problem with select statement using 'AND'

On 9/18/08, hugh11 <[EMAIL PROTECTED]> wrote: > > Hi P Kishor-3 > Thanks for your reply. I have altered my script according to your > recommendation, unfortunately the problem remains. I have also used the > eval{ } function to capture the log messages. The log said "no such column: > user

Re: [sqlite] newbie problem with select statement using 'AND'

here is my simple test that works fine for me -- -- db -- [05:38 PM] ~/Sites/test$sqlite3 foo SQLite version 3.5.9 Enter ".help" for instructions sqlite> .s CREATE TABLE members (userID INTEGER PRIMARY KEY, userName TEXT, userOccupation TEXT); sqlite> SELECT * FROM members

Re: [sqlite] newbie problem with select statement using 'AND'

It's very strange. I used your example but I still get the same problem. I think I'll try this on a different machine tomorrow. P Kishor-3 wrote: > > here is my simple test that works fine for me -- > > -- db -- > > [05:38 PM] ~/Sites/test$sqlite3 foo > SQLite version