Re: Does CDBI require placeholder functionality in the DBD?

[prev] [thread] [next] [Date index for 2004/12/12]

> I am aware that the Sybase driver for DBD does *not*
> support placeholders. However, my query didn't use
> placeholders. (See query below.) 

It does.

> my $obj = My::ThisDB::ThisTable->retrieve(1);

That issues a 

SELECT Essential Columns
  FROM ThisTable
 WHERE ThisTableID = ?

With a value if 1.

I don't use Sybase myself, so I don't know much about this, but have you
looked at Class::DBI::Sybase from CPAN?

Tony