2. ASPRunnerPro General questions
  3. Ordering records on input
This topic is locked

Ordering records on input

 		5/30/2005 7:48:45 AM
ASPRunnerPro General questions
T
 The Capt author

I am having a problem with the order of records when I add a new record.
I have two fields, House Number and Road Name. I want the records to appear in road name and then in house number order starting with 1 and working upwards. I have about 50 different roads in my database.
I have set the order of records to Road in ASP Runner on the List Page but when I add a new record it appears at the bottom of that road's numbering range.
e.g I have records of 1, 2, 4, 5, 6 Smith Road and when I add a new record for number 3 Smith Road the order appears as 1,2,4,5,6,3 Smith Road.
Any idea how I can get these records to appear in order i.e. Sort by road then sort by number
Thanks
TheCapt
Sergey Kornilov admin 5/30/2005

Hi,
proceed to Choose fields tab in ASPRunner and click ORDER BY- Change ... button.

Add Road Name and then House Number to the right window and set ASC order for them.
T
 		The Capt author 5/30/2005

Thanks Sergey
Almost works. I now get the house numbers in the following order: example from one road
4, 42, 44, 46, 55, 58, 6, 60, 62 7, 72, 73 etc.
It is putting the single numbers together with the 10's
You help is appreciated
Regards
TheCapt
Sergey Kornilov admin 5/31/2005

Hi,
make sure the House Number field type in database is Numeric.
T
 		The Capt author 6/2/2005

Thanks that was the problem. Boy you are good
Thanks
TheCapt