> If you are using a database query as the source of this information, add a > CASE statement to your base database query to generate a column called > "SortNumber". Then use that column for ordering. Alternatively, you could > add a SortNumber column to your base table.
I wish it were that easy. The information is coming from a number of different sources - RSS feeds, a database or two - and being consolidated down into a single source In theory, I could add a new database table to the site in question, and populate it every X number of hours on a schedule, but that's not exactly how this is set up to function. It's something I'm looking into though. Thanks! __________ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
