&nbsp;<BR>tough one I know. thanks for taking a look.<BR><BR>here is my code;<BR><BR>set connect = server.createobject("Adodb.connection")<BR>connect .Open connString<BR>query = "SELECT * FROM Products"<BR> <BR>set rs = server.createobject("ADODB.Recordset")<BR>rs.open (query), connect, adOpenStatic, adlockOptimistic <BR><BR>dim counter<BR>counter=1<BR><BR>do until rs.eof<BR><BR> Select Case iItemID<BR> <BR> Case Counter<BR> aParameters = Array( rs("ProductName") , rs("productDescription") , rs("productPrice") )<BR> <BR> End Select<BR><BR>counter = counter + 1 <BR>rs.movenext<BR>loop<BR><BR><BR><BR><BR>so, i&#039;m connecting to the db, then trying to create a dynamic select case statement.<BR><BR><BR>this isn&#039;t working btw. any ideas ?