Re: [SQL] escape single quote in INSERT command

2002-11-26 Thread Thomas Good
On Wed, 27 Nov 2002 [EMAIL PROTECTED] wrote: > Why dont' you use prepare and execute in case you are using DBI > same program is like this. > > $dbh = DBI -> connect ( ".."); > $sth = $dbh -> prepare("insert into tab (a,b) values (?,?)"); > $sth -> execute($a , $b ); > $sth -> finish(); > $db

Re: [SQL] escape single quote in INSERT command

2002-11-26 Thread Thomas Good
On Wed, 27 Nov 2002 [EMAIL PROTECTED] wrote: > Why dont' you use prepare and execute in case you are using DBI > same program is like this. > > $dbh = DBI -> connect ( ".."); > $sth = $dbh -> prepare("insert into tab (a,b) values (?,?)"); > $sth -> execute($a , $b ); > $sth -> finish(); > $db

Re: [SQL] escape single quote in INSERT command

2002-11-26 Thread Dan Langille
On 27 Nov 2002 at 0:01, [EMAIL PROTECTED] wrote: > > Hi Group - > > > > I have a perl application for a registration form. > > Same Here, > > Why dont' you use prepare and execute in case you are using DBI > same program is like this. > > $dbh = DBI -> connect ( ".."); > $sth = $dbh -> pre

Re: [SQL] escape single quote in INSERT command

2002-11-26 Thread mallah
> Hi Group - > > I have a perl application for a registration form. Same Here, Why dont' you use prepare and execute in case you are using DBI same program is like this. $dbh = DBI -> connect ( ".."); $sth = $dbh -> prepare("insert into tab (a,b) values (?,?)"); $sth -> execute($a , $b ); $

Re: [SQL] escape single quote in INSERT command

2002-11-26 Thread mark carew
Woops should have been masquerading ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] escape single quote in INSERT command

2002-11-26 Thread Hunter
Hi Group - I have a perl application for a registration form. I'd like to put escape characters in my insert command to accommodate for ' (i.e. O'Brien, O'Malley, etc). I've tired double quotes, single quotes, back tick, forward ticks, curly bracket, round brackets - no success. Thanks, dave -

Re: [SQL] escape single quote in INSERT command

2002-11-26 Thread mark carew
Hi Hunter, From my xbase++ program suite, sqlcontext class. * cValue := strtran(cValue,['],[\']) * Its called masquarading, simply replace the single quote with back_slash + single quote. Regards Mark Carew Brisbane Australia

Re: [SQL] escape single quote in INSERT command

2002-11-22 Thread Jeff Boes
On Fri, 22 Nov 2002 08:00:01 -0500, Hunter wrote: > I have a perl application for a registration form. I'd like to put > escape characters in my insert command to accommodate for ' (i.e. > O'Brien, O'Malley, etc). I've tired double quotes, single quotes, back > tick, forward ticks, curly bracket,