You gave me some good ideas, but I don't have a column to write the sort order. I need to use the Auto increment primary key I should have mentioned that.
Thanks though! Chad > -----Original Message----- > From: Robert Harrison [mailto:[email protected]] > Sent: Tuesday, January 12, 2010 2:06 PM > To: cf-talk > Subject: RE: reorder a query > > > Hope that at least pointed you in the right direction Chad. I know the > queries were different but the method was sound. > > > Robert B. Harrison > Director of Interactive Services > Austin & Williams > 125 Kennedy Drive, Suite 100 > Hauppauge NY 11788 > P : 631.231.6600 Ext. 119 > F : 631.434.7022 > http://www.austin-williams.com > > Great advertising can't be either/or. It must be &. > > Plug in to our blog: A&W Unplugged > http://www.austin-williams.com/unplugged > > > > > __________ Information from ESET Smart Security, version of virus > signature > database 4765 (20100112) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

