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 - 2001-02-04 : 11:19:37
|
Bill writes "Hi, I would like to select the table in a DB to pull a Recordset from based on a Quesrystring variable. I have a DB with 50 tables that contain dial-up numbers for an ISP. One the user selects a state the result page is displayed using the correct table.
Recordset1.Source = "SELECT * FROM STATENAME WHERE AreaCode = '" + Replace(Recordset1__MMColParam, "'", "''") + "' AND Exchange = '" + Replace(Recordset1__varExchange, "'", "''") + "'"
'FROM STATENAME' would be the 2 characters varible passed from another page that represents a tablename in the DB.
Thanks" |
|
|
|
|
|
Dynamic Table Selection