ColdBox Framework Forums Notification: Post to Problem with QueryHelper Plugin (doQueryAppend and doInnerJoin)

Title: Problem with QueryHelper Plugin (doQueryAppend and doInnerJoin)
Thread: Problem with QueryHelper Plugin (doQueryAppend and doInnerJoin)
Forum: Bugs
Conference: ColdBox
User: aaronroberson Hello,

I have the following in my action:

[code]rc.sermons =
service.getSermons(publish=1);
rc.speakers =
speakerService.getSpeakers(publish=1);
rc.ss =
getPlugin("queryHelper").doQueryAppend(rc.speakers,rc.sermons);[/code]

Then I
have the following in my view:

[code]<cfoutput query="rc.ss">#rc.ss.title#
#rc.ss.lastname#</cfoutput>[/code]

rc.ss.lastname is a column in the second
query named rc.speakers. I get an error stating that the element ss.lastname is
undefined in the rc.

Also, I get a wild error when I try doInnerJoin(). Here
is my action code:

[code]rc.sermons = service.getSermons(publish=1) ;
rc.speakers = speakerService.getSpeakers(publish=1);
rc.ss =
getPlugin("queryHelper").doInnerJoin(rc.sermons, rc.speakers,
rc.sermons.speaker_id, rc.speakers.id);[/code]

Here is the error message:
[code]Error Type: Framework.plugins.queryHelper.InvalidInnerJoinException :
[N/A]
Error Messages: Error in doInnerJoin():

[Table (rows 18 columns ID,
SALUTATION, FIRSTNAME, LASTNAME, CONTENT, PUBLISH): [ID:
coldfusion.sql.QueryColumn@50559d] [SALUTATION:
coldfusion.sql.QueryColumn@24d039] [FIRSTNAME:
coldfusion.sql.QueryColumn@e26afa] [LASTNAME: coldfusion.sql.QueryColumn@dd8116]
[CONTENT: coldfusion.sql.QueryColumn@45f8ee] [PUBLISH:
coldfusion.sql.QueryColumn@1d9ed18] ] is not indexable by 1 [/code]

I have
download the nightbuild and replaced the plugin directory andn reinitialized my
application but to no avail.
http://forums.coldboxframework.com/index.cfm?event=ehMessages.dspMessages&threadid=0DC3ECC5-FF65-CEF6-65DD4FCF952FCBFF