[elessar]

Found a few errors and fixed em...works like a charm now....the errors were where i had request.form("strCats") : should have been strCat

duh me

the error is in this line
sqlText = "SELECT * FROM products WHERE catalodID IN ('" & cats & "')"

do a
response.write(sqltext)
response.end()

put them right after the above mentioned line and copy the sql statement to a new query in your database and try to run it.

[elessar]

Thanks for your help Koncept. I found the errors in my sql and now it works.