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 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283618 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
