For this code, my query calls a1domin, a2domin, and a3domin.  But I am 

getting an error stating that a4domin can't be found.  Why is it being 

sought when I didn't ask for it?



with myCommand

 x=1 

 while myDataReader.read()

  

 response.write (myDataReader.item("prodid"))

 response.write (myDataReader.item("proddesc"))

 

 if mydatareader.item("a" & trim(str(x)) &"domin") <> "" then

 response.write ("$")

 response.write (myDataReader.item("a" & trim(str(x)) &"price"))

 response.write ("<br>")

 else

 response.write ("%")

 end if

 

 x += 1

 end while

 end with