[thelist] plz help with Getrows()

[Anthony Baratta]

Best to look at a bit more code. You say this is "looping". I would assume that it's looping on the rsCatagoryList record set, correct? If not - make sure that you are moving through that record set correctly.

Setup some response writes, so that you print out what is contained in mid(rsCatagoryList("ID"),2,36) for each loop. Also print out your SQL (strSQL1)  and verify it's setup correctly for each loop.

-----Original message-----
From: Brian Delaney brian.delaney at mccmh.net
Date: Wed, 19 Jul 2006 06:35:12 -0700
To: "thelist at lists.evolt.org" thelist at lists.evolt.org
Subject: [thelist] plz help with Getrows()

> 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.
> 
> thanks
>