Just so I'm clear, are you saying that I need to change my
#aQuery.aColumn[aQuery.currentRow]# formatting within the form? For example, I
need to change this:
<cfoutput query="getSchools">
<option value="#getSchools.SchoolBrief#">#getSchools.SchoolBrief#<br
/></option></cfoutput>
</cfselect>
to this:
<cfloop query="getSchools">
<option
value="#getSchools.SchoolBrief[getSchools.currentRow]#">#getSchools.SchoolBrief[getSchools.currentRow]#<br
/></option></cfloop>
</cfselect>
If so, what is the currentRow value? Just a little confused there.
_______________________________________________
><cfoutput query="aQuery">
><cfoutput query="bQuery">
> ....
></cfoutput>
></cfoutput>
>
>That is illegal because ColdFusion does some automatic variable scoping
>that would just not work in such a situation. To do this you have to
>use the <cfloop query...> form.
>
>I.E.
><cfoutput>
><cfloop query="aQuery">
><cfloop query="bQuery">
> ....
></cfloop>
></cfloop>
></cfoutput>
>
>Just realize with this from CF is not going to automatically scope the
>query column names for you and you will have to keep track of the rows.
>You output will look something like this.
>
>#aQuery.aColumn[aQuery.currentRow]# and #bQuery.bColumn[bQuery.currentRow]#
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331788
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
