multiple orderby parameters on a URL

This topic is locked

multiple orderby parameters on a URL	2/5/2010 10:14:02 AM
ASPRunnerPro General questions
B boater21 author Hi guys, I'm trying to us a link created dynamically in another application to bring up the ASPRunner list page. I need it to sort by multiple columns. I can figure out how to sort by one column, just by including the orderby parameter on the URL, but I can't figure out how to sort by multiple columns. I know that ASPRUnner allows me to do this by clicking on the columns, but my users have requested automatic sorting by two columns just by clicking on the URL from an outside (non-ASPRUnner) web page. How can I accomplish this? Thanks!


J	Jane 2/9/2010
	Hi, you can pass two parameters in the URL. Here is a sample: tablename_list.asp?orderby1=FieldName1&orderby2=FieldName2 Then check these parameters in the List page: Before SQL query event on the Eventstab and add ORDER BY statement to the SQL query manually.