How would one go about passing one database variable to another? Here's my
dilemma;
I have been asked to write a counter that will store the users ID in the
table (in addition to IP/page/browser etc). Once the user is authenticated I
would like to pass the users ID into my counter table. The problem is that
it is not allowing me to do this. I have two separate Data Sources
established 1) Temp (a.k.a counter) 2) login (a.k.a. the permission
validation).
For reference, here is my code:
-counter.cfm-
<cfquery datasource="temp">
Insert into Tracking(
<cfif #CGI.path_translated# is not "">
RequestedFile,
</cfif>
<cfif #CGI.remote_host# is not "">
UserIP,
</cfif>
<cfif #CGI.HTTP_USER_AGENT# is not "">
ClientBrowser,
</cfif>
date_in,time_in,requestid)
Values(
<cfif #CGI.path_translated# is not "">
'#CGI.path_translated#',
</cfif>
<cfif #CGI.remote_host# is not "">
'#CGI.remote_host#',
</cfif>
<cfif #CGI.HTTP_USER_AGENT# is not "">
'#CGI.HTTP_USER_AGENT#',
</cfif>
#date_in#,#time_in#,#requestid#)
</cfquery>
-login.cfm-
<cfquery name="getpermission" datasource="login">
select
permissions
from
thepermissions
where
id ='#requestid#'
</cfquery>
</snip>
Any help would be most appreciative!
TIA,
Dayv
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
