you wouldn't....you'd use it to insert the data in the first place ;-) Other than that, I don't have an easy SQL fic for you.
If you want to get more complex, you could grab the records...loop through and re-order that field using the ListSort() function and update the query object (QuerySetCell()) with the new sorted value....then run a query of the new query object with the properly sorted fields in it and ORDER BY that field (of course you need to be using at least CF 5 to do the QofQ). 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: "Smith, Matthew P -CONT(DYN)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 10:11 AM Subject: RE: OT sql order by > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
