Re: Sybase IQ bind parameter problem

On Thu, 2005-03-24 at 12:18, Cumming, Joe wrote:
>  
> 
> Hello,

> I am unable to use bind parameters in a simple query using Sybase IQ
> when the column being bound to is not an integer.

> my $sqlstmt =" UPDATE creditqr.VolCurveDef SET QuoteType = ? WHERE
> VolCurveDefID = ? ";


> Produces the error 

> DBD::Sybase::st execute failed: Server message number=21 severity=14
> state=0 line=0 text=ASA Error -1000187: Unable to implicitly convert
> column 'QuoteType' to datatype (varchar) from datatype (integer).

Interesting. I seem to remember running "make test" for DBD::Sybase
against IQ and it worked fine (meaning that placeholders worked...)

Could you try to run that with DBI->trace(5) ?

Thanks,

Michael
-- 
Michael Peppler  -  [email protected]  -  http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html