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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-22 : 08:41:39
|
| Scott writes "I have 3 dropdown lists. 1 for width, 1 for depth, and one for length. From the selected items in each list i need to build an sql query and print the result in an input statement. Here is an example of what i am trying to do.SELECT request.form("width") FROM pan WHERE ID=request.form("length")I need the answer to end up in an input statement.<input type=text name=panprice value=" query result " >ThanksScott" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-10-22 : 08:55:20
|
| You might want to get some ASP skills under your belt, www.4guysfromrolla.com might be a good start.Basically you build up the SQL statement as a string, then execute it against an ADO data connection. But 4guys will have more detail.Damian |
 |
|
|
|
|
|
dropdown list selection to be used in next sql query