Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: select with a variable


Message #1 by richhern35@h... on Mon, 4 Mar 2002 21:22:14
I am having problems with the following sintax.ngroup is a variable to 

hold the name of the price of three different groups sent it through a 

form. The rest of the program just fine.



ngroup=response.form("ngroup")'works just fine 



objrs.open "select begdate,endingdate," & ngroup & " from prices" 

'this is the part that it does not work. It does not seems to add the 

value of ngroup



group=objrs.Fields(ngroup)

response.write group



Thank you for your help 



Ricardo Hernandez

  Return to Index