Asp and an Access Database

[Neilbaker86]

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

Hope this is clear to you.

Neil

[Memnoch1207]

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

[Neilbaker86]

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

[andreys]

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