OHHHHHHHH>> ouch -
I literally just finished adding the column and populating it with
stupid 1's or 10's !!!
I will certainly try this out and see if i cna get it to work in a non
oracle world.
thanks!!!! it makes perfectly good sense.
jay miller
Brad Howerter wrote:
Here's an Oracle solution:
ORDER BY iApplication, iModule, DECODE(sFeatureSubHeading, 'General
Features','0', sFeatureSubHeading)
This will cause General Features to sort as if it were '0', which will
move it up to the front of the list.
Hello list - I have a query that specifys a specific order - I need to
take the last value in the order by statement and alter that... for
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
