Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 search/filter in a wizard like sql query across multiple ASP pages

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-04-09 : 07:41:32
Stuart kay writes "Hi, guys just like to say the site is great and normally i don't need to look too far for an answer but this one has got me a little stumped.

My question is. i need to be able to come up with a list of answers to a query based on a users input which they do in a step by step wizard type way across multiple ASP pages.

E.G

First they fill in there details on one page such as D.O.B etc, then they will pick out a price range, type of category, the type of buyer etc on another page. Then fill out some job details on another page.

Then Hopefully the query will produce a list answers based on the information the user filled in.

Now i have started this but am finding it difficult. I have limited the search criteria on many sections with drop down boxes with values from the DBMS but being honest thats really as far as i have gone. Any help would be appreciated even a point in the right direction would be good.

thanks in advance

Stuart Kay"

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2003-04-09 : 08:52:25
Stuart
You could used dynamic SQL building/parsing your variable(s) across the asp pages upto final execution of the query

Have a look here
[url]http://www.sqlteam.com/item.asp?ItemID=2077[/url]

Andy

Go to Top of Page
   

- Advertisement -