2. ASPRunnerPro General questions
  3. Dynamic Queries
This topic is locked

Dynamic Queries

 		9/23/2003 22:54:46
ASPRunnerPro General questions
V
 vbrimley author

I have a page that I have created that has 7 fields the key fields being (jobno,custno). Jobno is to be a hyperlink to a folder at the root level named [jobno]. How can I dynamically chage the asp code so that the sql query can except (custno) as where condition? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=177&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Sergey Kornilov admin 9/25/2003

Hi,
you can find a section in your ..._list.asp file where strSQLvariables is calculated (usually lines 77-120) and add additional WHEREcondition

WHERE custno = Request.QueryString("custno").
If you are registered ASPRunner user you can zip and send me ASP files and database and I'll get it fixed for you.
Best regards,

Sergey Kornilov
V
 		vbrimley author 10/1/2003

Thanks Sergey,
Worked like a charm. I'm working on my next question.