[thelist] [ASP] Am I locking and Opening correctly?
Chris W. Parker
cparker at swatgear.com
Thu Dec 19 14:10:03 CST 2002
> -----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.
More information about the thelist
mailing list