Postgresql and Parameters
Posted: Sun Jul 31, 2016 6:26 pm
Hey everyone,
I've been away from Livecode for a while and trying to get back into it.
I've been trying to save a record to a Postgresql database using the ":" placeholder.
My query:
The error message after the query is: syntax error at or near ":"
Are placeholders supported with Postgresql?
Best Regards,
Johnny Harris
I've been away from Livecode for a while and trying to get back into it.
I've been trying to save a record to a Postgresql database using the ":" placeholder.
My query:
Code: Select all
put "INSERT INTO groups ( group_id, group_name, is_active ) VALUES ( :1, :2, :3 )" into sql
revExecuteSQL gCon, sql, tId, tTitle, bActive
Are placeholders supported with Postgresql?
Best Regards,
Johnny Harris