[thelist] Easy (?) Database Question

[Tab Alleman]

In ASP it would be:

sql = "SELECT * FROM TableName WHERE (Only get 1 record if you don't need
more)"
Set rs = Conn.Execute(sql)

FOR i = 0 TO rs.Fields.Count - 1
	Response.Write("Field #" & i & ":  " & rs.Fields(i).Name & "<br>")
NEXT


...at least that's one way.  I'm sure Scott will have a better way.  :)


-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Jonathan Distler
Sent: Friday, January 05, 2001 10:34 AM
To: thelist at lists.evolt.org
Subject: [thelist] Easy (?) Database Question


Happy New Year All,

I have set up a form to allow admins to dynamically add columns to a table.
Is there anyway I can dynamically update my list of columns in the table?

I guess what I'm asking is, is there anyway to run a loop that rattles off
all the column names in the database?

Much obliged,
Jonathan



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