[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