adding a concatenated field in an SQL query breaks LIKE

Peter Haworth pete at lcsql.com
Sun Jul 13 19:52:55 EDT 2014


Certainly seems like something strange is happening.  Might be worth a:

SELECT cname || cadr ||reason || asset

.. and put the data into field to see what you get.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>


On Sun, Jul 13, 2014 at 12:05 PM, Dr. Hawkins <dochawk at gmail.com> wrote:

> On Sun, Jul 13, 2014 at 10:00 AM, Peter Haworth <pete at lcsql.com> wrote:
>
> > Still confused though.  There is no "$" wildcard available for the LIKE
> > operator, only "%" and "_"
> >
>
>
> That came from typing rather than pasting that line :)  The code that works
> has a %
>
>
>
> > One other possibility.  It seems the LIKE operator has problems with
> > non-ASCII characters - any chance asset includes some, perhaps accented
> > characters?
> >
>
> That *shouldn't* be possible.  And if so, I need a filter to prevent that
> from happening . . .
>
> However, given that the match works when breaking of the asset column to an
> OR, I doubt that reason, as it should bite there, too.  (Hmm, or should
> it?  maybe not.)
>
>
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> _______________________________________________
> 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
>



More information about the use-livecode mailing list