ASP / Access Database question

[hallm]

I'm new to ASP but I've worked with MS Access for about two years now.&nbsp;&nbsp;I've got a database that I'm trying to implement for the web.&nbsp;&nbsp;I administer an online news site where the content is constantly changing.&nbsp;&nbsp;I've created a page that will list the header information for the newest stories from the database.&nbsp;&nbsp;I need to design a reader asp program to actually display the stories when they are clicked on.&nbsp;&nbsp;I can add the link urls to my list page for each item.&nbsp;&nbsp;For example &quot;&lt;a href = &quot;<A HREF="

http://myserver.com/reader.asp?1&quot"

TARGET="_new">

http://myserver.com/reader.asp?1&quot</A>;&lt;This

is story # 1&gt;&lt;/a&gt;&quot;<br>But how can I take that index value and display only the story I want?

 

[wduty]

the querystring should have key-value pairs so the link should probably be:<br><A HREF="

http://myserver.com/reader.asp?storyID=1"

TARGET="_new">

http://myserver.com/reader.asp?storyID=1</A><br>then

in reader.asp open a connection and select the story with your id. Try something like:<br><br>&lt;% set db = server.createObject(&quot;ADODB.connection&quot<br>db.open &quot;yerDatabase&quot;<br>set story = db.execute(&quot;SELECT * FROM stories WHERE storyID=&quot;&request(&quot;storyID&quot)<br>response.write(story(&quot;title&quot&&quot;&lt;br&gt;&quot;&story(&quot;body&quot) %&gt;<br><br>good luck! <p>--Will Duty<br><a href=mailto:wduty@radicalfringe.com>wduty@radicalfringe.com</a><br><a href= > </a><br>

 

[din]

Hi,<br><br>I guess this link will help you a lot on database manipulation<br><br><A HREF="

http://www.web-savant.com/users/kathi/asp/default.htm"

TARGET="_new">

http://www.web-savant.com/users/kathi/asp/default.htm</A><br><br>Let

me know if it helps <p>din<br><a href=mailto:tidrus@bigfoot.com>tidrus@bigfoot.com</a><br><a href= > </a><br>ICQ # 26094048

 

[hallm]

Thank you very much both of your comments were very helpful.