that is the sql that is needed. at the top of the page (your form action one) you put
response.write(request.form("name"))
response.end()

does it show the correct list of items? if so then all you need to do is modify your sql select.

correct me if im wrong, you used macromedia dreamweaver to create the db code?