I'm using three textboxes. Two of which are related by using the <cf_TwoSelectsRelated>. I need to add another textbox which is based on the result of the previous used box. For example textbox #1 called Release is linked with textbox #2 by using <cf_TwoSelectsRelated>. Now I want to link textbox #3 results based on the selection of textbox #1. I know I need to use the onChange function. but i'm not sure how. I'm fairly new using ColdFusion and would like to get some help. Look forward to hear some suggestions.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ColdFusion and onChange HELP 1
- Thread starter kirtan
- Start date
-
1
- #2
your textboxes :
<input type=text name=release onchange="javascript:toto()">
<input type=text name=box2>
<input type=text name=box3>
now :
- the javascript function called when the user changes the value of the 1st textbox is toto() (you have to define it, usually in the header, between tags <script> and </script>
- in this function, to retrieve the value entered in the 1st textbox : document.the_name_of_the_form.release.value (something like : if (document.the_name_of_the_form.release.value < 0) )
- and to set the value of the 3rd textbox : document.the_name_of_the_form.box3.value (something like : document.the_name_of_the_form.box3.value=2)
for more i need more info from you
<input type=text name=release onchange="javascript:toto()">
<input type=text name=box2>
<input type=text name=box3>
now :
- the javascript function called when the user changes the value of the 1st textbox is toto() (you have to define it, usually in the header, between tags <script> and </script>
- in this function, to retrieve the value entered in the 1st textbox : document.the_name_of_the_form.release.value (something like : if (document.the_name_of_the_form.release.value < 0) )
- and to set the value of the 3rd textbox : document.the_name_of_the_form.box3.value (something like : document.the_name_of_the_form.box3.value=2)
for more i need more info from you
- Thread starter
- #3
- Thread starter
- #5
I thought i had it. but i guess i don't. Let me provide you with some code and explain what i've already done.
<script>
/****************************************************************************
function name: validate
input : none
output : none
purpose : This function validates the required fields
****************************************************************************/
function validate()
{
//if (document.graph_query_page.release.selectedIndex == -1)
if (document.graph_query_page.release_no.selectedIndex == 0)
{
alert ( 'You must select a release number.');
return false;
}
else if (document.graph_query_page.activity.selectedIndex == 0)
{
alert ( 'You must select a Activity.');
return false;
}
return true;
}
</SCRIPT>
</head>
<body>
<!--------get releases from release table------------------>
<cfquery DATASOURCE=#datasrc# NAME="get_prod_release_no">
select distinct prod_productid, prod_name, release_relno from release_table,
products_table, prod_release_table
where release_relno = prod_release_relno(+)
and prod_release_productid = prod_productid(+)
order by lower(release_relno)
</cfquery>
<cfif #get_prod_release_no.RecordCount# GT 0>
<cfform action= "/cgi/task_completion.pl" method="POST" name="graph_query_page" >
<table align="center" cellspacing="2" cellpadding="2" border="0" width="400">
<tr>
<td align="right"><IMG align=middle height=41 src="images/fmab.gif" width=41> </td>
<td align="left"><H2>Percentage Task Completion Graph</h2><FONT color=#ff0000>
(Note:* indicates a mandatory field)</FONT></H3></td>
</tr>
</table>
<br><br>
<table>
<tr>
<td> </td>
<td align=left><CF_TaskTwoSelectsRelated
query="get_prod_release_no"
name1="release_no"
name2="product_name"
display1="release_relno"
display2="prod_name"
value1="release_relno"
value2="prod_productid"
size1="auto"
size2="auto"
htmlbetween="<br><br>"
forcewidth="50"
autoselectfirst="yes"
formname="graph_query_page"></td>
<td> </td>
</tr>
</table><br>
<table ALIGN="center">
<tr>
<td><font color="red">Activity</FONT> </td>
<td><select name="activity" Size="5">
<option selected value="">-No Selection-</option>
</select><font color="red">*</FONT></td>
</TR>
</table>
<table align="center">
<tr>
<BR><BR>
<input type="hidden" name="type_of_button" >
<!--- Button for applying the entries--->
<td align ="center"><INPUT type=submit value="View" onclick="return validate()"></td>
<td></td>
<td></td>
<!--- Button for cancelling the entries--->
<td align="center"><INPUT type="reset" value="Reset"></td>
</tr>
</table>
</cfform>
</cfif>
<p><p align="center">
<a href="javascript
arent.ACTION_FRAME.print()">Click here to print this page</a></p>
</body>
</html>
Now this is basically the current way i've got two cf statements connected to automatically populate the second drop down box. I refer to another file called "TaskTwoSelectsRelated" which based on the release populates the type of groups that exist for that particular release.
What i want to do is based on the release be able to add another drop down box which would display "activity." So basically the boxes are related based on the release.
Further on i will be adding another list box "details" which will display results based on the activity. I hope this helps.
I'm farily new to this site myself...Is there a way I may be able to attach a file? I would also like to show what I've done with the "TaskTwoSelectsRelated."
<script>
/****************************************************************************
function name: validate
input : none
output : none
purpose : This function validates the required fields
****************************************************************************/
function validate()
{
//if (document.graph_query_page.release.selectedIndex == -1)
if (document.graph_query_page.release_no.selectedIndex == 0)
{
alert ( 'You must select a release number.');
return false;
}
else if (document.graph_query_page.activity.selectedIndex == 0)
{
alert ( 'You must select a Activity.');
return false;
}
return true;
}
</SCRIPT>
</head>
<body>
<!--------get releases from release table------------------>
<cfquery DATASOURCE=#datasrc# NAME="get_prod_release_no">
select distinct prod_productid, prod_name, release_relno from release_table,
products_table, prod_release_table
where release_relno = prod_release_relno(+)
and prod_release_productid = prod_productid(+)
order by lower(release_relno)
</cfquery>
<cfif #get_prod_release_no.RecordCount# GT 0>
<cfform action= "/cgi/task_completion.pl" method="POST" name="graph_query_page" >
<table align="center" cellspacing="2" cellpadding="2" border="0" width="400">
<tr>
<td align="right"><IMG align=middle height=41 src="images/fmab.gif" width=41> </td>
<td align="left"><H2>Percentage Task Completion Graph</h2><FONT color=#ff0000>
(Note:* indicates a mandatory field)</FONT></H3></td>
</tr>
</table>
<br><br>
<table>
<tr>
<td> </td>
<td align=left><CF_TaskTwoSelectsRelated
query="get_prod_release_no"
name1="release_no"
name2="product_name"
display1="release_relno"
display2="prod_name"
value1="release_relno"
value2="prod_productid"
size1="auto"
size2="auto"
htmlbetween="<br><br>"
forcewidth="50"
autoselectfirst="yes"
formname="graph_query_page"></td>
<td> </td>
</tr>
</table><br>
<table ALIGN="center">
<tr>
<td><font color="red">Activity</FONT> </td>
<td><select name="activity" Size="5">
<option selected value="">-No Selection-</option>
</select><font color="red">*</FONT></td>
</TR>
</table>
<table align="center">
<tr>
<BR><BR>
<input type="hidden" name="type_of_button" >
<!--- Button for applying the entries--->
<td align ="center"><INPUT type=submit value="View" onclick="return validate()"></td>
<td></td>
<td></td>
<!--- Button for cancelling the entries--->
<td align="center"><INPUT type="reset" value="Reset"></td>
</tr>
</table>
</cfform>
</cfif>
<p><p align="center">
<a href="javascript
arent.ACTION_FRAME.print()">Click here to print this page</a></p></body>
</html>
Now this is basically the current way i've got two cf statements connected to automatically populate the second drop down box. I refer to another file called "TaskTwoSelectsRelated" which based on the release populates the type of groups that exist for that particular release.
What i want to do is based on the release be able to add another drop down box which would display "activity." So basically the boxes are related based on the release.
Further on i will be adding another list box "details" which will display results based on the activity. I hope this helps.
I'm farily new to this site myself...Is there a way I may be able to attach a file? I would also like to show what I've done with the "TaskTwoSelectsRelated."
- Status