is among the words AND find words

Pete pete at mollysrevenge.com
Wed Dec 21 17:08:53 EST 2011


I think I tried that but the arguments aren't always comma delimited
unfortunately.  Somewhat related,I wish SQLite provided more formatted
access to the table structures.  Some stuff is available via the PRAGMA
statements but for other information, there's no alternative but to parse
the CREATE TABLE statement.  I think I found a series of SQL statements
once that built the equivalent of mySQL Information tables for SQLite but
now I can't find it!


On Wed, Dec 21, 2011 at 1:49 PM, Bob Sneidar <bobs at twft.com> wrote:

> OIC good point. But wouldn't it be better simply isolate the comma
> delimited arguments (usually in parens) in an SQL statement and then deal
> with them as items? But I suppose there are all kinds of special
> circumstances that would make a general purpose word function very unwieldy.
>
> Bob
>
> On Dec 21, 2011, at 1:17 PM, Pete wrote:
>
> > Not really - try parsing out an SQL SELECT statement.  Granted that's not
> > really English text but if you want to make this a general purpose
> > function, you have to deal with that circumstance.  I needed to do that
> and
> > ended up going through the text and inserting a space after each comma if
> > there wasn't already one there.
> >
> > On Wed, Dec 21, 2011 at 12:54 PM, Bob Sneidar <bobs at twft.com> wrote:
> >
> >> I suppose it could be argued that everything would break down if the
> text
> >> were "now,is,the,time,for,all,goo,men..." but at some point we have to
> >> presume the absence of the absurd? to have 2 words split by a comma is a
> >> problem with the data, not with the software.
> >>
> >> Bob
> >>
> >>
> >> On Dec 21, 2011, at 12:09 PM, Mark Wieder wrote:
> >>
> >>> Yes, but... if the phrase is "now is the time,for all good men" then a
> >>> search for "all" will return 5 instead of 6.
> >>>
> >>> --
> >>> -Mark Wieder
> >>> mwieder at ahsoftware.net
> >>
> >>
> >> _______________________________________________
> >> 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
> >>
> >>
> >
> >
> > --
> > Pete
> > Molly's Revenge <http://www.mollysrevenge.com>
> > _______________________________________________
> > 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
>
>
> _______________________________________________
> 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
>
>


-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>



More information about the Use-livecode mailing list