Title: RE: Problem with QueryHelper Plugin (doQueryAppend and doInnerJoin)
Thread: Problem with QueryHelper Plugin (doQueryAppend and doInnerJoin)
Forum: Bugs
Conference: ColdBox
User: aaronroberson Luis brought it to my attention that doQueryAppend() only appends content and
does not actually join the queries. That explains why the column was not
available.
As for the doInnerJoin, I have tried the following in my action
and it has failed:
[code]
rc.q1 =
queryNew('id,speaker_id,title,content,publish,link');
rc.q2 =
queryNew('id,fname,lname,phone,location');
queryAddRow(rc.q1,1);
querySetCell(rc.q1, 'id', '1');
querySetCell(rc.q1, 'speaker_id', '10');
querySetCell(rc.q1, 'title', 'Beast');
querySetCell(rc.q1, 'content',
'his mark');
querySetCell(rc.q1, 'publish', '1');
querySetCell(rc.q1, 'link', 'linkage');
queryAddRow(rc.q2,1);
querySetCell(rc.q2, 'id', '10');
querySetCell(rc.q2, 'fname', 'john');
querySetCell(rc.q2, 'lname', 'doe');
querySetCell(rc.q2, 'phone',
'954-555-5555');
querySetCell(rc.q2, 'location', 'fresno');
rc.ss =
getPlugin("queryHelper").doInnerJoin(rc.q1, rc.q2, rc.q1.speaker_id,
rc.q2.id);[/code]
Here is the error:
[code]Error Type:
Framework.plugins.queryHelper.InvalidInnerJoinException : [N/A]
Error Messages:
Error in doInnerJoin():
[Table (rows 1 columns id, fname, lname, phone,
location): [id: coldfusion.sql.QueryColumn@1d6bc36] [fname:
coldfusion.sql.QueryColumn@de8c87] [lname: coldfusion.sql.QueryColumn@dc331c]
[phone: coldfusion.sql.QueryColumn@9fb03a] [location:
coldfusion.sql.QueryColumn@1eaeaa0] ] is not indexable by 10[/code]
http://forums.coldboxframework.com/index.cfm?event=ehMessages.dspMessages&threadid=0DC3ECC5-FF65-CEF6-65DD4FCF952FCBFF