Order the data

[Speedy Gonzalez]

Hi,

I am making a page which should display a table with information. Now it's showing this randomly.

I want the data to be ordered on the date. How to do this in SpeedScript?

Thanks

 

[Casper]

Just like it would be in a normal Progress browser: Make sure the right index is used. If there's no suitbale index write the data first to a temp-table and make there the right sort.

Casper.

 

[jongpau]

Or if you don't have a suitable index, add a simple "BY <date-field>" to the query. Should work fine provided that the amount of data in the table is not too much (otherwise adding an index would be a far better idea).

 

[Speedy Gonzalez]

Or if you don't have a suitable index, add a simple "BY <date-field>" to the query. Should work fine provided that the amount of data in the table is not too much (otherwise adding an index would be a far better idea).

Hi,

thanks, it worked. I created a combined index of the unique number and date.
Plus I've added a 'BY' in the for each and its working fine!

thanks!