On Wed, Apr 03, 2002 at 01:35:34PM +0100, Michael Stevens wrote: > I've never used DBD::Sybase, but I've been told that placeholders > don't work with it. I don't know how reliable that information is.
If you search on google for "dbd::sybase placeholders" you'd find out :-) Apparently it's supported of Dec 12 2001, http://www.mbay.net/~mpeppler/ Or just email the author. There used to be this incredibly useful list of DBD:: capabilities on symbolstone.org but I can't find it right now. From Google's cache on DBD::Sybase, ``Parameter Binding Parameter binding is directly suported by Sybase. However, there are two downsides that you should be aware of: Firstly, DBD::Sybase creates an internal stored procedure for each prepare() call that includes ? style parameters. These stored procedures live in the tempdb database, and are only destroyed when the connection is closed. It is quite possible to run out of tempdb space if a lot of prepare() calls with placeholders are being made in a script. Secondly, because all the temporary stored procedures are created in tempdb, this causes a potential hot-spot due to the locking of system tables in tempdb. This performance problem may be removed in an upcoming release of Sybase ( possibly 11.9.4 or 12.0 ). The :1 placeholder style is not supported and the TYPE attribute to bind_param() is currently ignored, so unsupported values don't generate a warning. Finally, trying to bind a TEXT or IMAGE datatype will fail.'' There's your answer I think. Paul -- Paul Makepeace ....................................... http://paulm.com/ "If it can be squeezed in before noon, then come back next year." -- http://paulm.com/toys/surrealism/
