Thanks for your responses. I am sorry I did not do a very good job of
explaining my question. I saved this code(see below) from a few months back
because I knew I would need to do something like this but I could not get it
to work. I am sure it is something simple but I can not figure it out and
have not found a reference that explained it. I assumed the
datasource="#ActiveDSN#" would be the datasource to my SQL7 table using
cf4.5 on an NT workstation but it did not work so I tried to use it exactly
as it is written and that did not work. I am trying to find a reference to
explain how to do this, can you help?
>From Angelo McComas on 12/9/99 to another person on the list:
When you authenticate a user, their user name will show up in the cgi scope
variable "auth_user" -- you can pass that to the database like so:
// <cfquery name="theQuery" datasource="#ActiveDSN#"
username="#cgi.auth_user#">
//
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
