Title: RE: Problem with QueryHelper Plugin (doQueryAppend and doInnerJoin)
Thread: Problem with QueryHelper Plugin (doQueryAppend and doInnerJoin)
Forum: Bugs
Conference: ColdBox
User: sanaullah73 Hi Aaron,
You are missing column name, innerJoin takes column to match the
records.
Here is bit more funny example,
q1 have 1 record.
q2 have 2
record.
Still you will have results based on provided column name.
[code]
<cfscript>
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.q1,1);
querySetCell(rc.q1, 'id', '2');
querySetCell(rc.q1, 'speaker_id', '20');
querySetCell(rc.q1, 'title',
'BeastA');
querySetCell(rc.q1, 'content', 'his markA');
querySetCell(rc.q1,
'publish', '1A');
querySetCell(rc.q1, 'link', 'linkageA');
queryAddRow(rc.q2,1);
querySetCell(rc.q2, 'id', '20');
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, "speaker_id", "id");
</cfscript>
[/code]
Please update queryPlugin from SVN , As we have
updated this in v2.6
If there any problem please let me know.
many
thanks
Sana
http://forums.coldboxframework.com/index.cfm?event=ehMessages.dspMessages&threadid=0DC3ECC5-FF65-CEF6-65DD4FCF952FCBFF