capture a search string

Hello, Is there some CF coding that I can employ that will capture a search string when users type a search and later on provide it in a report. At minimum we should capture the dateTime, userIP, search string and number of search results. The data will be stored in an SQL table. Thanks. RO HWW

That sounds like an application specific question. The search string is most likely submitted via form field so you can grab that from the form scope obviously. The ip address can be grabbed from cgi.remote_addr The date/time can come from #now()# The result count comes from your queries recordcount result. Then you just stick it all in a table. Hello, Is there some CF coding that I can employ that will capture a search string when users type a search and later on provide it in a report. At minimum we should capture the dateTime, userIP, search string and number of search results. The data will be stored in an SQL table. Thanks. RO HWW

I do exactly what Bobby suggested: On the "search results page" I save the user info (IP, if logged in, etc), date-time stamp and whatever was in the "form field(s)" to a table in the DB. However - I do not save the results - just what was searched for. - Nick

Thanks. Working good. RO That sounds like an application specific question. The search string is most likely submitted via form field so you can grab that from the form scope obviously. The ip address can be grabbed from cgi.remote_addr The date/time can come from #now()# The result count comes from your queries recordcount result. Then you just stick it all in a table. Hello, Is there some CF coding that I can employ that will capture a search string when users type a search and later on provide it in a report. At minimum we should capture the dateTime, userIP, search string and number of search results. The data will be stored in an SQL table. Thanks. RO HWW