By Bill Graziano
on 29 July 2000
| 3 Comments
| Tags: Queries
Alejandro writes "Please help me, I can't write the syntax for something like this: search?cat1=America&cat2=EEUU . . . "
MySQL = "SELECT * FROM MiTable WHERE cat1='" & Request.QueryString("cat1") & cat2='" & Request.QueryString("cat2") "'"
Select *From MiTableWhere cat1 = 'America'and cat2 = 'EEUU'
MySQL = "SELECT * FROM MiTable "MySQL = MySQL & " Where cat1='" & Request.QueryString("cat1") & "'"MySQL = MySQL & " and cat2='" & Request.QueryString("cat2") & "'"
Discuss this article: 3 Comments so far.
Print this Article.
If you like this article you can sign up for our weekly newsletter.
There's an opt-out link at the
bottom of each newsletter so it's easy to unsubscribe at any time.
Using Dynamic SQL in Stored Procedures (7 March 2011)
Joining to the Next Sequential Row (2 April 2008)
Writing Outer Joins in T-SQL (11 February 2008)
Aggregating Correlated Sub-Queries (23 October 2007)
How to Use GROUP BY with Distinct Aggregates and Derived tables (31 July 2007)
How to Use GROUP BY in SQL Server (30 July 2007)
Returning Complex Data from User-Defined Functions with CROSS APPLY (11 June 2007)
Returning a week number for any given date and starting fiscal month (2 May 2007)
SQL to XML grouping (0 Replies)
Rename primary key column (0 Replies)
Resource Governor on SQL Agent Job (2 Replies)
Repair Corrupt Access Database File (0 Replies)
Msg 4104, Level 16, State 1, Line 1 The multi-part (4 Replies)
Msg 4104 (0 Replies)
Finding last Saturday date then range last 28 days (5 Replies)
One updated row fires trigger twice after merge re (5 Replies)
Weekly SQL Server newsletter with articles,
forum posts, and blog posts via email. Subscribers receive our white paper
with performance tips for developers.
SQLTeam.com Articles via RSS
SQLTeam.com Weblog via RSS
- Advertisement -
SQL Server Resources
Advertise on SQLTeam.com
SQL Server Books
About the Site