> 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.
Well .. either way, you will have to change to something if the CASE values are
not static. Be it a table, or a SQL query. However, if your base query is _not_
a database query, then you do not have many options, AFAIK. You are limited by
the capabilities of QoQ's. It is either, add a sortNumber column and populate
it row-by-row, or use a hack to simulate an OUTER join in QoQ's (tres ugly).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:333717
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
