How to strip #CGI.HTTP_REFERER# after the ? params?

[Scooby_Doobie_Doo]

I am trying to store the #CGI.HTTP_REFERER# address into my database, which works, BUT, I don't want any characters after and including the ? in my url

for example, if I have
http://www.scooby.com/index.cfm?popo=yes&ID=22

I only want to store http://www.scooby.com/index.cfm

How can I strip that stuff after the ? before storing it?

[Scooby_Doobie_Doo · Accepted solution]

Figured it out..

<cfset prefix = " http://">
<cfset full_path = "#prefix#" & "#CGI.SERVER_NAME#" & "#CGI.SCRIPT_NAME#">

[-__cfSearching__-]

Scooby Doobie Doo wrote:
Figured it out..
<cfset prefix = " http://">
<cfset full_path = "#prefix#" & "#CGI.SERVER_NAME#" & "#CGI.SCRIPT_NAME#">

Those are two different things. CGI.SERVER_NAME and CGI.SCRIPT_NAME refer to the current page. CGI.HTTP_REFERER is the previous referring page.

You can use list functions to extract the first part of the HTTP_REFERER string

listFirst(CGI.HTTP_REFERER, "?")

[Oğuz_Demirkapı]

<cfset myNewLink = ReplaceNoCase(cgi.http_referer,"?"&cgi.query_string,"")>