House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home /  Groups /  ColdFusion Talk (CF-Talk)

Invalid object name Dilemma

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
Hello,
Ryan Hinton
04/10/08 12:32 P
Hello,
Ryan Hinton
04/10/08 12:36 P
Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Ryan Hinton
04/10/2008 12:32 PM

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

Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Ryan Hinton
04/10/2008 12:36 PM

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


<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

May 24, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
     1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31     

Designer, Developer and mobile workflow conference