I dunno why on earth you would want to order addresses by street number --
unless they're _all_ on the same street, there's no relevance...
However...
<cfset temp = arraynew(1)>
<cfloop query="myq">
<cfset arrayappend(temp,val(rereplace(myq.streetno,"[^0-9]","","ALL")))>
</cfloop>
<cfset queryaddcolumn(myq,"streetno2",temp)>
<cfquery name="temp">
SELECT * FROM myq ORDER BY streetno2
</cfquery>
<cfset myq = temp>
try that...
Probably have to actually insert the rereplace value into a db column tho
actually...
> Hi, all...
> I'm trying to order street addresses.
> I originally setup the the first field in the address to
> hold the steet
> number and made it numeric so it could be ordered.
> Unfortunately, I found out that some of the addresses had
> no street number,
> but were addresses like "No. 10 Magnolia Park", "No. 12
> Pecan Park", etc.
> "No. 10" is what's now going in the street number field,
> and, of course,
> that field
> cannot be numeric, but a character field. However, that's
> throwing off the
> ordering
> of the properties...
> How would I select out the number, if present, in the
> street number field
> and have Cold Fusion order the query output by the number?
> Thanks for any help!
> Rick
> Rick Faircloth
> WhiteStoneMedia.com
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~~~~|
> 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.
> Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
> ubscribe.cfm?user=633.558.4
s. isaac dealey 954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
