Re: [sqlite] problem with simple select

2008-07-11 Thread Sean Riley
s. > > Regards, Noah > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Sean Riley > Sent: Friday, July 11, 2008 5:04 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] problem with simple select > &g

Re: [sqlite] problem with simple select

2008-07-11 Thread Noah Hart
[mailto:[EMAIL PROTECTED] On Behalf Of Sean Riley Sent: Friday, July 11, 2008 5:04 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] problem with simple select Thanks for the quick response. My application is using 3.4.1, but I grabbed the 3.5.9 executable and got the same thing. SQLi

Re: [sqlite] problem with simple select

2008-07-11 Thread Sean Riley
ED] On Behalf Of Noah Hart > Sent: Friday, July 11, 2008 2:24 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] problem with simple select > > Sean, what version of sqlite are you using? > > > With the command line version it appears to work under 3.5.9 &g

Re: [sqlite] problem with simple select

2008-07-11 Thread Noah Hart
43301269412041|12.4330126941204|0.0|0.0|11|0|165|2 sqlite> Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean Riley Sent: Friday, July 11, 2008 2:08 PM To: sqlite-users@sqlite.org Subject: [sqlite] problem with simple select Hello, I h

[sqlite] problem with simple select

2008-07-11 Thread Sean Riley
Hello, I have a strange issue with a seemingly simple query. The table schema: CREATE TABLE ae_objects ( oid INTEGER PRIMARY KEY, nameVARCHAR(64), template_id INTEGER, template_module_id INTEGER, pos_x FLOAT, pos_y