Hello,
I have multiple cf servers, one being a developer's version, the two other's
are enterprise versions. I have created something like the following:
<cfquery name="updateUnitID" datasource="#db_database#">
<cfloop from="1" to="#listlen(form.updatedUnitIDs)#" index="x">
<cfset inputUnitID = listgetat(form.updatedUnitIDs, x)>
<cfset inputID = listgetat(form.updatedIDs, x)>
<cfset inputValue = form['#inputID#_#inputUnitID#']>
<cf_customtag email function here>
UPDATE tablename
SET #inputID# = <cfqueryparam value="#inputValue#"
cfsqltype="cf_sql_timestamp" null="#yesnoformat(not isdate(inputValue))#">
WHERE unitid = <cfqueryparam value="#inputUnitID#"
cfsqltype="cf_sql_double" null="#yesnoformat(not
len(inputUnitID))#"> ;
</cfloop>
</cfquery>
Now, I know this looks strange, but the intent is to reduce the amount of loops
as well as reduce the amount of cfquery tags altogether by placing a loop
within a cfquery.
This actually works perfectly on the cf developer's environment, and there are
no extraneous characters created in the cfquery command when testing by
commenting out the cfquery tags, but this does not work on the enterprise
environment. The hang up is the custom tag.
The custom tags on all servers are identical, and the setup of the emails are
identical, given that the enterprise version has more options in the mail
section of the CFIDE/Administrator. The emails send on all servers, but I get
the invalid object name, which the object exists and works fine after taking
out the custom tag out of the equation.
Could this be a bug on the cf enterprise version?
Thanks,
Ryan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303111
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
