Try LIKE :1 with tfld containing your search text enclosed in % characters.
Pete lcSQL Software On Mar 14, 2014 10:44 PM, "Stephen MacLean" <smacl...@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
