Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ordering the query-Page result
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
ActiveVFP
Title:
Ordering the query-Page result
Miscellaneous
Thread ID:
00891921
Message ID:
00891921
Views:
51
Please helpme.

My problem is the next:
my main web page have some items(as links) sample:

-apples
-oranges
-pineapple

then when the user make click in a item(apples by example)
the code for the each link is :

<%=oProp.ScriptPath +[?action=ChosedItem&item_id=]+'01'%>
<%=oProp.ScriptPath +[?action=ChosedItem&item_id=]+'02'%>
<%=oProp.ScriptPath +[?action=ChosedItem&item_id=]+'03'%>

A query is choosed to show only the records with the item selected. until there
work fine...

Now i need order the result by someone column(sample : color, price,size),
i put this code for the "color" column:
<%= oProp.ScriptPath+[?action=]+oProp.Action+[&order=]+'thecolor'%>

the code for the COM Server is:

FUNCTION ChosedItem
LOCAL lcHTMLfile,lcHTMLout,lcItemId,lcOrder
lcItemId=oRequest.querystring("item_id")
lcOrder=""

IF (ISNULL(lcOrder) .OR. EMPTY(lcOrder))
lcOrder = [1]
ENDIF
DO CASE
CASE oRequest.querystring("order")==[thecolor]
lcOrder= [1]
.
.
.
ENDCASE
(the rest of code)...

The problem is attemp to order the resulted page, when click the column
header...how to store the "item_id" selected in the link code for each
column?.Manually is ok:
<%= oProp.ScriptPath+[?action=]+oProp.Action+[&item_id=]+'02'+[&order=]+'cmarca'%>

Thaks for your help....
William Chavez
Next
Reply
Map
View

Click here to load this message in the networking platform