Hi, all... I need to have my client's properties show up first in a list with other companies.
How would I use "order by" or "group", etc., to get their properties first? It can't be alphabetically or numerically. Their name is not the first alphabetically. And even if it were, another company could be added at any time to the data whose name might precede theirs. Is there a way to do this in the code or should I just add an "order_by" field to the db (MySQL 5) and just put 1 in their field and leave everyone else's field null? (This sounds reasonable and simple enough) Thoughts? Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
