simple question for ASP...please help...many thx...

[chris]

I would like to know how can I display the values for the attribute in the
log_table???
The log_table contains 2 attributes, loguser and logdate.

Sql_log = "select * from log_table"
Set Rs_log = Conn.Execute(Sql_log)

While Not Rs_log.EOF
Response.Write "<tr>"

For i=0 to Rs_log.Fields.Count-1

Response.Write"<td>"& Rs_log(i) & "</td>"
Response.Write "</tr>"
Next

Rs_log.MoveNext
Wend

Please help....thanks alot!

[Jeff Cochran]

On Wed, 11 Feb 2004 01:42:57 +0800, "chris" <router88@sinaman.com>
wrote:

>I would like to know how can I display the values for the attribute in the
>log_table???
>The log_table contains 2 attributes, loguser and logdate.
>
>Sql_log = "select * from log_table"
>Set Rs_log = Conn.Execute(Sql_log)
>
>While Not Rs_log.EOF
>Response.Write "<tr>"
>
>For i=0 to Rs_log.Fields.Count-1
>
>Response.Write"<td>"& Rs_log(i) & "</td>"
>Response.Write "</tr>"
>Next
>
>Rs_log.MoveNext
>Wend
>
>Please help....thanks alot!

First, what happens when you use this code?

Or how about simplifying it:

While Not Rs_log.EOF
Response.Write "<tr>"
Response.Write"<td>"& Rs_log(loguser) & "</td>"
Response.Write"<td>"& Rs_log(logdate) & "</td>"
Response.Write "</tr>"
Rs_log.MoveNext
Wend

Jeff

[chris]

Thanks Jeff...

When I run the script, it shows nothing...any idea??

CHRIS
"Jeff Cochran" <jcochran.nospam@naplesgov.com>
???????:404931ad.630451140@msnews.microsoft.com...

> On Wed, 11 Feb 2004 01:42:57 +0800, "chris" <router88@sinaman.com>
> wrote:
>

> >I would like to know how can I display the values for the attribute in

the

> >log_table???
> >The log_table contains 2 attributes, loguser and logdate.
> >
> >Sql_log = "select * from log_table"
> >Set Rs_log = Conn.Execute(Sql_log)
> >
> >While Not Rs_log.EOF
> >Response.Write "<tr>"
> >
> >For i=0 to Rs_log.Fields.Count-1
> >
> >Response.Write"<td>"& Rs_log(i) & "</td>"
> >Response.Write "</tr>"
> >Next
> >
> >Rs_log.MoveNext
> >Wend
> >
> >Please help....thanks alot!

>
> First, what happens when you use this code?
>
> Or how about simplifying it:
>
> While Not Rs_log.EOF
> Response.Write "<tr>"
> Response.Write"<td>"& Rs_log(loguser) & "</td>"
> Response.Write"<td>"& Rs_log(logdate) & "</td>"
> Response.Write "</tr>"
> Rs_log.MoveNext
> Wend
>
> Jeff