I am able to read from the table using my db connection
but when i want to insert fields into the table i get this error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Set'.
/process.asp, line 53
Set NewCust = db.execute ("INSERT INTO custtable Set " &_
"fname = 'FirstName'" &_
"lname = 'LastName'" &_
"email = 'EmailAddress'" &_
"address1 = 'Any Address'" &_
"address2 = 'N/a'" &_
"city = 'City'" &_
"state = 'State'" &_
"zip = 'Zip'" &_
"country = 'USA'" &_
"phone = '4456544665'" )
Any Thoughts? I have the same exact code running for another website on another server but using MySQL instead of MSSQL. Thanks for any help.
Amjad
but when i want to insert fields into the table i get this error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Set'.
/process.asp, line 53
Set NewCust = db.execute ("INSERT INTO custtable Set " &_
"fname = 'FirstName'" &_
"lname = 'LastName'" &_
"email = 'EmailAddress'" &_
"address1 = 'Any Address'" &_
"address2 = 'N/a'" &_
"city = 'City'" &_
"state = 'State'" &_
"zip = 'Zip'" &_
"country = 'USA'" &_
"phone = '4456544665'" )
Any Thoughts? I have the same exact code running for another website on another server but using MySQL instead of MSSQL. Thanks for any help.
Amjad