see correction below
> -----Original Message-----
> From: Toby Stuart
> Sent: Friday, October 18, 2002 11:31 AM
> To: 'Andrew Hubbard'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Single Quote marks in a string
>
>
> been a long time since i done any SQL but i *think* you have
> to quote single-quotes inside a string eg.
>
> <snip>
> $article = "8852001100010";
> $barcode = "8852001100010";
> $description = "BRAND'''S Essence of Chicken 42 cc.";
$description = "BRAND''S Essence of Chicken 42 cc.";
i was wrong, you only need two :)
>
> $strSQL = "INSERT INTO Product_Lookup_Table
> (PL_Barcode,PL_Article,PL_Description) VALUES (";
> $strSQL = $strSQL . "'" . $barcode . "','" . $article . "','"
> .$description . "')";
>
>
> print $strSQL;
> </snip>
>
> try it, but i could be wrong :)
>
> cheers
>
> toby
>
>
> > -----Original Message-----
> > From: Andrew Hubbard [mailto:andrew@;pcs.co.th]
> > Sent: Thursday, October 17, 2002 6:01 PM
> > To: [EMAIL PROTECTED]
> > Subject: Single Quote marks in a string
> >
> >
> > Hi,
> > I'm having problems with a text file I'm working on. I
> > need to get
> > the descriptions in from the text file and into a
> > string for use in an SQL statement however some of the
> > descriptions use a
> > single quote mark in the description.
> > This of course stops the sql statement from working.
> >
> > How can I get around this? I don't want to remove the quote.
> >
> > Example is as follows
> >
> > 8852001100010,8852001100010,BRAND'S Essence of Chicken 42 cc.,0,TRUE
> >
> > $article = '8852001100010'
> > $barcode = '8852001100010'
> > $description = 'BRAND'S Essence of Chicken 42 cc.'
> >
> >
> > $strSQL = "INSERT INTO Product_Lookup_Table
> > (PL_Barcode,PL_Article,PL_Description) VALUES (";
> > $strSQL = $strSQL . "'" . $barcode . "','" . $article . "','" .
> > $description . ")";
> >
> > I think this is relativly straight forward but I'm a newbie
> > at Perl. - I
> > wish I'd learnt it a few years ago now :)
> >
> > Regards
> >
> > Andrew Hubbard
> >
> >
> >
> > --
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
