Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#ulButtons li a'.
/scripts/dragndrop/templates.asp, line 137
"INSERT INTO FolioPages (Title, Contents, Element) VALUES '" & replace(arrayCss(0, posCss), "1000", ID) & "', '" & replace(arrayCss(1, posCss), "1000", ID) & "', '" & replace(arrayCss(2, posCss), "1000", ID) & "' WHERE Type='css' AND IVID='" & ID & "' AND Page='" & pageArray(position) & "';"
I am not sure why this is occuring. I am trying to transfer template information to another account. All i am doing is in a previous function is get data from the database and dump the record set into an array. I first check the rs for eof the check if the aray is an array then try a select statement for the second element to see if the record exists if not then insert into DB. I am using sql server 2005. I have tried several remedies such as creating a variable and inserting a variable in appropriate values column