in reply to Placeholders(?) in the prepare statements for executing DBD::Sybase queries

From the DBD::Sybase docs:
DBD::Sybase supports the use of ? placeholders in SQL statements as lo +ng as the underlying library and database engine supports it.

So it's possible that the database engine you are using does not support placeholders. Certainly, I know this is the case with FreeTDS, as documented here.

If this is the problem in your case, then the solution would probably be to switch to ODBC.

Hope this helps,
Darren :)

  • Comment on Re: Placeholders(?) in the prepare statements for executing DBD::Sybase queries
  • Download Code

Replies are listed 'Best First'.
Re^2: Placeholders(?) in the prepare statements for executing DBD::Sybase queries
by choroba (Cardinal) on Jul 15, 2015 at 10:32 UTC
    I know this thread is very old, but the following information might be beneficial to occasional lurkers: I was able to run SELECT and UPDATE queries with placeholders with DBD::Sybase (version 1.15) connecting to SQL Server through FreeTDS (version 0.91). $db->{syb_dynamic_supported} returns 1.
    لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ