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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
-- --
