in reply to Perl DBI issue

You don't say which DBD driver you use. Can I assume it's DBD::Sybase? If so, there's a note in the documentation that says place holders are not supported when connecting to an MS SQL Server. The author and maintainer of DBD::Sybase, mpeppler, does use the monastery regularly - I would expect a note from him to show up later. Or you could check his mailing list archive.

-derby

Replies are listed 'Best First'.
Re^2: Perl DBI issue
by mpeppler (Vicar) on Mar 14, 2007 at 09:59 UTC
    The OP appears to be using DBD::ODBC and freetds. Placeholders have better support in that combination than DBD::Sybase/FreeTDS (AFAIK), but in any case the underlying API needs to support the placeholders when calling stored procedures, and the only way to check that is with FreeTDS's ODBC implementation.

    Michael

[reply]

In Section Seekers of Perl Wisdom