[thelist] plz help with Getrows()

Brian Delaney brian.delaney at mccmh.net
Wed Jul 19 08:30:38 CDT 2006

I am using this code to convert a SQL recordset rsServiceList1 to an 
array for comparison.

Set rsServiceList1 = Server.CreateObject("ADODB.Recordset")
strSQL1 = "Select * from Services where catagoryid = " & "'" &  
mid(rsCatagoryList("ID"),2,36) & "'" & " order by name "
rsServiceList1.Open strSQL1, ResourceCatalogDBConn   

rsServiceList1 could contain 4 or up to 20 rows. Example - ID,Name for 
each row. The first time it returns the correct amount of 4.
The problem is that this repeats 12 times and it only returns 4 every time.

DBServicesArray1 = rsServiceList1.GetRows

Please Advise.


This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information.  Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.

More information about the thelist mailing list