|
|
Other way: OK so then I can set those values to variables like this:
<cfoutput query="qrysales">
<cfif find("google.it", qrysales.referer)>
Google Italy <cfset googleit=qrysales.referer>
<cfelseif find("google", qrysales.referer)>
Google <cfset google=qrysales.referer>
<cfelseif find("msn", qrysales.referer) or find("live.com", qrysales.referer)>
MSN Live <cfset msn=qrysales.referer>
<cfelseif find("yahoo", qrysales.referer)>
Yahoo <cfset yahoo=qrysales.referer>
<cfelseif qrysales.referer does not contain "google" or qrysales.referer does
not contain "yahoo"
or qrysales.referer does not contain "msn">
Other search engine <cfset otherse=qrysales.referer>
</cfif>
</cfoutput>
How do I get a "record count" of the newly set variables? len(googleit) give
me the chars in each record not the number of records?
|
|