|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Sybase IQ bind parameter problem
Date: Mar 27 2005 4:06PM
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 - mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
|
