View Single Post
 
Old June 4th, 2006, 07:32 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Like I said, I don't see a reason for the error you posted from these SQL statements.

This may be too obvious, but when you say "The data does no add to the DB", did you enable the line that executes the SQL statement again??

If not, change:

' myCon.execute(mySQL)
Response.Write("Sql is " & mySQL)
Response.End


to

myCon.execute(mySQL)
Response.Write("Sql is " & mySQL)
Response.End


Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004