Page 1 of 1

Postgresql and Parameters

Posted: Sun Jul 31, 2016 6:26 pm
by 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

Re: Postgresql and Parameters

Posted: Mon Aug 01, 2016 3:53 pm
by jharris
I got it working. I didn't catch in the documentation that variable names have to be quoted.

J. Harris