Seen in Recordset, but not asp webpage?

message from Happy on 15 Jul 2004

I have created a query in MS Access and I've set it up
in a recordset, when I test the recordset from the server
it shows all ok, but insert it into the asp page and view it,
it doesn't show the same data as the recordset test?

Here's the page -
http://www.related.comestaywithus.com/related/africa.asp

The link numbers should read 1,2, not 1,1 at the beginning of each row?

Here's the code DW-MX has inserted.
<%=(rsQuery.Fields.Item("RowNumber").Value)%>

Any ideas what's going wrong?

Cheers

Craig.

Jeff North replied to Happy on 15 Jul 2004

What if the field RowNumber datatype - text or numeric?
The comma is probably acting as a field delimiter when reading your
data.

Happy replied to Jeff North on 16 Jul 2004

Thanks Jeff

Problem sorted, after all that I found a extension to do the job
in the exchange.

Thanks anyway.

Craig.

"Jeff North" <jnorth@yourpantsbigpond.net.au> wrote in message
news:nv2ef0hcmnlkrs8h1m9aat15bc48j1i8o2@4ax.com...

Archived message: Seen in Recordset, but not asp webpage? (Macromedia Dreamweaver Web Design)