February 20th, 2001, 06:58 PM
Another option (depending on your datasource) would be to change you SQL statement to be
SELECT isnull(SUM(hits),0) AS hitssum FROM table WHERE year = 2001 AND month = 2 AND day = 19
February 13th, 2001, 05:57 PM
Use a disconnected recordet, ie set the cursor type to be client-side then disconnect by setting the ActiveConnection to nothing.
February 13th, 2001, 05:54 PM
The Shared Property Manager (with MTS/COM+) performs this task
February 11th, 2001, 04:50 PM
Yes, MTS/COM+ will pool the connection for you. Caching the connection in ways you describe has massive scalability issues.
Public variables are not truly public a COM component as they are not...
February 8th, 2001, 05:02 PM
Running an ASP script loads that object into memory, hence you cannot delete it. If it is an un-configured component, you'll need to restart IIS or if it is configured, just shut down the application...
February 8th, 2001, 04:44 PM
exit sub or exit function
February 5th, 2001, 04:57 PM
Caching ADO connections really isn't something you want to get into. Both COS/MTS and COM+ employ connection pooling that does the job for you.
As regards caching a recordset, you could use a...