To answer a previous question, here is an example of stCmdString contents:
stCmdString = "SELECT fstPriority, fstInfo, fiKeyID FROM PadTable
WHERE fstInfo LIKE '%macro%'"
This works.
On Thu, Jan 26, 2017 at 9:40 AM, Clyde Eisenbeis <cte...@gmail.com> wrote:
> Not finding much.
>
> I will try searching for a single word:
>
> string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName
> + " WHERE " + stLikeFieldName + " LIKE ('%' || ?1 || '%') ";
>
> When I tried entering:
>
> sqlite3_bind_
>
> the compiler starts complaining.
>
> On Thu, Jan 26, 2017 at 9:18 AM, Clyde Eisenbeis <cte...@gmail.com> wrote:
>> I'm searching the internet for sqlite3_bind_* () examples.
>>
>> On Thu, Jan 26, 2017 at 9:14 AM, Andy Ling <andy.l...@s-a-m.com> wrote:
>>> I think the point is, you need to use a prepared statement and bind the
>>> parameters to it.
>>> The bind process handles the special characters.
>>>
>>> So you will need to create a command string with question mark operators in
>>> like
>>>
>>> stCmdString += " AND fstInfo LIKE ('%' || ?1 || '%') AND fstInfo
>>> LIKE ('%' || ?2 || '%')"
>>>
>>> Then use the sqlite3_bind_* () calls to replace the ?n markers with the "
>>> liststLikeFieldValue" strings.
>>>
>>> HTH
>>>
>>> Andy
>>>
>>> -----Original Message-----
>>> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
>>> Behalf Of Clyde Eisenbeis
>>> Sent: Thu 26 January 2017 15:04
>>> To: SQLite mailing list
>>> Subject: Re: [sqlite] Using SQLite, how can I search for chars that include
>>> a ', similar to OLE DB .Parameters?
>>>
>>> I've also tried:
>>>
>>> string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName
>>> + " WHERE " + stLikeFieldName + " LIKE ('%' || " +
>>> liststLikeFieldValue[0] + " || '%')";
>>>
>>> which does not work.
>>>
>>> On Thu, Jan 26, 2017 at 8:14 AM, heribert <herib...@scharnagl.com> wrote:
>>>> There are some missing spaces i think:
>>>>
>>>> string stCmdString = "SELECT " + stFieldNames + " FROM " + stTableName
>>>> + " WHERE " + stLikeFieldName + " LIKE '%'||" +
>>>> liststLikeFieldValue[0] + "||'%'";
>>>>
>>>> Am 26.01.17 um 15:04 schrieb Clyde Eisenbeis:
>>>>>
>>>>> I tried replacing this:
>>>>>
>>>>>
>>>>> string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName
>>>>> + " WHERE " + stLikeFieldName + " LIKE '%" + liststLikeFieldValue[0] +
>>>>> "%'";
>>>>>
>>>>> with this:
>>>>>
>>>>> string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName
>>>>> + " WHERE " + stLikeFieldName + " LIKE '%'||" +
>>>>> liststLikeFieldValue[0] + "||'%'";
>>>>>
>>>>> Does not work.
>>>>>
>>>>> On Wed, Jan 25, 2017 at 11:53 AM, Richard Hipp <d...@sqlite.org> wrote:
>>>>>>
>>>>>> On 1/25/17, Warren Young <war...@etr-usa.com> wrote:
>>>>>>>
>>>>>>> stCmdString += " AND ‘%?1%’ LIKE ‘%?2%’”;
>>>>>>>
>>>>>>> Then use the sqlite3_bind_*() calls to insert parameters 1 and 2 into
>>>>>>> the
>>>>>>> string.
>>>>>>
>>>>>> Not quite. You cannot have parameters embedded in the middle of
>>>>>> strings. The whole string is replaced by a parameter.
>>>>>>
>>>>>> stCmdString += " AND fstInfo LIKE ?1 AND fstInfo LIKE ?2"
>>>>>>
>>>>>> Then the application has to prepend and append the "%" on the strings
>>>>>> before binding. Or, if your application does not want to do that:
>>>>>>
>>>>>> stCmdString += " AND fstInfo LIKE ('%' || ?1 || '%') AND fstInfo
>>>>>> LIKE ('%' || ?2 || '%')"
>>>>>>
>>>>>> Then you can bind the search patterns directly to ?1 and ?2. (Aside:
>>>>>> || is the string concatenation operator in SQL.)
>>>>>>
>>>>>> --
>>>>>> D. Richard Hipp
>>>>>> d...@sqlite.org
>>>>>> _______________________________________________
>>>>>> sqlite-users mailing list
>>>>>> sqlite-users@mailinglists.sqlite.org
>>>>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>>>>
>>>>> _______________________________________________
>>>>> sqlite-users mailing list
>>>>> sqlite-users@mailinglists.sqlite.org
>>>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>>>
>>>>
>>>> _______________________________________________
>>>> sqlite-users mailing list
>>>> sqlite-users@mailinglists.sqlite.org
>>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>> _______________________________________________
>>> sqlite-users mailing list
>>> sqlite-users@mailinglists.sqlite.org
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>> ---------------------------------------------------------------------------------------
>>> This email has been scanned for email related threats and delivered safely
>>> by Mimecast.
>>> For more information please visit http://www.mimecast.com
>>> ---------------------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> sqlite-users mailing list
>>> sqlite-users@mailinglists.sqlite.org
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
