Variables for sorts in hyperlinks

[Chris Freeman]

I'm returning to Frontpage ASP programming after about a year, and I'm now
using FP2003. I have some old pages that I'm reworking, and now my simple
sort varibles are not working. I using simple statements like:
fp_sQry="SELECT * FROM Projects Order By Control_Number '::SORT::'"

and the hyperlink is:
http://www.123.com/page_1.asp?sort=asc

This used to work no problem, but now I get this error:
Database Results Wizard Error
Unable to find operator in query string. Query string currently is SELECT *
FROM Projects Order By Control_Number '::SORT::'

What going on here? I know there are issues with FP2002 upgrading to FP2003.
Do you have any suggestions?

 

[Stefan B Rusynko]

Were are you processing the query string sort=asc
Somewhere above the DBRW you need
SORT=Request.QueryString("sort")

Or the tweaks at http://spiderwebwoman.com/thingumajig/tweaks.htm#passing may help
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I'm returning to Frontpage ASP programming after about a year, and I'm now
| using FP2003. I have some old pages that I'm reworking, and now my simple
| sort varibles are not working. I using simple statements like:
| fp_sQry="SELECT * FROM Projects Order By Control_Number '::SORT::'"
|
| and the hyperlink is:
| http://www.123.com/page_1.asp?sort=asc
|
| This used to work no problem, but now I get this error:
| Database Results Wizard Error
| Unable to find operator in query string. Query string currently is SELECT *
| FROM Projects Order By Control_Number '::SORT::'
|
| What going on here? I know there are issues with FP2002 upgrading to FP2003.
| Do you have any suggestions?
| --
| Chris Freeman
| IT Project Coordinator