[thelist] plz help with Getrows()

Peter Brunone (EasyListBox.com) peter at easylistbox.com
Wed Jul 19 10:19:48 CDT 2006

				> Please Advise.

   Please show us more of your code :)

   What repeats 12 times?  Your GetRows?  The query?  Are you looping?  What does the loop look like?  Is the category ID what you expect it to be, and if you Response.Write the query and run it against your database, do you get the expected result?



				From: Brian Delaney brian.delaney at mccmh.net

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.


More information about the thelist mailing list