What are you setting :menuid to?
It's complaining that you're not passing in a numeric value.
Mark
On Wed, Mar 10, 2010 at 1:45 AM, marc <marc.at.comp...@gmail.com> wrote:
> Ok, that makes sense. So now I have this:
>
> <cfset query=rc.transfer.createQuery("select CMS.page.text from
> CMS.page join menu.menu on CMS.page.id=menu.menu.FK_page where
> menu.menu.id=:menuId")>
>
> and I get
>
> Error Type: Database : n/a
> Error Messages: Invalid data
> [queryData]
> for CFSQLTYPE CF_SQL_FLOAT.
>
> [queryData] is the result of the query - html.
>
> The stack trace 's last line is line 82 of D:\www\wwwroot\SimpleCMS
> \transfer\com\sql\QueryExecution.cfc. So there the error got thrown.
> So the query is execurted succesfully, but an error occurs (in line 82
> in QueryExecution.cfc). Somehow the query's output is mixed with the
> error message.
> I don't use a float type in either of the two tables involved in the
> query, so I don't know what is meant by that.
>
> What could be the problem here?
>
> Marc
>
> On Mar 8, 11:18 pm, Mark Mandel <mark.man...@gmail.com> wrote:
> > <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
>
> --
> 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
