revDataFromQuery with variable list question

[Peter Haworth]

Try LIKE :1 with tfld containing your search text enclosed in % characters.

Pete
lcSQL Software
On Mar 14, 2014 10:44 PM, "Stephen MacLean" <smaclean at madmansoft.com> wrote:

> Hi All,
>
> I'm having a problem with this:
>
> put "SELECT mFromGUID from messages WHERE (mTextContent LIKE '%:1%')"
>  into gMsgListQuery
>
> put revDataFromQuery(,comma, gDatabaseID, gMsgListQUERY,"tFld") into
> tSearchResult
>
> puts nothing into tSearchResult and the result is empty.
>
> Do I have escape something differently? Or just missing something?
>
> TIA,
>
> Steve MacLean
>
>
>
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>