RE: [sqlite] SELECT ORDER BY failure
No, we are actually filling in the parameter with a valid integer value. I was just trying to say it was a parameter. > > Are you actually searching for records where F is the string "?" > > If so, why don't you try WHERE F="?" instead of leaving it with the > ? unquoted. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SELECT ORDER BY failure
"Mark Brown" <[EMAIL PROTECTED]> wrote: > Hi- > > We have a query that is failing with SQLite error code 10: > > SELECT A, B, C, D, E, F, G > FROM Table1 > WHERE F=? > ORDER BY E > > but succeeds when the ORDER BY clause is removed. > > This database does not have any indicies on any of the tables. Is this why > it is failing? > When it does not have an index, SQLite sorts by creating a temporary index in a temporary database. The temp database is located in some standard place like /var/tmp. The sqlite3OsTempFileName() backend method names the temp database. Error code to is an I/O error. Likely something is wrong with the temp database file. Maybe the directly is read only or something like that. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SELECT ORDER BY failure
Mark Brown wrote: > Hi- > > We have a query that is failing with SQLite error code 10: > > SELECT A, B, C, D, E, F, G > FROM Table1 > WHERE F=? > ORDER BY E > > but succeeds when the ORDER BY clause is removed. > > This database does not have any indicies on any of the tables. Is this why > it is failing? Are you actually searching for records where F is the string "?" If so, why don't you try WHERE F="?" instead of leaving it with the ? unquoted. -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 - To unsubscribe, send email to [EMAIL PROTECTED] -