[thelist] [ASP] Am I locking and Opening correctly?

[Chris W. Parker]

> -----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.