Rudy Lippan wrote:

On Sun, 28 Dec 2003, Terrence Brannon wrote:



DBD::mysql does not do the quoting itself. The quoting is a feature of the DBI; Quoting the DBI docs:

oh, I see. thank you for the reference.


Versions of DBD::mysql < 2.9002 did not implement get_info(), so when DBI went looking for the quote char, it did not get anything back, and therefore, did not quote the table names.


I can't think of an easy way to turn the quoting off from DBD::mysql other
than making $dbh->get_info(29)  return undef, but that would affect all
calls to get_info and possibly break applications that require the table
names to be quoted :(

hmmm...


That being said, how does DBIx::Recordset handle a search with a !Table like, "This is a"" del!mited \Itdentifier as &^% a table 'na`me'."? or maybe a table named "select"? Does the end-user have to use $dbh->quote_indentifier() first?

yes, I suppose they would have to call quote_identifier()



Rudy


thank you for the pointers.




--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to