querystring to function

[bslintx]

Hey all,

New to asp. I had seen this before but not sure what keywords to search for. I have a few populated select boxes and then onchange it submits a form value through get method. How do you request("anyquerystring") to put in one sql statement with a where clause looking for that querystring in a database? Reason why is because I have a table with same data fields and I don't want to replicate for each request querystrings. I guess adding it to a function.

 

[vikramonline]

Request.querystring("varname")

 

[simonchristieis]

try this

sql ="Select * from dbTable where dbField = '"& Request.Querystring("formField") &"'"

hth

simon