I fixed the problem. I had the <cfinvoke between <cftransaction> There was
a sql error that was not showing up.
----- Original Message -----
From: "David Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Tuesday, August 23, 2005 10:42 AM
Subject: Help!!! I must be missing something.
>I am running CF 7 mx hotfix 3. We are using a flash form with a cfgrid on
>it. After submit goes to the "action page" where I call a cfc that is
>stored in the server scope.
>
> The cfc runs fine without any errors. But it does not update the database
> or insert new data. The datasource is right and the tables exists. If I
> copy the sql statments below and use enterprise manager they work fine.
> But cf does not update/insert the database.
>
> Any suggestions?
>
> Here is the cfc code:
> <cffunction name="UpdateGridData" access="public" returntype="any"
> displayname="Inserts/Update/Delete data into a table from cfgrid (insert
> only not update)" hint="This will insert/update/delete data from a from
> cfgrid; pass it ColumnNameList,GridName, DSN and TableName" output="true">
> <cfargument name="TableName" type="string" required="true">
> <cfargument name="DSN" type="string" required="true">
> <cfargument name="ColumnNameList" type="string" required="true">
> <cfargument name="GridName" type="string" required="true">
> <cfargument name="PKColumnName" required="no" type="string" default="">
>
> <cfset var Counter = 0>
> <cfset var Counter2 = 0>
> <cfset var Size= 0>
> <cfset var InsertTemp = 1>
> <cfset var DeleteData = "">
> <cfset var InsertData = "">
> <cfset var UpdateData = "">
> <cfset var ColumnName = "">
>
> <cfset Size = ArrayLen(form[Arguments.GridName & ".rowstatus.action"])>
> <cfloop index="Counter" from="1" to="#Size#">
> <cfset Counter2= 0>
> <cfif form[Arguments.GridName & ".rowStatus.Action"][counter] EQ "D">
> <cfquery name="DeleteData" datasource="#Arguments.DSN#">
> DELETE
> FROM #Arguments.TableName#
> WHERE #Arguments.PKColumnName# = #form[Arguments.GridName &
> ".original." & Arguments.PKColumnName][counter]#
> </cfquery>
> <cfelseIf form[arguments.GridName & ".rowStatus.Action"][counter] EQ
> "U">
> <cfquery name="UpdateData" datasource="#Arguments.DSN#">
> update #Arguments.TableName#
> set <cfloop index="ColumnName"
> list="#Arguments.ColumnNameList#"><cfset Counter2 = Counter2 +
> 1>#ColumnName#='#form[Arguments.GridName & "." &
> ColumnName][Counter]#'<cfif Counter2 LT
> ListLen(Arguments.ColumnNameList)>, </cfif></cfloop>
> where #Arguments.PKColumnName#=#form[Arguments.GridName &
> ".original."& Arguments.PKColumnName][counter]#
> </cfquery>
> <cfelseIf form[arguments.GridName & ".rowStatus.Action"][counter] EQ
> "I">
> <cfquery name="InsertData" datasource="#Arguments.DSN#">
> Insert Into #Arguments.TableName#
> (#Arguments.ColumnNameList#)
> Values
> (<cfloop index="ColumnName" list="#Arguments.ColumnNameList#"><cfset
> Counter2 = Counter2 + 1>'#form[Arguments.GridName & "." &
> ColumnName][Counter]#'<cfif Counter2 LT
> ListLen(Arguments.ColumnNameList)>, </cfif></cfloop>)
> </cfquery>
> </cfif>
> </cfloop>
> <cfreturn InsertTemp>
> </cffunction>
>
> Using debug turned on i see the following returned back to me.
>
> Total Time Avg Time Count Template
> 47 ms 47 ms 1 I:\Inetpub\wwwroot\PHAnet\it\Application.cfm
> 32 ms 32 ms 1 I:\Inetpub\wwwroot\PHAnet\it\qcc\EditForm_Action.cfm
> 16 ms 16 ms 1 CFC[ I:\Inetpub\wwwroot\MyComs\sqlDataBase.cfc |
> UpdateGridData(DSN = pqc, ColumnNameList =
> DetailPlanDate,DetailPlanTime,DetailPlanTask,DetailPlanPerson,
> PKColumnName = DetailPlanID, GridName = DetailPlanGrid, TableName =
> tbl_DetailPlan) ] from I:\Inetpub\wwwroot\MyComs\sqlDataBase.cfc
>
>
>
>
>
>
> red = over 250 ms average execution time
>
>
> --------------------------------------------------------------------------------
> SQL Queries
>
> InsertData (Datasource=pqc, Time=0ms, Records=0) in
> I:\Inetpub\wwwroot\MyComs\sqlDataBase.cfc @ 10:33:20.020 Insert Into
> tbl_DetailPlan
> (DetailPlanDate,DetailPlanTime,DetailPlanTask,DetailPlanPerson)
> Values
> ('06/30/05', '12:00', 'test 2', 'david')
> UpdateData (Datasource=pqc, Time=0ms, Records=0) in
> I:\Inetpub\wwwroot\MyComs\sqlDataBase.cfc @ 10:33:20.020
>
> update tbl_DetailPlan
> set DetailPlanDate='06/25/05', DetailPlanTime='12:00',
> DetailPlanTask='This is the first task that we need to work on',
> DetailPlanPerson='Ed Welch'
> where DetailPlanID=108
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216067
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
