Re: [Sqlrelay-discussion] php, bind variables and postgresql

[Martin F. <mar...@po...>]

Chris schreef:
> sqlrcur_prepareQuery($cur,"select * from sq_ast where assetid=:assetid");
> sqlrcur_inputBind($cur,"assetid","43");
> ERROR:  syntax error at or near ":" at character 36
> STATEMENT:  select * from sq_ast where assetid=:assetid
>
> I'm sure I'm missing something really simple but can't work out what it 
> is. Any suggestions very welcome.
>   

Try

sqlrcur_inputBind($cur,":assetid","43");

??

(The colon should be in the name of the bindvar.)

Regards,

Martin