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
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12h5cbupf/M=362329.6886308.7839368.1510227/D=groups/S=1705115381:TM/Y=YAHOO/EXP=1123546057/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</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/
