[CFCDev] cftransaction Bug in CFC

[Sana Ullah]

Hi Guys

I am facing an error [ the datasource name ....   verification failed ] in a cfc

<cfset transaction_action = "COMMIT">
           <cftransaction action="">
           <cftry> --->
               <cfquery name="insertcredit" datasource="#variables.search_localB4U#">
               INSERT INTO creditcards
               (c_name, c_address, comments)
               VALUES
               ( <cfqueryparam cfsqltype="cf_sql_varchar" value="#memento.NameOnCard#" />,
                 <cfqueryparam cfsqltype="cf_sql_varchar" value="#memento.address#" />,
                 <cfqueryparam cfsqltype="cf_sql_varchar" value="Buy Search Credits" />
               )
               </cfquery>
               <!--- update credit limit for searching of DB's --->
               <cfquery name="updateCreditLimit" datasource="#variables.text_dsn#">
                   UPDATE ABC
                   SET BN= #creditLimit#,
                       role_id  = 7                    WHERE MAIN_ID = #UserID#
               </cfquery>
                         <!--- <cfcatch type="DATABASE">
               <cfset transaction_action = "ROLLBACK">
               <cfset Tran_Success = "false" />
           </cfcatch>
           </cftry>
               <cftransaction action=""/>
           </cftransaction>

WITHOUT CFTRANSACTION ABOVE CODE WORKS FINE

But if there is any cftransaction code then i have error

I think the cftransaction can not work with two different DATABASES

---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]