Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-16 Thread Daniel White
Thanks again Dan and Igor. Since I don't need to write to the database (only read from it atm), collate binary will do nicely. I'll keep an eye on those error messages in future! Dan On Sun, 15 Jun 2008 09:13:52 +0100, Dan <[EMAIL PROTECTED]> wrote: > On Jun 15, 2008, at 8:55 AM, Dan

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Daniel White
com/stuff/MMdatabase.zip (1.6 M) http://www.skytopia.com/stuff/sqlite.cpp (1k) Dan On Sat, 14 Jun 2008 15:54:50 +0100, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "Daniel White" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >>>

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Daniel White
tnik <[EMAIL PROTECTED]> wrote: > "Daniel White" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> The course of action I thought you implied was to change >> it from "hexion" to "Hexion", and so I hoped that would >> re

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Daniel White
promise rather than a fault with sqlite or SQL in general. Dan On Sat, 14 Jun 2008 14:34:12 +0100, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "Daniel White" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> Funny you should mention the

Re: [sqlite] SQlite and C works with "like" but not with "="

2008-06-14 Thread Daniel White
ro results are still returned. Oh one other quick question: Any way to get the number of rows/columns after preperation without using ssomething like sqlite3_get_table? Dan On Sat, 14 Jun 2008 05:23:00 +0100, Dan <[EMAIL PROTECTED]> wrote: > On Jun 14, 2008, at 10:39 AM, Daniel White

[sqlite] SQlite and C works with "like" but not with "="

2008-06-13 Thread Daniel White
Hi guys, My first post to this list, and I'm new to SQL in general too. Just a couple of questions to start: ***1: In the sqlite3_prepare_v2 function, can someone explain to me the 5th parameter better than the site's help can? I quote: /* OUT: Pointer to unused portion of zSql */ I'm a bit