[SQL] placeholders work for SQLite but not for mySQL
Ludovic THEBAULT
ludovic.thebault at laposte.net
Sun Aug 7 01:05:22 EDT 2016
> Le 6 août 2016 à 11:07, Kay C Lan <lan.kc.macmail at gmail.com> a écrit :
>
> Thanks Erik,
>
> yes that's what I'm doing as a workaround at the moment, I test the
> variable and see if it's empty, if not I use place holders and execute
> the original statement, if it is empty, then I've written out the
> longhand statement without place holders and execute that.
>
If my variable is empty, i set it to null.
(the mysql column accept null)
More information about the use-livecode
mailing list