Hello, I was wondering if this is a proper use case for cfthread. This cfthread would be ran via the application file on each page request.
<cfthread name="stats" action="run" priority="LOW" ipaddress = "#cgi.remote_addr#" vcgi = "#CGI#" vsession = "#SESSION#" vurl="#URL#" vform = "#FORM#" vcreatedat="#now()#" > <cfif structKeyExists(vform,"cardnumber")><Cfset structDelete(vform,"CARDNUMBER")></cfif> <cfif structKeyExists(vform,"CARDCODE")><Cfset structDelete(vform,"CARDCODE")></cfif> <cfquery name="insertRandyStats" datasource="Randystats"> insert into stats (createdat,ipaddress,cgi_stats,session_stats,url_stats,form_stats) values( <cfqueryparam cfsqltype="cf_sql_timestamp" value="#vcreatedat#">, <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#ipaddress#">, <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#SerializeJSON(vcgi)#">, <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#SerializeJSON(vsession)#">, <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#SerializeJSON(vurl)#">, <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#SerializeJSON(vform)#">); </cfquery> </cfthread> Is there any issues that might arise from doing the stats line insert like this? Thanks! Randy -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
