[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