PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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