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.

-- 
D. Richard Hipp <[EMAIL PROTECTED]>

Reply via email to