No dice. That file spits out different errors all together.. A little more info..
Addition of the following on line 74 produces the querystring at the top of the page.
rs.movefirst
response.write "query = " & rs("au_querystring")
So, the querystring is making it into the recordset.
Now we add this little snippet of code that will display everything in the array...
iRecFirst = LBound(arrAM, 2)
iRecLast = UBound(arrAM, 2)
iFieldFirst = LBound(arrAM, 1)
iFieldLast = UBound(arrAM, 1)
' Display a table of the data in the array.
' We loop through the array displaying the values.
%>
<table border="1">
<%
' Loop through the records (second dimension of the array)
For I = iRecFirst To iRecLast
' A table row for each record
Response.Write "<tr>" & vbCrLf
' Loop through the fields (first dimension of the array)
For J = iFieldFirst To iFieldLast
' A table cell for each field
Response.Write vbTab & "<td>" & arrAM(J, I) & " </td>" & vbCrLf
Next ' J
Response.Write "</tr>" & vbCrLf
Next ' I
%>
</table>
<%
' That's all folks!
When this code is added at line 74, nada, no querystring in the array.. So you have a problem here.. The querystring field is the only one that is not making it over. Everything else finds it's way into the array.. I'm not sure why that is.. See this code in action here....
http://stage.mylargescale.com/forum/active_users.asp
One thing that just occured to me was maybe the ADO/MDAC version installed on the server. Something like that could be to blame.
I may try to take things out of the array tomorrow and just cycle through the recordset.
Have fun and be good!!
Shad Pulley
shadstrains@mylargescale.com
www.mylargescale.com/forum
Edited by - spulley on 25 April 2002 01:01:24