[gurutech]

Hi everyone!

I have a small project I'm working on, and need to do the following:

- Pass a parameter from a web link into an ASP page (like http://website.com/index.asp?parameter=999999 )
- Look up the parameter value (from above) in a database
- Pull data from this database, based on the parameter value
- Have users take a survey (yes/no questions)
- Export the survey data and the data from the previous database into a separate database

The survey itself should ask questions based on user responses on previous questions (ie. if a user answers "No" to a question, the next question will be different than if they had answered "Yes".)

I'm assuming this can be done through VB and ASP, but if it can only be done via JavaScript, that's OK too. I'm more familiar with VB though...

Thanks in advance!

[peterh40]

1. To pass value tos another page use Response.Write("...put url here...") whith the parameters you specify.
2. To get values use the var = Request("Parameter")
3. For Sql use the SQLClient, you can use SqlCommand and add Parameters to the command
sqlcmd.CommandText = "enter sql command string here"
e.g. sqlcmd.Parameters("Param1").Value = a_value
then use sqlcmd.Execute to run which can be reader with a DataReader type to read the values from table.