I get this error:
Item cannot be found in the collection corresponding to the requested name or ordinal.

/catalog/newlook2.asp, line 102

Here is the code from that line:

pricePercent = (rsQuery("numPercent" / 100)

Here is my SQL statement:
rsQuery.Open "SELECT MAVproducts.numPercent, MAVproducts.blnNew, MAVproducts.productID, MAVcategories.Category,MAVproducts.gender, MAVproducts.productName, MAVproducts.blnSale, MAVMAVproducts.description, MAVproducts.templateID, MAVproducts.pictureFile, MAVproducts.sizes,MAVproducts.colors, MAVproducts.price FROM MAVcategories, MAVproducts WHERE MAVcategories.CategoryID = MAVproducts.categoryID AND MAVproducts.productID=" & Request("itemid" & "",Conn,adOpenStatic

I dont understand because I have the right name of the database field. But it's not working!

Buddy