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


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.
[download]

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. لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ	[reply] [d/l]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://558243]
help

Chatterbox^?

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^?