Date can be stored yyyy-mm-dd and will sort nicely. Numbers, true. I guess I can ask the admin when the table is being created if the data to be stored will be numeric or alphanumeric, although in the online report I'll be using the TigerTable javascript which I believe allows you to sort by either method.
I'm told that shorter fields will sort faster. I could be told wrong. Thanks, Mik At 04:05 PM 7/12/2007, you wrote: >Mik Muller wrote: >> >> I don't want to even try to type these columns. Once the form data is >> submitted, it's all text, pretty much, right? > >That means sorting by date or number is out. > > >> My thinking is I make *all* the dynamic table columns from the form fields >> VARCHAR and give the admins a drop-down for maximum data width when creating >> the tables, ie; 5, 10, 20, 30, 40, 50, 75, 100, 150, 200, 300, 400, 500, >> 750, 1000, 1500, 2000, 2500, 3000, 4000, with the stressed caveat that >> shorter fields will retrieve and sort quicker in their reports. > >Will they? > >Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
