in reply to Re: Using perl dbi and Sybase IQ doing insert with placeholder getting datatype error
in thread Using perl dbi and Sybase IQ doing insert with placeholder getting datatype error

Thank you! These solutions work. I particularly like the (RIGHT(STRING('0000000000',?,10)). The cast will remove the leading zeroes on $mrn. I think the prepare just isn't getting the column datatype from Sybase IQ whereas it was with MSSQL Server and Sybase ASE.

Thank you very much!!!

  • Comment on Re^2: Using perl dbi and Sybase IQ doing insert with placeholder getting datatype error

In Section Seekers of Perl Wisdom