Looks like my original answer didn't come through - anyway, I suggested something
along the lines of :-
for i = 1 to n
response.write objRS.Fields(i).Name
next
Dan
www.diado.com
-----Original Message-----
From: Chris Hagwood [mailto:[EMAIL PROTECTED]
Sent: 10 September 2004 14:58
To: [EMAIL PROTECTED]
Subject: Re: [ASP] List Field Names
I didn't know you could ORDER BY w/out selecting them... I guess I had never
tried.
Thanks!
> Just as an aside, do you need to select the fields you're ordering by? In
most situations you can just include them in the order by clause and not
select them.
>
> Also, if you wanted to start from the second you'd need to use for i = 1
to n, not for i = 0 to n as I mistakenly put.
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
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/
