So what you are saying is Sybase allows a insert/update with single double quote but MS-SQL doesn't (when using FreeTDS and DBD_Sybase)??
Looks like I'll have do my own quoting or make it a 2 step process - bummer!!! Thanks Anyway. -Chris ----- Original Message ----- From: "Michael Peppler" <[EMAIL PROTECTED]> To: "Chris Faust" <[EMAIL PROTECTED]> Cc: "Tim Bunce" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, April 12, 2004 10:41 AM Subject: Re: DBI->quote with DBD::Sysbase > On Mon, 2004-04-12 at 05:16, Chris Faust wrote: > > Thanks Michael, I know that I shouldn't be re-quoting anything I've already > > quoted with DB quote. > > That example I gave was before the DB prepare or execute, when just trying > > to print it to screen. > > > > Example > > $var = "I'm really wishing that I used "MySQL" as then I can use > > placeholders"; > > $var = $dbh->quote($var); > > print "$var"; > > > > I end up with > > > > I''m really wishing that I used "MySQL" as then I can use placeholders > > > > When I should have > > > > I''m really wishing that I used ""MySQL"" as then I can use placeholders > > DBD::Sybase uses DBI's quote() method, so you get whatever is the normal > behavior for DBI. However you don't need to quote both the single and > double quotes in this case - Sybase will insert the data properly. > > Michael > -- > Michael Peppler Data Migrations, Inc. > [EMAIL PROTECTED] http://www.peppler.org/ > Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or > long term contract positions - http://www.peppler.org/resume.html >
