Lantica User Forum - Sorting in ascending order on a unique number

(UTC)

Lantica User Forum › Archived Topics › Archived Topics › Sorting in ascending order on a unique number

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Sorting in ascending order on a unique number (Read 923 times)

rtaaop Member Offline No personal text Posts: 27 Joined: Dec 27^th, 2003	Sorting in ascending order on a unique number Jan 15^th, 2004 at 8:22pm	Print Post
	In search update if I F10 using no sort spec the retrieve brings up the first unique number, in my instance the number 32 followed by the correct numerical sequence all the way to end of the data. On the other hand, if I specify an ascending sort on the unique number at the sort spec the first number retrieved is 1003. In reality the next number in my data is 111 followed 112 and so on in proper numerical sequene. This is the sort I prefer. How do I tell Sesame to do it the way I want it? Thanks for your help.


	IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Sorting in ascending order on a unique number Reply #1 - Jan 15^th, 2004 at 8:36pm	Print Post
	I bet that the field type for the field with the unique number is set to Text. This will cause the values to sort as if they were regular text values, in which case 10... comes before 11..., so 1003 comes before 110. Try changing the field type to Number using the Field Manager. Instructions for doing this begin on page 116 of the User Guide.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

rtaaop Member Offline No personal text Posts: 27 Joined: Dec 27^th, 2003	Re: Sorting in ascending order on a unique number Reply #2 - Jan 15^th, 2004 at 9:29pm	Print Post
	Duh! Thanks Hammer. You were right. All is well.


	IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›