need your help to create a link (ASP newbie)

[ssnapier]

I am the admin of an ASP based forum using Access as the database. I am trying to implement a modification where my users can click a link to jump directly to the last post in a thread...

Here is the link I have now that gets me to the last page of the thread:

response.write &quot;<a class=&quot;&quot;threadlink&quot;&quot; href=&quot;&quot;&quot; & sValidatedBaseURL & &quot;/thread-view.asp?threadid=&quot; & vThreadRows(0, index) & &quot;&amp;posts=&quot; & vThreadRows(4, index) & &quot;&quot;&quot;>

Now here is where I am getting lost... the messageID column that would get me to the last post is in a different table then where the info above in being pulled from. The existing stuff is all pulled from a table called &quot;threads&quot; and the column I need is in a table called &quot;messages.&quot;

How can I put the two together in one link?

 

[alsoknownas]

have you tried:

response.write &quot;<a class=&quot;&quot;threadlink&quot;&quot; href=&quot;&quot;&quot; & sValidatedBaseURL & &quot;/thread-view.asp?threadid=&quot; & vThreadRows(0, index) & &quot;&posts=&quot; & vThreadRows(4, index) & &quot;&quot;&quot;>

[/tt]

 

[yahve]

Hi,

Simple: use two recordsets. Open the database connection, get the info from the 1st table in one recordset, get the info from the 2nd table in another recordset using the same connection.

Bye.

 

[ssnapier]

can you give me an example of how to do this please?