Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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

by McDarren (Abbot)
on Jun 29, 2006 at 07:38 UTC ( #558243=note: print w/replies, xml ) Need Help??


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.
    لսႽ ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://558243]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2023-09-21 12:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?