help! Advice Needed ~ Quite long 1

[LoopDemon]

Hi I know this question may seem so simple but it may provide a laugh?
I would like some advice please.
I am having difficulty in understanding how to program ASP code.

How do I structure my code if I have 2 asp pages. page1 provides user options in a form list/menu text box etc. The form calls an echo script which reads the values. fine.
I really need a basic example of how to structure code to display the results of the search back to the webpage.
I can do it once to display all results from an access table back into to the web page.

I am using a select case on the list/menu which sets the sql statement. But is this wrong? Any advice would be helpful.

Basically I have read zillions of examples but they all handle one statement and perform one search on the database. But I need to see an example of several. I think I need to construct if else statements, am I right?

Than Q 4 your time.

Boris

 

[Genimuse]

I recommend the ASP tutorial at

http://www.w3schools.com,

followed by the ADO tutorial there. Both are short and to the point, and will both do a good job of filling you in on how ASP works and how to work with a database using it (ADO).