Postgresql and Parameters

[jharris]

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:

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

The error message after the query is: syntax error at or near ":"

Are placeholders supported with Postgresql?

Best Regards,
Johnny Harris

[jharris]

I got it working. I didn't catch in the documentation that variable names have to be quoted.

J. Harris