Mitch Helle-Morrissey writes:
> I'm having a problem using placeholders for a binary column. If I do a
> query like 'select * from X where id=?' and then execute with the binary
> value for the placeholder, it returns no rows. But I know there are rows
> there that match because if I make a statement with the id set explicitly to
> the binary value I want, it does return rows.
>
> I suspect there is a problem with the quoting of binary fields when used as
> placeholders, but maybe I'm doing something wrong.
>
> Any ideas? I'm using DBI 1.18, DBD::Sybase 0.91 and Perl 5.6.0. I have
> included my test code and a trace(9) output below.
Hmmm... I just ran it, with a couple of modifications, and it crashed,
mainly because your binary column is 8 bytes wide, and your data
string is 18 bytes wide.
After fixing that it still didn't work, though, so I guess there's
some issue with conversion, which I'll look into.
Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
[EMAIL PROTECTED] - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
