If you really only have hundreds of records, and you aren't doing many queries as part of the same operation, you have spent more time fighting through this than you will save in the rest of your life running it.
On Fri, Sep 9, 2016 at 12:42 AM, Kay C Lan <lan.kc.macm...@gmail.com> wrote: > On Fri, Sep 9, 2016 at 6:37 AM, Dr. Hawkins <doch...@gmail.com> wrote: > > > > Do you include a delimiter after your first and last entries? It seems > > clumsy, but I don't see a way around it with LIKE > > WHERE dpdDnas LIKE '7,%' OR dpdDnas LIKE '%,7,%' OR dpdDnas LIKE '%,7' > > I've found that leaving the list as a 'natural' LC List creates less > headaches down the track than the SQL triplicate OR statement. > > _______________________________________________ > 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 > -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." _______________________________________________ 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
