Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing string to asp page to be placed as ORDER BY column in SELECT
Thanks for the input. Unfortunately this is a FrontPage generated view.asp. "Request" is not defined. When passing an ID to a "detial.asp?co_ID=4" page the parameter is referenced as ::co_ID:: in the <!--webot.. s-criteria="{co_ID} EQ {co_ID} +" s-order...- Varmit
- Post #8
- Forum: Microsoft: ASP (Active Server Pages)
-
Passing string to asp page to be placed as ORDER BY column in SELECT
I have given up for now. Just a note: the s-criteria and s-sql=" are Front page generated and appear to be "declarations" for the asp code. If you try to modify the code itself, FrontPage will overwrite your changes based on the information in the comment <!--webbot...- Varmit
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
Passing string to asp page to be placed as ORDER BY column in SELECT 2
Rephrase of earlier question http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/31/pid/333/qid/134621 Hyperlinking to -- view.asp?sortcol=company_name in the asp section <!--webbot DatabaseRegionStart .... s-criteria s-sql="SELECT * FROM company_table ORDER BY ??????? " .... -->...- Varmit
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
Passing string to asp page to be placed as ORDER BY column in SELECT
Thank you . It looks like the insert area is ' " & val & " ' where there are single quotes surrounding double quotes. When using your syntax as follows: s-criteria= s-order s-sql="SELECT * FROM co_table ORDER BY '" & sortval & "' " The following error...- Varmit
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Passing string to asp page to be placed as ORDER BY column in SELECT
I am trying to do what I know is a very simple thing. Unfamiliar with ASP / Select statement variable syntax, I can't figure out how to: call the page view.asp?sortcol=company_name (string) and put the proper place holder into the web bot comment seciton declaring the sql=SELECT...- Varmit
- Thread
- Replies: 9
- Forum: Microsoft: ASP (Active Server Pages)
