Re: DBI->quote with DBD::Sysbase

2004-04-20 Thread Chris Faust
> Hmmm - I don't know. Maybe there's a problem with the quoted_identifyer > setting. > > Normally the following should work: > > insert foo(string) values('this isn''t "quoted"') > > As the " is in a string delimited by single quotes it shouldn't need to > be quoted. > > Have you tried doing this s

Re: DBI->quote with DBD::Sysbase

2004-04-12 Thread Henri Asseily
elimited by single quotes it shouldn't need to be quoted. Have you tried doing this sort of thing in an interactive SQL shell to see what works? Michael - Original Message - From: "Michael Peppler" <[EMAIL PROTECTED]> To: "Chris Faust" <[EMAIL PROTECTED]>

Re: DBI->quote with DBD::Sysbase

2004-04-12 Thread Michael Peppler
ael > - 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 > Su

Re: DBI->quote with DBD::Sysbase

2004-04-12 Thread Chris Faust
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

Re: DBI->quote with DBD::Sysbase

2004-04-12 Thread Michael Peppler
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

Re: DBI->quote with DBD::Sysbase

2004-04-12 Thread Chris Faust
placeholders Any idea why? Thanks -Chris - Original Message - From: "Michael Peppler" <[EMAIL PROTECTED]> To: "Chris Faust" <[EMAIL PROTECTED]> Cc: "Tim Bunce" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, April 10, 2004 11:5

Re: DBI->quote with DBD::Sysbase

2004-04-10 Thread Michael Peppler
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 T

Re: DBI->quote with DBD::Sysbase

2004-04-10 Thread Tim Bunce
On Sat, Apr 10, 2004 at 06:24:35AM -0400, 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? > > Thanks for the reply T

Re: DBI->quote with DBD::Sysbase

2004-04-10 Thread Chris Faust
> 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

Re: DBI->quote with DBD::Sysbase

2004-04-10 Thread Tim Bunce
On Fri, Apr 09, 2004 at 01:12:14PM -0400, Chris Faust wrote: > Hello, > > I'm using the combination of DBI, DBD::Sysbase and FreeTDS to connect to an MS-SQL > server. > Due to the issues with placeholders and sp's (specifically not being able to use > them), I'm forced to properly deal with any

DBI->quote with DBD::Sysbase

2004-04-09 Thread Chris Faust
Hello, I'm using the combination of DBI, DBD::Sysbase and FreeTDS to connect to an MS-SQL server. Due to the issues with placeholders and sp's (specifically not being able to use them), I'm forced to properly deal with any single and double quotes. It seems like DBI->quote does almost everythin