select ... from ... where ... order by companyID = #currentCompanyID#, productName
or select ..., companyID = #currentCompanyID# AS or_fld from ... where ... order by or_fld, productName One of those should work on most DBs (at least the ones that I've used). barneyb > -----Original Message----- > From: Brad Roberts [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 9:09 AM > To: CF-Talk > Subject: Query Sorting > > > I've got an app where several companies share the same database... > > When a user searches for products, XYZ Company wants their > products to show > up first (on their website), followed by other brands. Is there > a way to do > this with one query? > > Thanks, > > Brad > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
