You could try the simpler form of the URL in your table, so "domain.com"
instead of "www.domain.com" and then build a custom string with just the root
of the domain name:
<cfset cgiURL = cgi.server_name>
<cfset urlLen = listLen(cgiURL, ".")>
<cfif urlLen gt 2>
<cfset cgiURL = listGetAt(cgiURL, urlLen - 1, ".") & "." & listLast(cgiURL,
".")>
</cfif>
then in the query
....
WHERE URL = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#cgiURL#">
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314372
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
