Chris- You might want to try the ColdFusion User Group's email list for your ColdFusion centric questions. I know your app is both CF and Flex, but you are likely to get more elaborate CF help there...
http://www.acfug.org/ -Cameron On Wed, Sep 1, 2010 at 8:56 PM, Chris H <[email protected]> wrote: > Eric, > > Thanks for the response. > > It was not a escaping issue, but something else which I could not trace. I > replaced the source with an earlier version and it worked fine, but now the > cfmail tag is failing. Yesterday, there was no status message or a wrong > status message, but the cfmail tag was working fine. Today, the cfmail tag > is failing. > > I wish I could fix such problems quicker. > > Thanks for your suggestions and time. > > ________________________________ > From: Eric DeCoff <[email protected]> > To: [email protected] > Sent: Tue, August 31, 2010 9:25:47 PM > Subject: Re: [AFFUG Discuss] newbie question: How do I do a runtime debug of > a Coldfusion component file > > Issue #2 > > http://www.adobe.com/support/coldfusion/getting_started/using_poundsigns_quotat/using_poundsigns_quotat04.html > > sent via droid > > On Aug 31, 2010 9:23 PM, "Eric DeCoff" <[email protected]> wrote: >> Issue #2 >> >> Sounds like an escape issue aka the @ sign >> >> sent via droid >> >> On Aug 31, 2010 9:19 PM, "Chris H" <[email protected]> wrote: >>> My application has a Coldfusion component(cfc), CFM file and a lot of >>> Flex >> >>> source files. >>> >>> I tried using <cftry>, <cfcatch>, <cfdump> to find the errors in the cfc, >> but >>> still cannot trace the issue. >>> >>> The code in CFC file is somewhat like >>> >>> <cfcomponent> >>> >>> <cffunction name="edit" access="remote" returntype="any"> >>> <cfargument name="form_data" type="struct"> >>> <cftry> >>> <cftransaction> >>> >>> <!--- Update Record ---> >>> <cfquery datasource="#Application.ds#"> >>> some SQL here >>> </cfquery> >>> >>> <!--- Remove all previous outcomes ---> >>> <cfquery datasource="#Application.ds#"> >>> some SQL here >>> </cfquery> >>> >>> <!--- Log Update ---> >>> >>> <cfquery datasource="#Application.ds#"> >>> some SQL here >>> </cfquery> >>> >>> <!--- Get Last Logged Record ---> >>> <cfquery datasource="#Application.ds#" name="getLogLastRecord"> >>> some SQL here >>> </cfquery> >>> >>> >>> >>> <cfloop index="arr_index" from="1" >>> to="#ArrayLen(form_data.num)#"> >>> >>> <!--- Update Record ---> >>> <cfquery datasource="#Application.ds#" > >>> some SQL here >>> </cfquery> >>> >>> <!--- Log Update ---> >>> <cfquery datasource="#Application.ds#" > >>> some SQL here >>> </cfquery> >>> </cfloop> >>> >>> >>> </cftransaction> >>> >>> <cfset result['statMsg']= "The record was saved successfully!"> >>> <cfset result['status']= true> >>> >>> >>> >>> <cfcatch><!--- Catch error ---> >>> <cfsavecontent variable="contentSaver"> >>> <cfdump var="#form_data#"> >>> <cfdump var="#cfcatch#"> >>> </cfsavecontent> >>> >>> <cffile action="write" file="#ExpandPath('.')#\debug.html" >>> output="#contentSaver#"> >>> >>> <cfset result['statMsg'] = cfcatch.Message> >>> <cfset result['status']= false> >>> </cfcatch> >>> </cftry> >>> >>> <cfreturn result> >>> </cffunction> >>> </cfcomponent> >>> >>> Issue: 1 My understanding is if the transaction is successful I should >>> get >> the >>> message "The record was saved successfully!" which I don't get, though >>> the >> >>> transaction is successful as the data is saved in the MySQL backend. >>> >>> Even if the transaction failed, I should get a message due to the catch >> block. >>> >>> What could be the reason I am not getting the message? The users of the >>> application need to get this so that they know that the changes they did >> are >>> saved. >>> >>> Issue 2: For another transaction, I get the below message at run time. >>> >>> "You have an error in your SQL syntax; check the manual that corresponds >> to >>> your MySQL server version for the right syntax to use near '@domain.com' >> at line >>> 3" >>> >>> The transaction goes through fine and changes are saved to the back end >> database >>> which means nothing should be wrong in my SQL syntax. >>> I don't see anything wrong on line 3 of the cfc file, nor the third line >> of >>> the SQL statement has anything missing. Then, why am I getting that >> message? >>> >>> Why am I not getting a transaction success message(The record was saved >>> successfully) when I should for Issue 1 when the transaction is >>> successful >> and >>> why am I getting a strange error message for Issue 2 though the >> transaction is >>> successful instead of a transaction success message? >>> >>> Can I do a run time debugging of the CFC using Coldfusion Builder as I >>> can >> for >>> Flex source files using the Flexbuilder? >>> >>> Any advice would be welcome. >>> >>> >>> >>> >>> >>> ------------------------------------------------------------- >>> To unsubscribe from this list, simply email the list with unsubscribe in >> the subject line >>> >>> For more info, see http://www.affug.com >>> Archive @ http://www.mail-archive.com/discussion%40affug.com/ >>> List hosted by http://www.fusionlink.com >>> ------------------------------------------------------------- > > > ------------------------------------------------------------- > To unsubscribe from this list, simply email the list with unsubscribe in the > subject line > > For more info, see http://www.affug.com > Archive @ http://www.mail-archive.com/discussion%40affug.com/ > List hosted by FusionLink > ------------------------------------------------------------- -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [email protected] ------------------------------------------------------------- To unsubscribe from this list, simply email the list with unsubscribe in the subject line For more info, see http://www.affug.com Archive @ http://www.mail-archive.com/discussion%40affug.com/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
