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

[Chris <dm...@gm...>]

Martin Fleurke wrote:
> 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.)

I got the same thing as before (postgres throwing an error).

Could I have done something wrong with the compiling/configuring (though 
I'm not really sure what it could be).. ?

-- 
Postgresql & php tutorials
http://www.designmagick.com/