Your code looks for Request.QueryString("sort"), but you are using the html_out variable to return content to the browser, which is probably an indication that you are using FoxWeb 1.29c. The Request object was introduced in FoxWeb 2.0. For older versions you must use the FormField function, or manually parse the CGI.QueryString property.
Also, your code is looking for a QueryString field called "sort", but your URL contains the sort order in a field called "bsortorder".
And by the way, you are still missing a single quote at the end of your html_out string after the </A> tag.
Sent by Tim Bowen on 10/07/2004 07:24:37 AM:
the ";" was becasue it continued on the next line, I was just giving you the text I am concerned with. My code in qq1.fwx is as follows:
bSortOrder = Request.QueryString("sort")
bSortOrder = 'price'
FROM &mDBFyear ORDER BY &bSortOrder;
INTO CURSOR results
html_out = html_out +'<pre>'+'<font color="green">'+'<A; HREF="https://lmca-server4/lmca/qq1.fwx?filter=XXX&bsortorder=status">STATUS</a>
when the user clicks on the hyperlinked "STATUS" a timeout occurs, does something look suspect to you?
Sent by FoxWeb Support on 10/06/2004 04:59:11 PM:
You are not giving us enough information, but it does seem that you are missing a quote at the end of your string. Also, what's the semi-colon for?
Sent by Tim Bowen on 10/06/2004 08:54:02 AM:
Thats what I figured but I must be doing something wrong becasue I keep getting a timeout. Can you kindly tell me my syntactical error in this line?
html_out = html_out +'<pre>'+'<font color="green">'+'<A HREF="https://lmca-server4/lmca/qq1.fwx?filter=XXX&bsortorder=status">STATUS</a>;
bsortorder gets defined in qq1.fwx(prg)
Sent by FoxWeb Support on 10/05/2004 10:49:02 PM:
As you can see, the link points back to the fwx file. When it receives such a request, your script should re-create the page, sorted by the field specified in 'sort=xxxx'.
Sent by Tim Bowen on 10/05/2004 10:47:03 AM:
does it make the fwx call itself again?
Sent by FoxWeb Support on 09/28/2004 06:15:09 PM:
You can turn the headers into links that point back to the same fwx file, but pass an additional query string field back to the server. For example:
Sent by Tim Bowen on 09/28/2004 01:22:44 PM:
I want to be able to include clickable sort header titles to my output. So if a user gets results returned like you see here