Issue #2
Sounds like an escape issue aka the @ sign
sent via droid
On Aug 31, 2010 9:19 PM, "Chris H" <h_chris...@yahoo.com> 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
> -------------------------------------------------------------
