Bind Attribute in CheckBox -->Help

[CF_N_Montreal]

Hello Everyone,

I attented a great presentation yesterday by Macromedia Canada.

I need a little help regarding the BIND attribute.
I am doing a query from two seperate tables.
The first query retrieves all the user names.
The second query searches for language for each user depending on the user_id.

Attached Code:

<cfquery name="GetUsers" datasource="DSN1">
SELECT userid, user_name
FROM UsersTable
Order By user_name
</cfquery>

<cfquery name="GetLanguage" datasource="DSN2">
SELECT Language
FROM LanguageTable
Where user_id = GetUsers.userid
</cfquery>

<cfform method="post" action="Action.cfm" format="flash" skin="halosilver"
preserveData="yes">

<cfgrid name="UserGrid" query="GetUsers" rowheaders="no">
<cfgridcolumn name="user_name" header="First Name" dataalign="center">
</cfgrid>

<cfinput type="text" name="firstname" label="Name:"
bind="{UserGrid.dataProvider[UserGrid.selectedIndex]['user_name']}">
<cfinput type="checkbox" name="LangEnglish" bind=""> (If the language is
English then put it to checked = "yes")
<cfinput type="checkbox" name="LangFrench" bind=""> (If the language is
French then put it to checked="yes")


<cfinput type="submit" name="btn" value="Save Data">
</cfform>


Thanks in advance guys.

[SharedDynamics]

Also having a similar problem with checkboxes and cfselect using the html option.

[CF_N_Montreal]

SharedDynamics: Did you find any solutions yet?

[SharedDynamics]

Nothing yet, I found something about how to default your select dropdown box
to the value from a query with the bind attribute. But I can't get that to
work either.

I'm frustrated at myself for spending 7 years on CFML and 0 years on
actionscript.

[drforbin1970]

Here's the answer with 'English' substituted for your grid value:

<cfinput type="text" name="firstname" label="Name:" value="English">
<cfinput type="checkbox" name="LangEnglish"
visible="{(firstname.text=='English') ? (LangEnglish.selected=true,true) :
(LangEnglish.selected=false,true)}">
<cfinput type="checkbox" name="LangFrench"
visible="{(firstname.text=='French') ? (LangFrench.selected=true,true) :
(LangFrench.selected=false,true)}">

Uses the visible value to run the ActionScript.
(LangEnglish.selected=true,true) sets the checkbox to true and then sets the
visible attribute to true so the checkbox does not disappear. Notice both
conditions have the ' ,true' to make sure the checkbox stays visible.

Hope this helps.