new to asp

[jaydonnell]

I'm doing some asp, but all of my experience is with linux and linux
related tools like python, php, mysql, etc.

Basically, I can't find any good resources for asp/vb script. Nothing
akin to the docs on python.org or php.net.

Here is my current problem. I have a result set I got from an adodb
connection and I want to loop through all the fields, but the number of
fields may vary. Here's my code.

If not RS.eof then
RS.movefirst
Do

'this doesn't work so how would I do this.
for each field in rs.fields
Response.write "Here is some Data " & field & "<br>"
next

Rs.movenext
Loop until RS.eof
End if


Basically, I don't know how to get the fields into a form that I can
loop through. Any help or links to good resources will be greatly
appreciated.

[Gérard Leclercq]

Re: new to asp

https://www.aspFaq.com

For Each objField In objRecord.Field s
Response.Write objField.Name & "<br>"
Next

[Jeff Cochran]

Re: new to asp

On 14 Dec 2004 09:54:51 -0800, "jaydonnell " <jaydonnell@gma il.com>
wrote:
[color=blue]
>I'm doing some asp, but all of my experience is with linux and linux
>related tools like python, php, mysql, etc.
>
>Basically, I can't find any good resources for asp/vb script. Nothing
>akin to the docs on python.org or php.net.[/color]

There's always:

http://www.devguru.com/Technologies/vbscript/quickref/vbscript_intro.html

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtoriVBScript.asp

http://ww.aspfaq.com/

[color=blue]
>Here is my current problem. I have a result set I got from an adodb
>connection and I want to loop through all the fields, but the number of
>fields may vary. Here's my code.
>
>If not RS.eof then
>RS.movefirst
>Do
>
>'this doesn't work so how would I do this.
>for each field in rs.fields
>Response.wri te "Here is some Data " & field & "<br>"
>next
>
>Rs.movenext
>Loop until RS.eof
>End if
>
>
>Basically, I don't know how to get the fields into a form that I can
>loop through. Any help or links to good resources will be greatly
>appreciated.[/color]

Check this list of tutorials and samples for using record sets:

http://www.google.com/search?hl=en&lr=&q=asp+recordset+tutorial

Jeff