<cfset query=rc.transfer.createQuery(
"select text from pages join
menus on pages.id=menus.FK_page where menus.id=:menuId")>
Should be:
<cfset query=rc.transfer.createQuery(
"select *pages.*text from pages join
menus on pages.id=menus.FK_page where menus.id=:menuId")>
You need to qualify the object that the property is coming from.
Mark
On Tue, Mar 9, 2010 at 9:01 AM, marc <marc.at.comp...@gmail.com> wrote:
> Hi I want to retrieve a record via join but keep getting an error
> message
>
> Table 'menus' contains a foreign key FK_page to table 'pages'. I have
> a menuId and want to retrieve the corresponding row in table pages.
>
> This is my transfer config (the relevant part)
>
> <package name="menu">
> <!-- This table contains metadata for menuitems -->
> <object name="menu" table="menus"
> decorator="model.decorators.menuDecorator">
> <id name="id" type="numeric"/>
> <property name="name" type="string"
> column="name"
> nullable="false" />
> <property name="action" type="string"
> column="action"
> nullable="true" />
> <property name="active" type="boolean"
> column="active"
> nullable="false" />
> <property name="lft" type="numeric"
> column="lft" nullable="false" /
> >
> <property name="rght" type="numeric"
> column="rght"
> nullable="false" />
> <property name="FK_page" type="numeric"
> column="FK_page"
> nullable="false" />
> <!-- Link between a menu and it's page-->
> <manytoone name="pages">
> <link to="CMS.page" column="FK_page"
> />
> </manytoone>
> <!-- Link between a menu and it's text-->
> <onetomany name="menutexts">
> <link to="menu.menuTexts"
> column="FK_menuid"/>
> <collection type="array">
> <order property="id"
> order="asc"/>
> </collection>
> </onetomany>
> </object>
>
> [...]
> <package name="CMS">
> <object name="page" table="pages">
> <id name="id" type="numeric"/>
> <property name="title" type="string"
> column="title"
> nullable="false" />
> <property name="text" type="string"
> column="text"
> nullable="false" />
> <property name="contentInfo" type="string"
> column="contentInfo"
> nullable="true" />
> <property name="dateFrom" type="date"
> column="dateFrom"
> nullable="true" />
> <property name="showDateFrom" type="boolean"
> column="showdateFrom" />
> <property name="dateTo" type="date"
> column="dateTo"
> nullable="true" />
> <property name="showDateTo" type="boolean"
> column="showDateTo" />
> <manytoone name="status">
> <link to="CMS.status"
> column="FK_status"/>
> </manytoone>
> <manytoone name="group">
> <link to="CMS.group"
> column="FK_group"/>
> </manytoone>
> <manytoone name="language">
> <link to="Language.language"
> column="FK_language"/>
> </manytoone>
> </object>
> [..]
>
> This is my CF code
>
> <cfset query=rc.transfer.createQuery("select text from pages join
> menus on pages.id=menus.FK_page where menus.id=:menuId")>
> <cfset query.setParam("menuId","#rc.menuid#","numeric")>
> <cfset rc.pageContent=rc.transfer.readByQuery("CMS.page",query)>
>
> This is the result I get
>
> Error Type: Expression : [N/A]
> Error Messages: The 2 parameter of the Left function, which is now -1,
> must be a positive integer
>
> A simpe cfquery
>
> <cfquery name="pageContent" datasource="eenschoolintogo">
> select text from pages join menus on pages.id=menus.FK_page where
> menus.id=#rc.menuId#
> </cfquery>
>
> Gives me exactly what I want.
>
> How can I use transfer to do what I want here??
>
> Thanks,
>
> Marc
>
> --
> Before posting questions to the group please read:
>
> http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
>
> Try out the new Transfer ORM Custom Google Search:
> http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8
>
> You received this message because you are subscribed to the Google Groups
> "transfer-dev" group.
> To post to this group, send email to transfer-dev@googlegroups.com
> To unsubscribe from this group, send email to
> transfer-dev+unsubscr...@googlegroups.com<transfer-dev%2bunsubscr...@googlegroups.com>
> For more options, visit this group at
> http://groups.google.com/group/transfer-dev?hl=en
>
--
E: mark.man...@gmail.com
T: http://www.twitter.com/neurotic
W: www.compoundtheory.com
Hands-on ColdFusion ORM Training @ cf.Objective() 2010
www.ColdFusionOrmTraining.com/
--
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
Try out the new Transfer ORM Custom Google Search:
http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to
transfer-dev+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
