mySQL & RevEnterprise: queries not returning expected values

Andre Garzia andre at andregarzia.com
Mon May 24 11:57:51 EDT 2010


now one question, why revolution doesn't have something like php
mysql_real_escape() everyone here and his dog is implementing their own
escaping routines when it should be provided by the engine, specially since
mysql C library provides it, it is just a matter of wrapping around it.



On Mon, May 24, 2010 at 2:15 AM, Ian McKnight
<iangmcknight at googlemail.com>wrote:

> Thanks for the reminder Bob.
>
> On 24 May 2010 03:37, Bob Sneidar <bobs at twft.com> wrote:
> > Make sure you enclose values in real quotes. Mysql seems to handle
> numerical
> > values without quotes but when a value is text it will interpret the text
> as
> > a column name if it's not in quotes.
> >
>
>
> --
> Regards
>
>
> Ian McKnight
>
> iangmcknight at gmail.com
> =======================
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 
http://www.andregarzia.com All We Do Is Code.



More information about the use-livecode mailing list