Re: [sqlite] Problem when binding with like

2005-07-01 Thread D. Richard Hipp
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 PROTECT

Re: [sqlite] Problem when binding with like

2005-07-01 Thread Dan Wellisch
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

2005-07-01 Thread D. Richard Hipp
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

2005-07-01 Thread Dan Wellisch
Hello: //rc = sqlite3_prepare(db, "select latitude, longitude from zip_code where country_id = ? and zip_code like ?", -1, &rowdata, 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 m