Imagine you sell 1000 products. 900 are made by ProForce and 50 are made by Adidas and 50 are made by Macho. Since your margins are better on the ProForce gear, you want the ProForce gear to show up first (to help entice the customer). Keep in mind, this is a hack. I am looking into a sorting type tool to add to the site's admin so I won't have to resort to these measures.
-----Original Message----- From: Phillip M. Vector [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 9:50 PM To: CF-Talk Subject: Re: Quick sorting hack... I'm unsure what you are asking. Can you give a sample of what you want the list to look like? So you want that item as last? If it's something like that, why not put in a "This is last" flag on the database table and do a sort like.. ORDER BY ProductName, Last On 7/19/07, Che Vilnonis <[EMAIL PROTECTED]> wrote: >> Looking for a hack that I know is not a best practice. This is a >> temporay fix. >> >> For example, I have a product called, "Adidas Neoprene Uniform" >> What character (Ascii maybe?) can I put in front a the work Adidas >> that is "invisible" or small to the user but makes it sort to the end >> of a product list that is sorted by product name? >> >> Che Vilnonis >> Application Developer >> Advertising Systems Incorporated >> 8470C Remington Avenue >> Pennsauken, NJ 08110 >> p: 856.488.2211 >> f: 856.488.1990 >> www.asitv.com >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
