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

Reply via email to