andr04.
MySQL script: invalid type: string "", expected a boolean
Conceptually, it looks like a workaround. It's a bigint, not string, and transforming it to string should be done on another layer just for JS, which https://hub.windmill.dev/scripts/mysql/577/execute-query-mysql does.
I have other more complicated queries which will be difficult to synchronize, because they work good outside JS.
27 replies
MySQL script: invalid type: string "", expected a boolean
It's interesting fact, but Chrome Developer Tools in raw response shows the correct (not rounded IDs). I really recommend you on the backend transform bigint to string before send the result.
And the code https://hub.windmill.dev/scripts/mysql/577/execute-query-mysql returns an object with
rows
and fields
properties, and there the field id
is interpreted as string. Will try to find a way to protect it from SQL injections.27 replies