Related Select Boxes - MX7

[ParaRecce]

I have been having quiet some difficulties understanding the binding that has
to be done to bind between one CFSELECT result and the bind to the second and
then the third CFSELECT which needs to be dynamically populated.

Hows is this done? I have removed the binding I had done. Add any other
components that are not required. Please help!

CODE:

<cfquery name="spGetOrg" datasource="#request.dsn#">
SELECT TOP 100 PERCENT
dbo.tblOrganisationalCompanyDetails.intOrganisatio nalCompanyID,
dbo.tblOrganisationalCompanyDetails.nvarOrgCompany Name,
ISNULL(dbo.tblOrganisationalDivisionDetails.intOrg anisationalDivisionID, 0)
AS intOrganisationalDivisionID,
ISNULL(dbo.tblOrganisationalDivisionDetails.nvarOr gDivisionName, '') AS
nvarOrgDivisionName,

ISNULL(dbo.tblOrganisationalDepartmentDetails.intO rganisationalDepartmentID, 0)
AS intOrganisationalDepartmentID,
ISNULL(dbo.tblOrganisationalDepartmentDetails.nvar OrgDepartmentName, '') AS
nvarOrgDepartmentName
FROM dbo.tblOrganisationalDepartmentDetails
RIGHT OUTER JOIN dbo.tblOrganisationalDivisionDetails
ON dbo.tblOrganisationalDepartmentDetails.intOrganisa tionalDivisionID =
dbo.tblOrganisationalDivisionDetails.intOrganisati onalDivisionID
RIGHT OUTER JOIN dbo.tblOrganisationalCompanyDetails
ON dbo.tblOrganisationalDivisionDetails.intOrganisati onalCompanyID =
dbo.tblOrganisationalCompanyDetails.intOrganisatio nalCompanyID
ORDER BY dbo.tblOrganisationalCompanyDetails.nvarOrgCompany Name,
ISNULL(dbo.tblOrganisationalDivisionDetails.nvarOr gDivisionName, ''),
ISNULL(dbo.tblOrganisationalDepartmentDetails.nvar OrgDepartmentName, '')
</cfquery>

<cfform format="flash" action="#cgi.script_name#?#cgi.query_string#"
method="post" skin="halosilver" height="350" width="550">
<cfselect title="Choose a Company"
name="company"
label="Choose a Company"
query="spGetOrg"
value="intOrganisationalCompanyID"
display="nvarOrgCompanyName"
required="yes"
width="210">
</cfselect>
<cfselect title="Choose Division"
name="division"
label="Choose a Division"
query="spGetOrg"
value="intOrganisationalDivisionID"
display="nvarOrgDivisionName"
required="yes"
width="210">
</cfselect>
<cfselect title="Choose Department"
name="department"
label="Choose a Department"
query="spGetOrg"
value="intOrganisationalDepartmentID"
diplay="nvarOrgDepartmentName"
required="yes"
width="210"
enabled="false">
</cfselect>
</cfform

[Mike Nimer]

the cfselect tag doesn't support the bind attribute at all. To do something
like this, sorry I don't have an example to show you, you need to use the
onChange ="" or onClick="" attributes of the 1st cfselect to call the 2nd
cfselect and to add/remove - basically do what you need to do to it.

hth,
---nimer


"ParaRecce" <webforumsuser@macromedia.com> wrote in message
news:cvqq49$66e$1@forums.macromedia.com...

>I have been having quiet some difficulties understanding the binding that
>has
> to be done to bind between one CFSELECT result and the bind to the second
> and
> then the third CFSELECT which needs to be dynamically populated.
>
> Hows is this done? I have removed the binding I had done. Add any other
> components that are not required. Please help!
>
> CODE:
>
> <cfquery name="spGetOrg" datasource="#request.dsn#">
> SELECT TOP 100 PERCENT
> dbo.tblOrganisationalCompanyDetails.intOrganisatio nalCompanyID,
> dbo.tblOrganisationalCompanyDetails.nvarOrgCompany Name,
> ISNULL(dbo.tblOrganisationalDivisionDetails.intOrg anisationalDivisionID,
> 0)
> AS intOrganisationalDivisionID,
> ISNULL(dbo.tblOrganisationalDivisionDetails.nvarOr gDivisionName, '') AS
> nvarOrgDivisionName,
>
> ISNULL(dbo.tblOrganisationalDepartmentDetails.intO rganisationalDepartmentID,
> 0)
> AS intOrganisationalDepartmentID,
> ISNULL(dbo.tblOrganisationalDepartmentDetails.nvar OrgDepartmentName, '')
> AS
> nvarOrgDepartmentName
> FROM dbo.tblOrganisationalDepartmentDetails
> RIGHT OUTER JOIN dbo.tblOrganisationalDivisionDetails
> ON dbo.tblOrganisationalDepartmentDetails.intOrganisa tionalDivisionID =
> dbo.tblOrganisationalDivisionDetails.intOrganisati onalDivisionID
> RIGHT OUTER JOIN dbo.tblOrganisationalCompanyDetails
> ON dbo.tblOrganisationalDivisionDetails.intOrganisati onalCompanyID =
> dbo.tblOrganisationalCompanyDetails.intOrganisatio nalCompanyID
> ORDER BY dbo.tblOrganisationalCompanyDetails.nvarOrgCompany Name,
> ISNULL(dbo.tblOrganisationalDivisionDetails.nvarOr gDivisionName, ''),
> ISNULL(dbo.tblOrganisationalDepartmentDetails.nvar OrgDepartmentName, '')
> </cfquery>
>
> <cfform format="flash" action="#cgi.script_name#?#cgi.query_string#"
> method="post" skin="halosilver" height="350" width="550">
> <cfselect title="Choose a Company"
> name="company"
> label="Choose a Company"
> query="spGetOrg"
> value="intOrganisationalCompanyID"
> display="nvarOrgCompanyName"
> required="yes"
> width="210">
> </cfselect>
> <cfselect title="Choose Division"
> name="division"
> label="Choose a Division"
> query="spGetOrg"
> value="intOrganisationalDivisionID"
> display="nvarOrgDivisionName"
> required="yes"
> width="210">
> </cfselect>
> <cfselect title="Choose Department"
> name="department"
> label="Choose a Department"
> query="spGetOrg"
> value="intOrganisationalDepartmentID"
> diplay="nvarOrgDepartmentName"
> required="yes"
> width="210"
> enabled="false">
> </cfselect>
> </cfform
>
>
>