On Tue, 11 Feb 2003, Preston de Guise wrote: > I'm using DBI / DBD::Pg and finding that the placeholders are being interpreted > in places where I'd rather them not.
If the placeholders are being interpolated in places were a '?' is a legal character (In a string literal, delimited identifier, or a comment) then that is a bug ind DBD::Pg. What version of DBD::Pg are you using. And do you have a self-contained sample script (with data) that shows the behaviour. > At the moment I've got a system whereby a user inputs some data which is > collated into a record that also includes several values that are auto-created > by other components of a system. > > In order to then determine and provide to the user the details that have been > auto-created I do a select based on the recently input record parameters that > the user provided. Unfortunately if some of the content includes character > combinations that can be interpreted to be placeholders, which is where the > select then becomes unstuck, because it's not really trying to do a placeholder > style select... > It almost sounds like you are not quoting your strings correctly before sending them to prepare, so DBD::Pg is seeing the ? and then acting as if it found a place holder, when the ? should be in a string literal. > I've had a quick search of a couple of the DBI mailing list archives suggested > but was not able to find anything discussing the disabling of placeholders. > Probably because DBD::Pg does not let you disable placeholders. -r
