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
 Site Related Forums
 Article Discussion
 URL QueryString in SQL FROM clause?

Author  Topic 

brandt719
Starting Member

2 Posts

Posted - 2007-02-02 : 12:59:55
Is it possible to pull a URL QueryString into the FROM clause of a SQL statement? I have an ASP page that has a drop-down list of names of people in a particular group. Now, I would like for the drop-down list to pull a NEW group of folks from another table IF a particular URL Querysting is present. For example: www.mysite.com/default.asp?GroupID="ZTA". Is this possible? I use url querystrings in WHERE clauses, but I get a syntax error when I try to use it in a FROM clause. I appreciate any advice you could give me. Thanks

Kristen
Test

22859 Posts

Posted - 2007-02-02 : 13:11:15
Duplicate of: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78505
Go to Top of Page
   

- Advertisement -