How can I get the value from a dynamic table

[AndyApp]

I have a table that is being dynamically populated from a recordset that gets its SQL string from a session variable on another page.

The trouble is, that the results need to be linkable to yet another page and the link needs to include an SQL statement to open the next recordset using the result. i.e. Select * FROM blah WHERE blah ='result'

If the result is just one record then no problem but I can't get it to work if there are more then one records returned even though they have different names.

I think I need to be able to capture the result after it is put into the table, this will make sure it's the right one, and then build the SQL Statement.

Trouble is how?

 

[Bagadonutz]

<table>
<%Do while not RECORDSET.EOF%>
<tr>
<td>
<a href = NEXTPAGE.asp?strResult=<%=RECORDSET(&quot;RESULT&quot%>><%=RECORDSET(&quot;DISPLAY RESULT&quot%></a>
</td>
</tr>
<%RECORDSET.movenext
loop%>
</table>

On the NEXTPAGE.asp:
<%
sSql = &quot;Select * FROM blah WHERE blah = '&quot; & Request(&quot;strResult&quot & &quot;'&quot;
%>

 

[MerlinB]

You can use the IN clause

...WHERE colBlaa IN ('result1', 'result2', 'result3')

if that is what you meant.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)