How would you use the cf-side sorted list within a SELECT statement to return the records in the proper order?
Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:22 AM To: CF-Talk Subject: Re: OT sql order by FYI....that function would be used after the data is retrieved. If you want to get it out of the DB in the proper order, use that function to sort the list before you insert it into the DB. HTH Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 8:15 AM Subject: Re: OT sql order by > ListSort(YourField,"numeric") > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > --------------------------------------------------------- > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > ----- Original Message ----- > From: "Tim Do" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, December 17, 2002 8:04 AM > Subject: OT sql order by > > > > hello... > > I have a varchar field in sql2000 that I use as unit #'s for apts. They > can > > enter as "1,2,3a,4b,10". I would like to order that by the unit number, > but > > since its a varchar, it comes out "1,10,2,3a,4b". How would I order it > like > > this: 1,2,3a,4b,10 > > > > TIA > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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.