All pastes #266619 Raw Edit

Miscellany

public text v1 · immutable
·published 2006-12-04 07:54 UTC
rendered paste body
<cfoutput query="qryGroups">
<cfif ListFind(attributes.EmployeeGroupsList,qryGroups.GroupID,',')>
INSERT INTO tblUserGroups(UserID,GroupID,EnteredbyIP,EnteredByUser,DateEntered)
VALUES	(<cfqueryparam value="#attributes.UserID#" cfsqltype="cf_sql_integer">,
	 <cfqueryparam value="#qryGroups.GroupID#" cfsqltype="cf_sql_integer">,
	 <cfqueryparam value="#CGI.REMOTE_ADDR#" cfsqltype="cf_sql_varchar">,
	 <cfqueryparam value="#variables.UserID#" cfsqltype="cf_sql_integer">,
	 #CreateODBCDateTime(Now())#
	);
</cfif> 
</cfoutput>