On Sat, 2004-04-10 at 03:24, Chris Faust wrote: > > Do double quotes really need to be doubled when embedded within a > > single quoted string? In other words, isn't 'foo"bar' correct for Sybase? > > > > Are you quoting literal strings or schema identifiers? > > > > Tim. > > Thanks for the reply Tim, > > I'm quoting literal strings and I'm afraid in this case it does no good to > have any double quotes within a single quoted string. > > For an example: > > $var = "I'm really wishing that I used "MySQL" as then I can use > placeholders". > $var = $dbh->quote($var); > $var now equals: > 'I''m really wishing that I used "MySQL" because I could use placeholders.'
I think that you're not using the quote()'d string correctly. I just tried the following: my $dbh = DBI->connect('dbi:Sybase:server=luthien;database=testdb', 'sa', ''); my $str = $dbh->quote(q(I'm really wishing that I used "MySQL" as then I can use placeholders)); my $sth = $dbh->prepare("insert var_test values($str)"); $sth->execute; which inserted the row correctly. You need to remember that the string returned by quote() should be used as-is, without any quotes around it. 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