Please see this:
Original values for form fields have Original string append this names...
intQtyContentOriginal,strNameFirmsOriginal,EmailUserOriginal
<!---audit--->
<!---form fields - can be change for users --->
<cfset auditList = "intQtyContent,strNameFirms,EmailUser">
<cfloop index="fieldName" list="#auditList#">
<!---set up Original form field--->
<CFSET formfield=fieldName & "Original">
<cfif Len(Trim(evaluate("form.#fieldName#"))) NEQ 0 AND (evaluate("form.#fieldName#") NEQ evaluate("#formfield#"))>
<cfquery name = "WriteAudit"
datasource = "#dsn#">
insert into tblAudit
(strSiteID
,strUserID
,intAreaSite
,strTableName
,strFieldName
,strValueOld
,strValueNew
,dtDateChange)
values
(<cfqueryparam value="#Session.Auth.strSiteID#" CFSQLType="CF_SQL_VARCHAR" maxlength="35">
,<cfqueryparam value="#Session.Auth.UserID#" CFSQLType="CF_SQL_VARCHAR" maxlength="35">
,1
,'tblSite'
,<cfqueryparam value="#fieldName#" CFSQLType="CF_SQL_VARCHAR" maxlength="100">
,<cfqueryparam value='#evaluate("#formfield#")#' CFSQLType="CF_SQL_VARCHAR" maxlength="255">
,<cfqueryparam value='#evaluate("form.#fieldName#")#' CFSQLType="CF_SQL_VARCHAR" maxlength="255">
,<cfqueryparam value="#Now()#"
cfsqltype="cf_sql_timestamp">)
</cfquery>
</cfif>
</cfloop>
<!---end audit--->
Works fine for only 1 form. But i'm looking for a solution (Custom Tag, cfscript) for any form passing parameters like form fields(names and content) and original form fields(names and content. too). Array maybe works. Or structure?
----- Original Message -----
From: Jochem van Dieten <[EMAIL PROTECTED]>
Date: Sun, 04 Jan 2004 06:25:43 -0400
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Re: Adding remote datasource dynamically
Chunshen (Don) Li wrote:
> Oops, Java was not a friend of mine :)
> Same result same err msg after using javaCast string function.
I just got an email from Rafael Quinones confirming that JavaCast() should work:
<cfset DBpassword="mypassword">
<cfscript>
factory = CreateObject("java", "coldfusion.server.ServiceFactory");
ds_service = factory.datasourceservice;
dsources = ds_service.datasources;
</cfscript>
<cfset encryptedDBpassword = #ds_service.encryptPassword(JavaCast("String", "#DBpassword#"))#>
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
