I would make sure everything is purged and reset (delete all generated
Reactor files, clear template cache in CF admin, delete all FB parsed files,
and perform a full reload/reparse of the FB app including a full reload of
ColdSpring.
On 10/23/07, David Phipps <[EMAIL PROTECTED]> wrote:
>
> Further to my email below I have discovered something even more strange. I
> have pulled as much of the call to the Order Contents gateway out into a
> display fuse (fb) . It throws the same error but at the bottom of the
> queries that have been run is the following query:
>
> qGet (Datasource=spharm, Time=13ms, Records=3) in
> /Applications/ColdFusion8/wwwroot/reactor/base/abstractGateway.cfc @
> 17:23:17.017
>
> DELETE FROM
> `ordercontents`
> WHERE `orderid` = ?
>
> Query Parameter Value(s) -
> Parameter #1(cf_sql_integer) = 16315
>
> So why is Reactor delete the ordercontents? I have a deleteOrder method
> as
> follows:
>
> <cffunction name="deleteOrder" access="public" returntype="void">
> <cfargument name="orderid" type="numeric" required="false"
> default="0" />
> <cfset var orderRecord = getOrderByID(orderid=
> arguments.orderid) />
> <cfset orderRecord.delete() />
> <cfset getOrderContentsGateway().deleteByFields(orderid=
> arguments.orderid)
> />
> <cfset getOrderPaymentsGateway().deleteByFields(orderid=
> arguments.orderid)
> />
> <cfset getOrderPatientsGateway().deleteByFields(orderid=
> arguments.orderid)
> />
> <cfset getOrderHistoryGateway().deleteByFields(orderid=
> arguments.orderid)
> />
> </cffunction>
>
> but this is only called by my remoteOrderFacade cfc which is only called
> on
> a different page from the above.
>
> This is the method in my OrderService cfc that I am calling:
>
> <cffunction name="getOContents" access="public" returntype="query"
> output="false">
> <cfargument name="orderid" type="numeric" required="false"
> default="0" />
> <cfreturn getOrderContentsGateway().getByFields(orderid=
> arguments.orderid)
> />
> </cffunction>
>
> I am passing the orderid via the url.
>
> Curiouser and curiouser...
>
> Cheers,
>
> Dave
>
> So why is reactor deleting the order contents when all I am calling is a
> getByFields method in the ordercontentsgateway? I have cleared the
> application scope and tried it several times (I even restarted cf).
>
> On Tue, 23 Oct 2007 16:03:36 +0000
> "David Phipps" <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I am running into a strange error with one of my (reactor) gateways.
> >I am trying to call a getByFields method for records matching the
> >passed in orderid but all it returns is an error:
> >
> > Variable QGET is undefined.
> >
> > The error occurred in
> >/Applications/ColdFusion8/wwwroot/reactor/base/abstractGateway.cfc:
> >line 99
> > Called from
>
> >/Applications/ColdFusion8/wwwroot/reactor/project/pharmacy/Gateway/ordercontentsGateway.cfc:
> >line 61
> > Called from
> >/Applications/ColdFusion8/wwwroot/pharmacy/com/OrderService.cfc: line
> >31
> > ...
> > 97 : <cfset setLastExecutedQuery(queryData) />
> > 98 :
> > 99 : <cfreturn qGet />
> > 100 : </cffunction>
> > 101 :
> >
> > The code that I am using (fusebox + coldspring):
> >
> > <invoke object="application.serviceFactory.getBean('OrderService')"
> > methodcall="getOrderContents(orderid=
> attributes.orderid)"
> > returnvariable="qOrderContents" />
> > which is calling this method in my OrderService cfc:
> >
> > <cffunction name="getOrderContents" access="public"
> >returntype="query" output="false">
> > <cfargument name="orderid" type="numeric" required="false"
> >default="0" />
> > <cfreturn
> >getOrderContentsGateway().getByFields(orderid=arguments.orderid) />
> > </cffunction>
> >
> > and from my coldspring config:
> >
> > <bean id="OrderService" class="pharmacy.com.OrderService">
> > <property name="reactorFactory">
> > <ref bean="reactorFactory" />
> > </property>
> > <property name="orderGateway">
> > <ref bean="orderGateway" />
> > </property>
> > <property name="ordercontentsGateway">
> > <ref bean="ordercontentsGateway" />
> > </property>
> > <property name="orderpaymentsGateway">
> > <ref bean="orderpaymentsGateway" />
> > </property>
> > <property name="orderpatientsGateway">
> > <ref bean="orderpatientsGateway" />
> > </property>
> > <property name="orderhistoryGateway">
> > <ref bean="orderhistoryGateway" />
> > </property>
> > <property name="MailService">
> > <ref bean="MailService" />
> > </property>
> > <property name="sessionFacade">
> > <ref bean="sessionFacade" />
> > </property>
> > </bean>
> >
> > <bean id="ordercontentsGateway" factory-bean="reactorFactory"
> >factory-method="createGateway">
> > <constructor-arg name="objectAlias">
> > <value>ordercontents</value>
> > </constructor-arg>
> > </bean> ...
> >
> > and finally my reactor config:
> >
> > <object name="orders">
> > <hasOne name="customer">
> > <relate to="customerid" from="customerid"
> />
> > </hasOne>
> > <hasMany name="ordercontents">
> > <relate to="orderid" from="orderid"/>
> > </hasMany>
> > <hasMany name="orderpayments">
> > <relate to="orderid" from="orderid"/>
> > </hasMany>
> > <hasMany name="orderpatients">
> > <relate to="orderid" from="orderid"/>
> > </hasMany>
> > <hasMany name="orderhistory">
> > <relate to="orderid" from="orderid"/>
> > </hasMany>
> > </object>
> > <object name="ordercontents">
> > <hasOne name="orders">
> > <relate to="orderid" from="orderid"/>
> > </hasOne>
> > <hasOne name="product">
> > <relate from="productid" to="productid" />
> > </hasOne>
> > </object>
> >
> > I can't for the life of me work out why it is throwing an error like
> >this and I can't seem to figure out how to fix it.
> >
> > Anyone seen this error before or know how to fix - probably
> >something I have done wrong rather than a bug.
> >
> > Cheers,
> >
> > Dave
> >
> > _______________________________________________________________________
> > David Phipps
> > Director, Chapel Studios
> >
> > T +44 (0)20 7100 6980 F +44 (0)20 7100 6981 M +44 (0)7765 240899
> > New Broad Street House, 35 New Broad Street, London, EC2M 1NH, UK
> >
> > http://www.chapel-studios.co.uk
> > _______________________________________________________________________
> >
> > The Chapel Studios group of companies are registered in England.
> > 'Chapel Studios' and the Chapel Studios logo are registered
> >trademarks of Chapel Studios. The information in this email is
> >confidential, intended solely for the addressee, and may be legally
> >privileged. If you are not the addressee or authorized to receive
> >this for the addressee, you must not use, copy, disclose or take any
> >action based upon this message or any information herein. If you
> >have received this message in error, please advise the sender
> >immediately by reply e-mail.
> >
> >
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> >-- -- -- --
> > Reactor for ColdFusion Mailing List
> > [EMAIL PROTECTED]
> > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> >-- -- -- --
> >
>
>
> _______________________________________________________________________
> David Phipps
> Director, Chapel Studios
>
> T +44 (0)20 7100 6980 F +44 (0)20 7100 6981 M +44 (0)7765 240899
> New Broad Street House, 35 New Broad Street, London, EC2M 1NH, UK
>
> http://www.chapel-studios.co.uk
> _______________________________________________________________________
>
> The Chapel Studios group of companies are registered in England. 'Chapel
> Studios' and the Chapel Studios logo are registered trademarks of Chapel
> Studios. The information in this email is confidential, intended solely
> for
> the addressee, and may be legally privileged. If you are not the
> addressee
> or authorized to receive this for the addressee, you must not use, copy,
> disclose or take any action based upon this message or any information
> herein. If you have received this message in error, please advise the
> sender immediately by reply e-mail.
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
> Reactor for ColdFusion Mailing List
> [EMAIL PROTECTED]
> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
>
>
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
