Re: [sqlite] Problem when binding with like

[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(), "%","'");

rc = sqlite3_bind_text (rowdata,2, zipCodeValue.c_str(), zipCodeValue.Len(), SQLITE_STATIC);

Do not put quotes around strings that are bound. Just insert them directly. You are trying to LIKE against '''6008%''', not

'6008%' as you intend.