if you're just changing location with document.location.href, no form
variables will be passed. you'll have to submit the form properly. remind
me again, why aren't you just putting 'modrep_results.cfm' as the form
action parameter? if this form gets submitted to itself a few times, then
use the javascript to change the form action for the final submit:
<input type="button" value="Search"
onClick="document.DropDown.action.value
='modrep_results.cfm';document.DropDown.submit()">
[EMAIL PROTECTED]
ham.gov.uk To: <[EMAIL PROTECTED]>
cc:
26/05/2004 16:09 Subject: Re: [ cf-dev ]
Argghghhghghgg!!
Please respond to dev
Sorry should have explained. I can get the submit (button now i've changed
it) to go the modrep_results.cfm page.
The problem is that none of the form variables now exist.
I don't understand why?
I can't really pass them as URL parameters as they don't exist until the
form has been passed back to itself a few times.
Help !
Regards - Paul
Heres the code I have used .....
<table border="0" width="100%" cellspacing=4 cellpadding=6>
<form name="DropDown" method="post">
<cfquery name="get_Menu" datasource="webuserDSN">
SELECT menu_id, menu_name
FROM menus
</cfquery>
<!--- Select Menu Type--->
<tr>
<td colspan="3" valign="top" align="left">
<font face="arial, Arial, Helvetica">
<font size="2">
<font color="#000080"><b>Please select which menu
the report to modify is under.</b><br>
</font>
<font face="arial, Arial, Helvetica">
<font size="2">
This is the menu from the default screen on the
performance website.
<p>
<cfoutput>
<select name="selected_menu" required="yes"
onchange="this.form.submit()">
<option value="">Select Menu</option>
<cfloop query="get_Menu">
<option value="#menu_id#" <cfif
isDefined('form.selected_menu')><cfif form.selected_menu eq
"#menu_id#">selected</cfif></cfif>>#menu_name#</option>
</cfloop>
</select>
</cfoutput>
</font>
</td>
</tr>
<!--- Select Phase Type--->
<cfif isDefined('page.selected_menu')>
<!--- query DB for second drop down list, based on the
selected item from the first list --->
<cfquery name="get_phase" datasource="webuserDSN">
SELECT DISTINCT phases.phase_id, phases.phase,
details.menu_group
FROM details
INNER JOIN phases ON details.phase_id =
phases.phase_id
WHERE menu_group = #page.selected_Menu#
</cfquery>
<tr>
<td colspan="3" valign="top" align="left">
<font face="arial, Arial, Helvetica">
<font size="2">
<font color="#000080"><b>Please select the
Phase which the report relates to.</b>
</font>
<p>
<cfoutput>
<select name="selected_Phase"
required="yes" onchange="this.form.submit()">
<option value="">Select
Phase</option>
<cfloop query="get_Phase">
<option value="#phase_id#"
<cfif isDefined('form.selected_phase')><cfif form.selected_phase eq
"#phase_id#">selected</cfif></cfif>>#phase#</option>
</cfloop>
</select>
</cfoutput>
</font>
</td>
</tr>
</cfif>
<!--- Select Group Type--->
<cfif isDefined('page.selected_phase')>
<cfquery name="get_group" datasource="webuserDSN">
SELECT DISTINCT details.menu_group,
report_groups.report_group, report_groups.group_id, details.phase_id
FROM details
INNER JOIN report_groups ON details.group_id =
report_groups.group_id
WHERE (details.menu_group = #page.selected_Menu# ) AND
(details.phase_id = #page.selected_phase#)
ORDER BY report_groups.report_group ASC
</cfquery>
<tr>
<td colspan="3" valign="top" align="left">
<font face="arial, Arial, Helvetica">
<font size="2">
<font color="#000080"><b>Please select the
Group the report is in.</b><br>
</font>
<p>
<cfoutput>
<select name="selected_group"
required="yes">
<option value="">Select
Group</option>
<cfloop query="get_group">
<option
value="#group_id#">#report_group#</option>
</cfloop>
</select>
</cfoutput>
</font>
</td>
</tr>
</cfif>
</table>
<!--- END COLDFUSION INSERT --->
</td>
</tr>
</table><!--mstheme--><font face="arial, Arial,
Helvetica"><!--mstheme--></font></td>
<td valign="top" align="left" height="110"
width="8"><!--mstheme--><font face="arial, Arial,
Helvetica"><!--mstheme--></font></td>
<td valign="top" align="left" height="110"
width="4"><!--mstheme--><font face="arial, Arial, Helvetica"><img
border="0" src="images/boxside.gif" width="4"
height="110"><!--mstheme--></font></td>
</tr>
<tr>
<td valign="top" align="left" height="12" width="580"
colspan="5"><!--mstheme--><font face="arial, Arial,
Helvetica"><img border="0" src="images/botmlinw.gif" width="580"
height="12"><!--mstheme--></font></td>
</tr>
</table>
<p></p>
<cfoutput>
<input type="button" value="Search"
onClick="document.location.href='modrep_results.cfm'"><br>
</cfoutput>
</form>
*************************************************************************************************
The information contained within this e-mail (and any attachment) sent by
Birmingham City Council is confidential and may be legally privileged. It
is intended only for the named recipient or entity to whom it is addressed.
If you are not the intended recipient please accept our apologies and
notify the sender immediately, or telephone +(44) 121 303 6666.
Unauthorised access, use, disclosure, storage or copying is not permitted
and may be unlawful. Any e-mail including its content may be monitored and
used by Birmingham City Council for reasons of security and for monitoring
internal compliance with the office policy on staff use. E-mail blocking
software may also be used. Any views or opinions presented are solely those
of the originator and do not necessarily represent those of Birmingham City
Council. We cannot guarantee that this message or any attachment is virus
free or has not been intercepted and amended.
*************************************************************************************************
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
