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
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
