[SQL] placeholders work for SQLite but not for mySQL
Ludovic THEBAULT
ludovic.thebault at laposte.net
Mon Aug 8 08:42:25 EDT 2016
> Le 8 août 2016 à 13:36, Kay C Lan <lan.kc.macmail at gmail.com> a écrit :
> Unfortunately:
>
> put null into pValue
>
> worked fine for SQLite, but I still got the exact same mySQL ERROR =
> Incorrect integer value: '' for column 'postcode' at row 1
>
After the revexecuteSQL do a :
if pValue = empty then ## (or null)
replace ":2" with "NULL" in tSQL
end if
## where :2 is the placeholder which can be empty.
More information about the use-livecode
mailing list