Your article had turned the light on for me. I used this approach for an application I'm developing and I succeed to speed it up a lot.
But...I have one problem:
I need to make a huge select based on a collection, so I have something like:
select sheet_number from sheet_master where id in (paramValues).
I wasn't able to figure out how to send my list of paramValues. The "id" field is numeric - so I tried to create it from asp like:
Set myRS = Server.CreateObject("ADODB.Recordset")
strSQL = "Qry_DrawingReport '" & strValues & "'"
myRS.Open strSQL, myConn, 0, 4
where strValue=4,5,6,124,222
If I enter these values inside the query works, but not as a parameter.
Do you have idea what I'm missing?
Thank you and congratulations for the article!
Monica
