Hi,
I would like to update/insert fields into my database with information that
I'm getting from the initial login via NT authentication.
I would like to insert the following fields into my database.
username
group
enable
disable
Should I be doing an "update" since the table already exists?
<CFQUERY NAME="Insert_Alias" DATASOURCE="user-profiles">
Insert into profiles
(USERNAME, GROUP, ENABLE, DISABLE)
VALUES
('#Username#', '#Group#','#enable#','#disable#')
</CFQUERY>
I have the following in my index.cfm file:
<!--- Start - Run below code at initial page loading --->
<cfoutput>
<cfif SESSION.InitialCodeRun IS 0>
<!--- SESSION.InitialCodeRun: #SESSION.InitialCodeRun# --->
<cfset SESSION.InitialCodeRun = 1>
INSERT DATABASE CODE HERE...
<cfelse>
<!--- SESSION.InitialCodeRun: #SESSION.InitialCodeRun# --->
<b>Code not run...</b>
</cfif>
</cfoutput>
<!--- End - Run below code at initial page loading --->
+-----------------------------------------------------------------------------------+
Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+------------------------------------------------------------------------------------+
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
