Re: [sqlite] Problem when binding with like

On Fri, 2005-07-01 at 20:22 -0500, Dan Wellisch wrote: > Richard: > > Are you saying that the statement should be.: > > wxString::Format(wxT("%s%s"),zipCodeValue.c_str(), "%"); > Yes. Or perhaps this: wxString::Format(wxT("%s%%"), zipCodeValue.c_str()); -- D. Richard Hipp <[EMAIL

Re: [sqlite] Problem when binding with like

Richard: Are you saying that the statement should be.: wxString::Format(wxT("%s%s"),zipCodeValue.c_str(), "%"); ? Thanks, Dan D. Richard Hipp wrote: On Fri, 2005-07-01 at 14:51 -0500, Dan Wellisch wrote: zipCodeValue = wxString::Format(wxT("%s%s%s%s"),"'",zipCodeValue.c_str(),

Re: [sqlite] Problem when binding with like

On Fri, 2005-07-01 at 14:51 -0500, Dan Wellisch wrote: > zipCodeValue = > wxString::Format(wxT("%s%s%s%s"),"'",zipCodeValue.c_str(), "%","'"); > > rc = sqlite3_bind_text (rowdata,2, zipCodeValue.c_str(), > zipCodeValue.Len(), SQLITE_STATIC); > Do not put quotes around strings that are

[sqlite] Problem when binding with like

Hello: //rc = sqlite3_prepare(db, "select latitude, longitude from zip_code where country_id = ? and zip_code like ?", -1, , 0); After I bind a string of the form '6008%' to the ? with: sqlite3_bind_text and then execute sqlite3_step(rowdata), the sqlite3_step fails. Following is my code

[sqlite] re: Where can I find all of these [date/time] functions documente d?

regarding: Where can I find all of these [date/time] functions documented? See: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Which is linked from the front of the wiki: http://www.sqlite.org/cvstrac/wiki Donald Griggs Columbia SC, USA Opinions are not necessarily those

Re: AW: [sqlite] time zone?

On Friday 01 July 2005 08:58 am, [EMAIL PROTECTED] wrote: > Try select time('now', 'localtime'); > Michael that did it! come to think of it .. I don't remember date saying CDT before. Where can I find all of these functions documented? I searched the sqlite docs but didn't find anything. unless

AW: [sqlite] time zone?

Try select time('now', 'localtime'); Michael -Ursprüngliche Nachricht- Von: Stephen Leaf [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 1. Juli 2005 15:47 An: sqlite-users@sqlite.org Betreff: [sqlite] time zone? sqlite> select time('now'); 13:45:20 $ date Fri Jul 1 08:45:37 CDT 2005

RE: [sqlite] time zone?

Hi, I am not sure but one is in GMT and other maybe in your local time zone. Regards Sudhir -Original Message- From: Stephen Leaf [mailto:[EMAIL PROTECTED] Sent: Friday, July 01, 2005 9:47 AM To: sqlite-users@sqlite.org Subject: [sqlite] time zone? sqlite> select time('now');

[sqlite] time zone?

sqlite> select time('now'); 13:45:20 $ date Fri Jul 1 08:45:37 CDT 2005 anyone know what's wrong? thanks, Stephen

[sqlite] SQL syntax - please help

Hello all, I'm trying to form a specific query, but not sure if that's possible at all and if it is, how it should look like. I'd really appreciate your help :-) I have 2 tables (simplest case, but once I know this, I can work out the rest): CREATE TABLE TableA( UID INTEGER PRIMARY KEY,