2. ASPRunnerPro General questions
  3. Order by
This topic is locked

Order by

 		3/18/2005 5:58:30 PM
ASPRunnerPro General questions
author

Hi

its me back again
Is there a way the order by ID DESC can be placed in _variables.asp as a permanent fixture.
I have placed ORDER BY [ID] DESC in step 4

but if i then go for vertical layout it defaults to [ID] ASC

works fine on horizontal layout as you can click on NAME to sort by ASC or DESC

This facility is not available in Vertical layout

Pulling my hair out to configure it....
on _list.asp i search by Name but gives me the first ID number

same applies on _search.asp using vertical layout..
Basically i am trying to get users to view profiles by the latest addition not

by the first entries
P.S.

The facility to sort order by is not available in Vertical layout
Sergey Kornilov admin 3/23/2005

Hi,
you can use vertical layout and DESC sorting together.
Could you tell me how do I reproduce this problem?
If I choose DESC sorting and vertical layout everything works OK.
500226 3/24/2005

Hi
If you use vertical layout orderby it does the search according to your instructions

i.e orderby [UpdateNow]] Desc yet if you click again on the same search it comes back

[ASC] not sure if if its a quirk in SQL statement.
I have overcome this now by hardcoding the include file _variables.asp
LINE===
strRightWrapper="]"

gstrOrderBy="ORDER BY [UpdateNow] DESC"

bKeyFieldEditable1=True

bKeyFieldEditable2=False
AND the _list.asp on output as follows
==========

Session.LCID = 2057

On Error Resume Next

Dim rs, dbConnection

strOrderBy="ORDER BY [updatenow] DESC"

' strOrderImage=""

' Call CalculateOrderBy
==========
As vertical layout does not give you the opportunity to click on the field to sort

by ASC or DESC as in normal layout
Sergey Kornilov admin 3/25/2005

Hi,
Please zip and send to support@xlinesoft.com all files from ASPRunnerPro output folder with subfolders along with project file and your sample database. I'll find what's wrong running it on my test box.