Query group in cfformgroup

Question

Hi,

I can't figure out hvor to group output from a query like you can in the cfoutput tag with the group option.
<cfscript>
q1 = queryNew("id,firstname,lastname");
queryAddRow(q1);
querySetCell(q1, "id", "1");
querySetCell(q1, "firstname", "Rob");
querySetCell(q1, "lastname", "Smith");
queryAddRow(q1);
querySetCell(q1, "id", "2");
querySetCell(q1, "firstname", "John");
querySetCell(q1, "lastname", "Doe");
queryAddRow(q1);
querySetCell(q1, "id", "3");
querySetCell(q1, "firstname", "Jane");
querySetCell(q1, "lastname", "Doe");
queryAddRow(q1);
querySetCell(q1, "id", "4");
querySetCell(q1, "firstname", "Erik");
querySetCell(q1, "lastname", "Pramenter");
queryAddRow(q1);
querySetCell(q1, "id", "4");
querySetCell(q1, "firstname", "Jane");
querySetCell(q1, "lastname", "Jiggy");
queryAddRow(q1);
querySetCell(q1, "id", "4");
querySetCell(q1, "firstname", "Jane");
querySetCell(q1, "lastname", "Bush");
</cfscript>

From the above I would like to populate a tabnavigator using the id and each page populated with firstname and lastname inputfields.

Can anyone please help?

RuneV · Answer

Hi ScareCrow,I just made a slight modification to your code by moving thecfoutput inside the inner most cfformgroup like this;and it works like charm, thank you!I did fiddle around with a cfoutput inside the form before Ihad to give up and post my question here. After your post Irealized that the name of my query "q1" was probably the reason Icouldn't get my output loop to work, as "q1" and "ql" looks verysimilar. Lesson learned, I have now changed my query name to "qq"./Rune

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded