[thelist] SQL problem

[Kevin Stevens]

> In another database, or table? I don't think that you have given us enough
> info to solve the situation. Are there two tables, two table in two
> databases, or something else? Can you describe the tables?

OK, sorry, I think I've been getting my jargon wrong. I have 2 tables, 1
called Descs which contains just two columns...

PKey ¦ Catagory
-----------------------------------
1       ¦ Music
2       ¦ Humour
3       ¦ Computer stuff

and a second table called FaveList which contains

Primary_ID ¦ pkmatch ¦ Description
----------------------------------------------------------------------------
1               ¦ 1            ¦ Cardiacs Homepage
2               ¦ 1            ¦ Offspring Homepage
3               ¦ 2            ¦ Popbitch
4               ¦ 3            ¦ Evolt

What I am trying to do here is put all the contents of my Favourites folder
on-line so I can access them wherever I am. So the idea is to print the
catagory and then populate a dropdown box next to it with anything that
matches PKey with pkmatch and display the results using PKey in ascending
order. Here's the relevant code...

set RSPKey = conn.execute ("select PKey from Descs")
do until RSPkey.eof = true
set PKey = (RSPKey("PKey"))

set RSDesc = conn.execute ("select Catagory from Descs")
do until RSDesc.eof = true

response.write "<table border=1 cellspacing=10 cellpadding=1>" &"<tr>" &"<td
width=100px>" &(RSDesc("Catagory")) &"</td>"

set RSOptions = conn.execute ("select * from FaveList where pkmatch ="
&PKey)

do until RSOptions.eof
content = content &"<option>" &(RSOptions("Description")) &"</option>"
RSOptions.movenext
loop

RSOptions.close
set RSOptions = nothing
%>

<form method="post" action="siteresult.asp">
<td width="300px">
<select size="1" name="dropdown_menu">
<%=content%>
</select>
</td>
<td>
<input type="submit" value="Go to site">
</td>
</form>
</table>

Hope I've explained myself properly this time :)

Kevin Stevens
kjs at ratking.co.uk