RE: :: delimiting apostrophes to insert data w/o errors ::

[Kipp, James]

you can try the qw(...) function or use the DBI 'quote' method.

> -----Original Message-----
> From: Hastie, Christa [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 2:45 PM
> To: '[EMAIL PROTECTED]'
> Subject: :: delimiting apostrophes to insert data w/o errors ::
> 
> 
> Hello!
> I bet there is some really simple DBI function/reg ex that 
> delimits the
> apostrophes like such (\') so data can be inserted into the db without
> errors.
>  
> i.e. this string:
> INSERT INTO db (SomeColumn) VALUES ('John's car is cool!')
>  
> becomes:
> INSERT INTO db (SomeColumn) VALUES ('John\'s car is cool!')
>  
> Anybody know the function/reg ex for this?
> Thanks for any help in advance!
> Appreciate it!
>  
> - christa :)
>  
> - - - - - - - - - - - - - - - - - - - - - - - - -
> christa hastie
>