Thane
You might want to look into Fusionscript at www.fusionscript.com
With this you can do calls back to the database without refreshing your
page.
This is an example of a FS function:
<!----start of FS function-------->
<cf_fs_function name="MyFunction">
<!---Calls the server page with the CF query---->
<!---and passes the var for your query, from your select box--->
<cf_fs_activeServer action="call"
page="getSubDepts.cfm"
Department= form.MainDept>
<!----Loops through the returned query to populate the next select
box--->
<!---SubDepts will be the next Select box---------->
<cf_fs_loop query="SubDepts">
<cf_fs_select action="addOption"
field="'SubDepts'"
value="query.SubDepts.SubDeptsID"
text="query.SubDepts.SubDeptstext">
</cf_fs_loop>
</cf_fs_function>
<!----You can call the function like so------------>
<select name="MainDept" size="1" onChange="<cf_fs_function
call="MyFunction"/>">
<option value="0" SELECTED>Dept2</option>
....
</SELECT>
Then on your Serverpage (just the CF template with the query code)
you would have something like:
<!--------------------------->
<!---Query to get info------>
<CFQUERY name="QgetSubs">
Select *
WHERE Dept = #ActiveServer.Department#
</CFQUERY>
<!---returns query info back to calling page for use in populating your
select box------->
<cf_fs_activeServer action="return" name="SubDepts" value="#QgetSubs#"
type="query">
You could have as many calls in the function as you needed to populate any
number of select boxes.
you can run any CF code on the server page.
-----Original Message-----
From: Thane Sherrington [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 11:32 AM
To: CF-Talk
Subject: Re: -OT- Javascript and combo boxes
At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote:
>Howdy Thane,
>
>Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote:
>
> > Is it possible to use Javascript to select a choice in a combo box?
>
> > For instance, if I have a form with people listed, and beside each, a
> combo
> > box with all the departments in the company, can I select a department
in
> > the first combobox, and have the other combo boxes automatically switch
to
> > that department as well?
>
>Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF
>Exchange.
I don't think this is what I want. I've got about 30 combo boxes, all
with four or five departments. What I want to do is when I select the
first department for the first person, the following boxes change to that
department. Then if I change the department for the second person, I want
the remaining boxes to change to that.
T
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
