[thelist] SQL Update Query - Easy

Ken Schaefer Ken at adOpenStatic.com
Wed Jan 26 21:59:23 CST 2005



: -----Original Message-----
: From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On
: Behalf Of Rob Smith
: Subject: [thelist] SQL Update Query - Easy
: 
: Alright I'm going to set the stage:
: 
: RS.ActiveConnection = MM_web_request_STRING

What's wrong with the line above? I think that's been pointed out a number of
times.

You need to use:

	Set RS.ActiveConnection = MM_web_request_STRING

and then later on:

	Set RS.ActiveConnection = Nothing

otherwise you not connection pooling. 

Cheers
Ken


More information about the thelist mailing list