[Sqlrelay-discussion] PLEASE HELP I'M LOST, VERY URGENT

[david f. <df...@vi...>]

Hi

My table :
	civility : 	c_id 	integer 	NOT NULL
			l_id 	integer 	NOT NULL	
			c_libelle 	character varying(30) 	NOT NULL


my php script :
$con=sqlrcon_alloc("localhost",9001,"/tmp/mainPostgres.socket","testPostgres","test",1,3);

$cursor = sqlrcur_alloc($con);

sqlrcur_prepareQuery($cursor, "INSERT INTO civility (l_id,c_libelle,c_id)  
VALUES (:l_id,:c_libelle,:c_id)");
sqlrcur_inputBind($cursor,"l_id",1);
sqlrcur_inputBind($cursor,"c_libelle","testee");
sqlrcur_inputBind($cursor,"c_id",5);
if(!sqlrcur_executeQuery($cursor)) {
	echo sqlrcur_errorMessage($cursor);
}
sqlrcur_free($cursor);
sqlrcon_free($con);

Result :
ERREUR: erreur de syntaxe sur ou près de «:» at character 52 Attempted  
Query: INSERT INTO civility (l_id,c_libelle,c_id) VALUES  
(:l_id,:c_libelle,:c_id)
ERROR: syntaxic error on or close to  «:» at character 52 Attempted  
Query: INSERT INTO civility (l_id,c_libelle,c_id) VALUES  
(:l_id,:c_libelle,:c_id)

fedora core 3 or 4:
php (own compiled), version 5.0.4
apache 2.0.54(RPM)
sqlrelay 0.36.4(RPM) - 0.37 (own compiled): both work fine on select
Postgresql 8.0.4(RPM)

I make several trial, every time is the same error.

Please reply as soon as possible.

Regards

David