Asp and an Access Database

Hi,

Ive attached a database called kbdb.mdb

If my asp page is given the 'ArticleId' how can I list all the other information in that row?

Like this:

Input:
ArticleId

->

Output:
Product
Keywords
Date
Time
ShortDescription
Longdescription

Many thanks :D

Hope this is clear to you.

Neil

"SELECT * FROM tableName WHERE articleId = " & request("articleId")

Can anyone include the rest of the code?

Im still fairly new to asp and dont really know what to do with that piece code?

Thank you :)

Code:

---


Dim rs, strSQL, conn

conn="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mapath("\db\yourdb.mdb")
strSQL="SELECT * FROM tableName WHERE articleId = " & request("articleId")

set rs=server.createobject("ADODB.Recordset")
rs.open strSQL, conn

if not rs.eof then

    response.write "<table border='1'>"
    response.write "<tr>"

    for i=0 to rs.fields.count-1
        response.write "<th bgcolor='silver'>" & rs(i).name & "</th>"
    next

    response.write "</tr>"
   
    do until rs.eof
        response.write "<tr>"
        for i=0 to rs.fields.count -1
            response.write "<td>&nbsp;" & rs(i).value & "</td>"
        next
        response.write "</tr>"
        rs.movenext
    loop

    response.write "</table>"
else
    response.write "No data found!"
end if

rs.close
set rs=nothing

---