> -----Original Message----- > From: Casey Crookston [mailto:casey.crookston at imibevcore.com] > Sent: Thursday, December 19, 2002 9:27 AM > To: thelist at lists.evolt.org > Subject: [thelist] [ASP] Am I locking and Opening correctly? > sql1 = "UPDATE PortalStatus SET Status = '"& cusp_status &"' WHERE > PortalName = 'Customer Portal';" > > oConn.Execute sql1 'UP TO HERE THERE'S NO PROBLEM, BUT THIS LINE > RETURNS AN ERROR in case you don't realize it, the problem is not THAT line specifically, but probably what is contained in sql1 that is the problem. > Error message: Data type mismatch in criteria expression. my only suggestion is to make *absolutely* sure you are inserting the correct datatypes and that you are referencing the correct fields. chris.