December 3, 2008 11:05am pst

1. TheLearn... 366,074
2. jaime_oliv... 278,032
3. jpaulino 257,396
4. Idle_Mind 229,856
5. Dhaest 219,462
6. emoreau 182,441
7. Fernando... 160,205
8. graye 152,982
9. angelIII 132,665
10. webtubbs 115,033
11. PaulHews 100,392
12. VBRocks 99,530
13. Sancler 95,919
14. ZachSmith 94,965
15. ragi0017 91,667
16. jcoehoorn 82,320
17. philipjonat... 78,411
18. naspinski 73,338
19. ororiole 69,521
20. EricTViking 66,739
21. GreenGho... 64,597
22. prairiedog 63,725
23. BondinASP 63,211
24. TechTiger... 63,125
25. vb_jonas 61,575

1. TheLearn... 2,030,212
2. iboutchkine 807,868
3. Idle_Mind 705,267
4. emoreau 561,528
5. mmarinov 556,677
6. gregoryyo... 503,766
7. naveenko... 451,699
8. jaime_oliv... 436,792
9. graye 394,301
10. Dhaest 373,967
11. Fernando... 368,770
12. testn 352,601
13. jpaulino 347,798
14. RobertRFr... 333,569
15. YZlat 332,657
16. surajguptha 324,880
17. AlexFM 304,664
18. Arthur_... 289,124
19. angelIII 263,908
20. Mikal613 248,858
21. VBRocks 222,970
22. _TAD_ 221,029
23. roverm 217,141
24. samtran0... 216,895
25. Sancler 210,276

08.13.2008 at 08:57AM PDT, ID: 23645145

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.6

Variables in ASP SQL select statement

Asked by Michaelj42 in .Net Editors & IDEs, MS SQL Server, SQL Server 2005

Tags: ASP SQL VB, ASP 2.0, SQL 2006

I'm trying to list a set or records but them give the user the ability to filter the results based on Items.[PART NO]. My select statements are working if I put them in manually but the trouble I'm having is getting a variable into the select statement. I tried writing the select as a variable with the code show below.

This works fine if I write it to the page as text to test my variable but I can't seem to get it to work on the ASP part.
I'd envisioned something like:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ... %>"
SelectCommand= sqlstring
</asp:SqlDataSource>Start Free Trial

         
           
           
             dim partnum as string
dim sqlstring as string
partnum = request.querystring("partnum")
     if partnum = "" then
              sqlstring = Chr(34) & "SELECT Jobs.JOBNO, ... ORDER BY Shipments.DueDate" & Chr(34) & ">"
     else
              sqlstring = Chr(34) & "SELECT Jobs.JOBNO, WHERE Items.[PART NO] = '" & partnum & "' ORDER BY... ">"
end if
 
 
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
       ConnectionString="<%$ ... %>" 
       SelectCommand= "SELECT Jobs.JOBNO, ... ORDER BY Shipments.DueDate">
</asp:SqlDataSource>

           
         

Keywords: Variables in ASP SQL select statement

	Title
1	sqldatasource querystring parameter
2	Populating FormView textboxes from a…
3	Problem with paramenters on using SQ…
4	sql statement from a sqldatasource
5	Help With SQL DATA Source Control
6	Altered Formview not inserting record

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Variables in ASP SQL select statement

Asked by Michaelj42 in .Net Editors & IDEs, MS SQL Server, SQL Server 2005

Tags: ASP SQL VB, ASP 2.0, SQL 2006

About this solution