RE: ASP and MySQL

2002-03-27 Thread G r e g L a w r i e
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 & ", " ..

RE: ASP and MySQL

2002-03-27 Thread Steve Rapaport
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

RE: ASP and MySQL

2001-02-13 Thread Jacques Venter
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