| Author |
 Topic  |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
 Posted - 08 November 2001 : 10:31:53
|
Brad take a look here. (The summary looks good but I couldn't get to the site - it was down. You might want to try later.)
www.aspfaq.com/faq/faqShow.asp?fid=86
KatsKorner
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 08 November 2001 : 10:35:31
|
Set rs2 = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM TABLE"
rs2.Open sSQL, my_Conn, 3
for each fld in rs2.fields
iFieldCount = iFieldCount + 1
if iFieldCount <> 1 then
response.write rs2(fld.name)
end if
response.write "</font></td>"
next
rs2.close
set rs2 = nothing
|
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 08 November 2001 : 11:02:29
|
thanks richard, but i even put Server.ScriptTimeout = 9999 in the top and the script still times out. I know its not the database cause i can view small tables, i think its just that this one has so much data in it.
Brad
Web Hosting with SQL Server @ $24.95 per month
Snitz Mod Archive
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 08 November 2001 : 11:08:10
|
richard!? you mean Huw!
Try this brad
iFieldCount = 0
Set rs2 = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM TABLE"
rs2.Open sSQL, my_Conn, 3
for each fld in rs2.fields
iFieldCount = iFieldCount + 1
if iFieldCount <> 0 then
response.write rs2(fld.name)
end if
response.write "</font></td>"
next
rs2.close
set rs2 = nothing
---------------
-Da_Stimulator
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 08 November 2001 : 11:18:20
|
lol yea i mean huwr (SORRY MAN),
Stim, i tried yours and still got the timeout error message. I guess I will just have to wait till I get to where I can log onto Enterprise Manager to be able to view the table names.
I also sent ya an email stim about freeaspcode.net
Brad
Web Hosting with SQL Server @ $24.95 per month
Snitz Mod Archive
|
|
|
|
mios
Junior Member
United Kingdom
101 Posts |
Posted - 09 November 2001 : 10:00:13
|
Try this, similar to everyone else, but I don't bother getting the whole recordset back, just an empty one ( WHERE 1 = 2), but it still contains the field collection.
If this dosn't work you could try using ADOX
set ObjRs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM TABLE WHERE 1 = 2"
ObjRs.Open sSQL
for each fld in ObjRs.fields
response.write rs2(fld.name) & "<br>"
next
objRs.close
set objRs = nothing
|
|
|
| |
Topic |
|
Topic Locked
