One row per page.

[Deepiceman]

Hi folks,
Here is what I am trying to achieve. I have a database with about 20
columns(fields), the first one being a unique ID. I am trying to get a
page which will dispaly the fields in a specific format. So far I am
able to do this to a certain extent. What I want to happen is that
when I click on a link on one page, it should use the id number of the
row (passed thru the url) to load a page that shows the data of that
row only. I know this is possible because I have seen it many times
but I dont know how to get the functionality.

Thanks in advance

[Paal Andersen]

if you ar efamiliar with querystring there are noe problem.

mainpage
* = prototype

* open database and return all rows
do while not rs.eof
%>
<a href="details.asp?id=<%rs.fields("id")%>"> ''add a querystring
<%=rs.fields("name")%></a>
<br><%
rs.movenext (very essensial.. have i forgot this line sometimes
:o )
loop

* close db

detailpage


* open database
rs.open "select * from users where id="&request("id")&"" '' read the
querystring
* gets the specified record





"Deepiceman" <deepiceman@yahoo.com> wrote in message
news:f07dfae.0308191256.5e22acb5@posting.google.co m...

> Hi folks,
> Here is what I am trying to achieve. I have a database with about 20
> columns(fields), the first one being a unique ID. I am trying to get a
> page which will dispaly the fields in a specific format. So far I am
> able to do this to a certain extent. What I want to happen is that
> when I click on a link on one page, it should use the id number of the
> row (passed thru the url) to load a page that shows the data of that
> row only. I know this is possible because I have seen it many times
> but I dont know how to get the functionality.
>
> Thanks in advance

[Kris Eiben]

Is this what you mean?

page of links:
' set up connection, recordset
do until rs.EOF
nThisID = rs("ID")
sThisName = rs("name")
response.write "<a href='oneRow.asp?id=" & nThisID & "'>" &
sThisName & "</a><br>"
rs.movenext
loop

oneRow.asp:
nThisID = request.querystring("id")
sSQL = "Select field1, field2 from table1 where ID = " & nThisID
' set up connection, use sSQL for recordset, display that record

"Deepiceman" <deepiceman@yahoo.com> wrote in message
news:f07dfae.0308191256.5e22acb5@posting.google.co m...

> Hi folks,
> Here is what I am trying to achieve. I have a database with about 20
> columns(fields), the first one being a unique ID. I am trying to get a
> page which will dispaly the fields in a specific format. So far I am
> able to do this to a certain extent. What I want to happen is that
> when I click on a link on one page, it should use the id number of the
> row (passed thru the url) to load a page that shows the data of that
> row only. I know this is possible because I have seen it many times
> but I dont know how to get the functionality.

[Deepiceman]

That's exactly what I am looking for. I am actually doing part of this
but now that I have more information from you guys hopefully I will be
able to get the rest working.
Thanks again
Deep


"Kris Eiben" <eibenkthisisforspammers@yahoo.com> wrote in message news:<Oo7eYXxZDHA.2572@TK2MSFTNGP12.phx.gbl>...

> Is this what you mean?
>
> page of links:
> ' set up connection, recordset
> do until rs.EOF
> nThisID = rs("ID")
> sThisName = rs("name")
> response.write "<a href='oneRow.asp?id=" & nThisID & "'>" &
> sThisName & "</a><br>"
> rs.movenext
> loop
>
> oneRow.asp:
> nThisID = request.querystring("id")
> sSQL = "Select field1, field2 from table1 where ID = " & nThisID
> ' set up connection, use sSQL for recordset, display that record
>
> "Deepiceman" <deepiceman@yahoo.com> wrote in message
> news:f07dfae.0308191256.5e22acb5@posting.google.co m...

> > Hi folks,
> > Here is what I am trying to achieve. I have a database with about 20
> > columns(fields), the first one being a unique ID. I am trying to get a
> > page which will dispaly the fields in a specific format. So far I am
> > able to do this to a certain extent. What I want to happen is that
> > when I click on a link on one page, it should use the id number of the
> > row (passed thru the url) to load a page that shows the data of that
> > row only. I know this is possible because I have seen it many times
> > but I dont know how to get the functionality.