tmail.com To: [EMAIL PROTECTED]
cc:
10/18/2002 02:24 bcc:
on do, 17 okt 2002 08:01:07 GMT, Andrew Hubbard wrote:
> 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 descr
been a long time since i done any SQL but i *think* you have to quote
single-quotes inside a string eg.
$article = "8852001100010";
$barcode = "8852001100010";
$description = "BRAND'''S Essence of Chicken 42 cc.";
$strSQL = "INSERT INTO Product_Lookup_Table
(PL_Barcode,PL_Article,PL_Desc
