Doh! Late late night! Thanks guys:)
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 11, 2003 10:33 PM Subject: RE: Strange CFC problem > attributes.WaterChange or arguments.WaterChange???? > > Doug > > >-----Original Message----- > >From: Frank Mamone [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, March 11, 2003 10:29 PM > >To: CF-Talk > >Subject: Strange CFC problem > > > > > >I'm using CFINVOKE to call a CFC and I get an error saying that certain > >arguments are undefined when in fact they are. The error is: > > > >"Element WATERCHANGE is undefined in ATTRIBUTES" > > > > > ><cfcomponent> > > <cfset DATASOURCENAME = "#request.dsn#" /> > > > > > > <cffunction name="addLog" access="remote" returntype="struct"> > > <cfargument name="PH" type="string" required="true"> > > <cfargument name="KH" type="string" required="true"> > > <cfargument name="GH" type="string" required="true"> > > <cfargument name="CO2" type="string" required="true"> > > <cfargument name="Ammonia" type="string" required="true"> > > <cfargument name="Nitrite" type="string" required="true"> > > <cfargument name="Nitrate" type="string" required="true"> > > <cfargument name="WComments" type="string" required="true"> > > <cfargument name="WaterChange" type="string" required="true"> > > <cfargument name="WCComments" type="string" required="true"> > > <cfargument name="FilterMediaChange" type="string" required="true"> > > <cfargument name="FMCComments" type="string" required="true"> > > <cfargument name="CO2Refill" type="string" required="true"> > > <cfargument name="CO2Comments" type="string" required="true"> > > <cfargument name="TANKS_ID" type="string" required="true"> > > > > > > > > <!--- Create new Transaction ---> > > <CFQUERY datasource="#DATASOURCENAME#" name="trans"> > > INSERT INTO AL_TRANS > > (TransDate ,TANKS_ID) > > VALUES > > (#Now()#, #TANKS_ID#) > > </CFQUERY> > > > > <!--- GET MAX ID ---> > > > > <CFQUERY datasource="#DATASOURCENAME#" name="getTrans"> > > SELECT max(ID) AS TransID > > FROM AL_TRANS > > </CFQUERY> > > > > <!--- INSERT WATER PARAMETERS ---> > > > > <cfquery datasource="#DATASOURCENAME#" name="insValues"> > > INSERT INTO AL_WATER > > (PH,KH,GH,CO2,Ammonia,Nitrite,Nitrate,WComments,TRANS_ID) > > VALUES > > (#arguments.PH#, > > #arguments.KH#, > > #arguments.GH#, > > #arguments.CO2#, > > #arguments.Ammonia#, > > #arguments.Nitrite#, > > #arguments.Nitrate#, > > '#arguments.WComments#', > > #getTrans.TransID# > > ) > > </cfquery> > > > > <!--- INSERT MAINTENANCE VALUES ---> > > <CFQUERY datasource="#DATASOURCENAME#" name="insMaint"> > > INSERT INTO MAINTENANCE > > > >(TRANSID,WaterChange,WCComments,FilterMediaChange,FMCComments,C > >O2Refill,CO2C > >omments) > > VALUES > > (#getTrans.TransID#, > > '#attributes.WaterChange#', > > '#attributes.WCComments#', > > '#attributes.FilterMediaChange#', > > '#attributes.FMCComments#', > > '#attributes.CO2Refill#', > > '#attributes.CO2Comments#' > > </CFQUERY> > > > > <CFSET status = "Success"> > > > > <cfreturn status> > > > > > > </cffunction> > > > ></cfcomponent> > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4