|
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Invalid object name Dilemma
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 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
|
Mailing Lists
|
Latest Fusion Authority Articles
|
||||||