[thelist] asp LOGIC QUESTION

Peter Brunone (EasyListBox.com) peter at easylistbox.com
Fri Apr 21 11:02:36 CDT 2006

		Hi Brian,

   I think you'll find GetRows and GetString to be extremely helpful.  You don't have to manipulate slow, clumsy recordsets, and if you format the results correctly, you might be able to avoid doing any string concatenation at all.





				From: Brian Delaney <brian.delaney at mccmh.net>
Sent: Friday, April 21, 2006 8:51 AM
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Subject: [thelist] asp LOGIC QUESTION 

I have a sql record set that contains 12 uids. For each UID I want to go 
the servie table and return the services that are under this catagory's ID

Once I get the list of services I want to dynamically build the html for 

The problem is this: I can loop through the catagory recoredset and find 
the services per uid I just am stuck on how to create a dynaic unique
variable name to hold teh html for each service list.

The ASP code:

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

While Not rsServiceList.EOF
ServiceListHTML = "<-- Choose One -->"
ServiceListHTML = ServiceListHTML1 & "" & rsCatagoryList("Name") & ""


The HTML Code:

Activities / 

any help will be appreciated, thanks

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.

* * Please support the community that supports you. * *

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 

More information about the thelist mailing list