Yes, Do it in your query. Try this...

Select artist
>From tablename
Order by length(artist)


-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 27, 2007 10:24 AM
To: CF-Talk
Subject: RE: Regex help looking for a name in a string.

Hi Bobby,

Out of interest, how would I reorder by length? In the query? MySQL 4.1.7

Thanks

Will

-----Original Message-----
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: 27 April 2007 13:47
To: CF-Talk
Subject: RE: Regex help looking for a name in a string.

Reorder by length so the longer names come first. Also, I think you only
need replace(works_string, artist, "<a href='profiles.cfm?e=#profileID#'
target='artistWin'>#artist#</a>", "all")





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276423
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to