Loretta,
Your syntax appears to be correct. Below is an example of what we do (with
some bits cut out) and it works.
strSQL = "INSERT INTO tblTempConsolidation SET " & _
"customerId = " & intCustomerId & ", "
..
Being in Italy, we use apostrophes in our fields constantly!
MySQL itself has no problems with them at all.
As you say, you're using ASP as your front end, and standard
SQL statements to add, edit and delete records.
For ASP I'm not sure, but in our PHP code it works to simply
add a backslash be
Hi Matt,
Think you will find: http://www.scibit.com/MySQL useful
> -Original Message-
> From: Matt Davis [mailto:[EMAIL PROTECTED]]
> Sent: 13 February 2001 14:47
> To: [EMAIL PROTECTED]
> Subject: ASP and MySQL
>
>
> I have MySQL running on a cobalt Raq 3 with linux operating system. I