Very cool...thanks!
Dian ~ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Manzotti Sent: Monday, August 08, 2005 5:08 PM To: [email protected] Subject: Re: [ASP] How to display specific records Dian D. Chapman wrote: >Thanks for that, Paul. I did actually find the GetRows code and was messing >with it, but was confused from the example I had and finally tossed up my >hands and went with the Select query that I'd been using all along. But I >will study your code in comparison with the other one I tried and see if it >makes more sense to me now. > > If you want some arrays code... ;-) ' **************************** ' * DECLARE ALL THINGS ARRAY * ' **************************** dim arrParts ' Parts dim arrPartsRow ' Array row counter dim arrPartsCount ' number of rows in array ' Column Identifiers in array dim fldPartID ' Part ID field dim fldPartCode ' Part Code field dim fldPartDescription ' Part Description field Create the recordset, then: if rsParts.bof or rsParts.eof then rsParts.close Set rsParts = Nothing else ' Get the array from the recordset arrParts = rsParts.GetRows rsParts.close Set rsParts = Nothing ' Get the number of rows in the array arrPartsCount = UBound( arrParts, 2 ) fldPartID = 0 fldPartCode = 1 fldPartDescription = 2 end if Then to use the array For arrPartsRow = 0 to arrPartsCount response.write(arrParts( fldPartID, arrPartsRow ) ) ) response.write(arrParts( fldPartCode, arrPartsRow ) ) ) response.write(arrParts( fldPartDescription, arrPartsRow ) ) ) Next That's pretty much it. >Appreciate it! > > No worries! manzo --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.2/65 - Release Date: 8/7/2005 -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.2/65 - Release Date: 8/7/2005 ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h2fpluq/M=362335.6886445.7839731.1510227/D=groups/S=1705115381:TM/Y=YAHOO/EXP=1123548009/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
