ok forget that .. Sorry .. should have checked the docs more thoroughly - the answer is the keyword is "number" not "numeric".
It's sorting correctly now. But thanks anyway everyone. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 7/31/07, Mike Kear <[EMAIL PROTECTED]> wrote: > Does anyone know how to make spry sort columns in a data table > numerically? I have a spry dataset that displays the values, and > sorts when i click on the column heading but it sorts the numerical > values in teh columns as though they're alphabetical. > > e.g: > 145, 45, 715, 8 rather than 8, 45, 145, 715 > > The datatype is set in the dataset definition as > "dsValues.setColumnType("HOURS","numeric");" > but it isnt sorting numerically. > > Is there a secret I've missed here? > > -- > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
