🚀 go-pugleaf

I use access database and vbscript
What I am trying to do is taking all the number from column ID and make them
variables wich I fill with the value of all the contents of column genre.
In another table I have numbers representing genres and I want to use the
variables I have created and show the content of them on the page.
Here is my code.
I want the variables to be named number1 number2 and so on
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF">
<%
Set Anaconda2 = Server.CreateObject("ADODB.Connection")
Set rs2 = Server.CreateObject("ADODB.Recordset")
Anaconda2.Open "DSN=it-designer2;UID=;PWD="
SQL2 = "SELECT * From genre"
rs2.Open SQL2, Anaconda2
Do While Not rs2.EOF
number&rs2("ID") = rs2("genre")        <<<<<<<<<<<<<<<<Here is where I got
the main problem.
rs2.MoveNext
Loop
Anaconda2.Close

Set Anaconda = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Anaconda.Open "DSN=it-designer2;UID=;PWD="
SQL = "SELECT * From object WHERE objects LIKE '%" & Request.Form("find") &
"%'"
rs.Open SQL, Anaconda
%>

<table width="650" border="0" cellpadding="0">
  <tr>
    <td>Object</td>
    <td>Data</td>
    <td>Siffra</td>
  </tr>
<%
Do While Not rs.EOF
%>
  <tr>
    <td><%=rs("objects")%></td>
    <td><%=rs("data")%></td>
    <td><%=numbr&rs("siffra")%></td>
<<<<<<<<<<<and here I want to show the variables. corresponding to the
number in column "siffra">>>>>>>>>>
  </tr>
<%
rs.MoveNext
Loop
%>
</table>
</body>
</html>

I would be very greatful for all help I can get.

With regards
Tomas Forsman



--
***---***---***---***---***---***---***---***---***
http://www.it-designer.com
http://hemma.kramnet.com/tomas.forsman/flashsite
http://hemma.kramnet.com/tomas.forsman
http://www.freebox.com/vrm
***---***---***---***---***---***---***---***---***