Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
pelican #1
use more than 1 CF_twoselectsrelated per form?
Is it possible to do this? I'm using a loop to create multiple layers on a
page, and then I use Dreamweaver's show/hide layers to show each layer 1 at
a time. That parts works really well. But only the very last layer on the
page with the very last twoselectsrelated actually works like it should.
All of the tags display the query data, but only the last one actually
changes when clicking on the first list. I saw a previous post from back in
2004 on this, but it was never answered. Here's my code. I could only
include part of it as I kept getting size exceeded errors when trying to
send:
<cfif isdefined("URL.ptoname")>
<cfquery name="getname" datasource="AS400">
SELECT dranam,dradrv,dradsp,dralcn,dracpy,dratyp FROM tldb70/DRMST WHERE
dradrv = '#URL.ptoname#'
ORDER BY dranam
</cfquery>
<cfelse>
<cfquery name="getname" datasource="AS400">
SELECT dranam,dradrv,dradsp,dralcn,dracpy,dratyp FROM tldb70/DRMST WHERE
(DRACPY = 5 OR DRACPY = 6) AND DRASTS != 'Z' AND
(DRASID = '100' OR DRASID = '300' OR DRASID = '500')
ORDER BY dranam
</cfquery>
</cfif>
<cfquery name="events" datasource="timeoff">
SELECT * FROM
(SELECT DISTINCT eveventcode, eveventdesc, evincode, evindesc FROM
dbo.elecdocs_events WHERE evedcode = 'vi') jeff1 INNER JOIN
(SELECT rereasoncode, rereasondesc, reeventcode, reincode FROM
dbo.elecdocs_reasons WHERE reeventcode = 'nt') jeff2
ON jeff1.evincode = jeff2.reincode
order by jeff1.eveventdesc, jeff1.evindesc, jeff2.rereasondesc
</cfquery>
<cfquery name="state" datasource="AS400">
SELECT ssast,ssadsc FROM tldb70/stcode ORDER BY ssast
</cfquery>
<cfquery name="GetUnit" datasource="AS400">
SELECT RTATNO FROM tldb70/RSCTM WHERE RTARID = '#trim(getname.DRADRV)#' AND
rtacpy = 05 AND rtatno != ''
</cfquery>
<cfquery name="getplate" datasource="AS400">
SELECT tralno,tralst FROM tldb70/tractr WHERE tratno = '#getunit.rtatno#'
</cfquery>
<cfset urlPTO = "">
<cfif isdefined("URL.ptoname")>
<cfset urlPTO = #URL.ptoname#>
<cfquery name="maxrecnum" datasource="timeoff">
SELECT MAX(recnum) AS recnum FROM dbo.exception_data WHERE driver1 like
'%#urlPTO#%' AND edcode = 'vi'
</cfquery>
<cfif #maxrecnum.recnum# EQ "">
<cfquery name="getfollowups" datasource="timeoff">
SELECT s1_followup, s2_followup, s3_followup, s3_followup, s4_followup,
tm_followup
FROM dbo.exception_data WHERE driver1 like '%#urlPTO#%' AND edcode = 'vi'
</cfquery>
<cfelseif #maxrecnum.recnum# NEQ "">
<cfquery name="getfollowups" datasource="timeoff">
SELECT s1_followup, s2_followup, s3_followup, s3_followup, s4_followup,
tm_followup
FROM dbo.exception_data WHERE driver1 like '%#urlPTO#%' AND edcode = 'vi'
AND recnum = #maxrecnum.recnum#
</cfquery>
</cfif>
</cfif>
<cfquery name="qGetMaxID" datasource="timeoff">
SELECT MAX(recnum) + 1 AS MaxID FROM dbo.exceptions_numbers (HOLDLOCK)
</cfquery>
<cfquery name="getcomments" datasource="timeoff">
SELECT * FROM dbo.elecdocs_comments WHERE driver like '%#urlPTO#%' AND
coedcode = 'vi' ORDER BY codatetime
</cfquery>
<cfset rightnow = dateFormat(Now(), "mm/dd/yyyy") & " " & timeFormat(Now(),
"HH:mm:ss")>
<cfif isDefined("URL.ptoname")>
<cfset length = #len(URL.ptoname)#>
<cfset posi = #find('_', URL.ptoname, 0)#>
<cfset diff = #length# - #posi#>
</cfif>
<cfset Session.MonthList = "1,2,3,4,5,6,7,8,9,10,11,12">
<cfset Session.HourList =
"00,01,02,03,04,05,06,07,08,09,10,11,12,13,14,15,1 6,17,18,19,20,21,22,23">
<cfset Session.MinuteList =
"00,01,02,03,04,05,06,07,08,09,10,11,12,13,14,15,1 6,17,18,19,20,21,22,23,24,
25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41 ,42,43,44,45,46,47,48,49,5
0,51,52,53,54,55,56,57,58,59">
<html>
<head>
<title>Tickets</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_goToURL() { //v3.0
var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
for (i=0; i<(args.length-1); i+=2)
eval(args[i]+".location='"+args[i+1]+"'");
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document;
if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++)
x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++)
x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_showHideLayers() { //v6.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null)
{ v=args[i+2];
if (obj.style) { obj=obj.style;
v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
obj.visibility=v; }
}
//-->
</script>
</head>
<script language="JavaScript">
<!--
function fn_ReloadParent(){
document.all.violations.submit();
opener.history.go(0);
opener.focus();
}
//-->
</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if
((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight;
onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH)
location.reload();
}
MM_reloadPage(true);
//-->
</script>
<body>
<div id="tickets" style="position:absolute; left:366px; top:15px;
width:98px; height:34px; z-index:3; visibility: visible;"><a
href="vi_tickets.cfm"><img src="images/violations_header_greentickets.gif"
width="98" height="34" border="0"></a></div>
<div id="inspections" style="position:absolute; left:463px; top:15px;
width:98px; height:34px; z-index:4; visibility: visible;"><a
href="vi_inspections.cfm"><img
src="images/violations_header_greyinspections.jpg" width="98" height="34"
border="0"></a></div>
<div id="complaints" style="position:absolute; left:560px; top:15px;
width:98px; height:34px; z-index:5; visibility: visible;"><a
href="vi_complaints.cfm"><img
src="images/violations_header_greycomplaints.jpg" width="98" height="34"
border="0"></a></div>
<div id="grayheader" style="position:absolute; left:0px; top:0px;
width:1024px; height:9px; z-index:1; visibility: visible;"><img
src="images/violations_header_background.gif" width="1024" height="9"><img
src="images/violations_header_background.gif" width="1024" height="9"><img
src="images/violations_header_background.gif" width="1024" height="9"><img
src="images/violations_header_background.gif" width="1024" height="9"><img
src="images/violations_header_background.gif" width="1024" height="9"><img
src="images/violations_header_background.gif" width="1024" height="9"></div>
<div id="greenbar" style="position:absolute; left:0px; top:48px;
width:1024px; height:15px; z-index:2; visibility: visible;"><img
src="images/violations_header_greenbar.jpg" width="1024" height="15"></div>
<cfif NOT isDefined("URL.ptoname")>
<cfset chkVal = "">
<cfset bVal = "">
<cfif urlPTO is "">
<cfset bVal = " selected">
</cfif>
<div id="initial" style="position:absolute; left:9px; top:73px;
width:785px; height:60px; z-index:11; visibility: visible;">
<form name="form1" method="get" action="vi_tickets.cfm">
<table>
<tr>
<td width="778" height="60" background="images/vi_main_textbox.gif">
<cfoutput> <strong>Please
select the PTO to begin:</strong>
<select name="ptoname" id="ptoname">
<option value="(Click here)" #bVal#>(Click here)</option>
<cfloop index="i" from="1" to="#getname.RecordCount#">
<cfif Mid(urlPTO,1,4) is Mid(getname.dradrv[i],1,4)>
<cfset chkVal = "selected">
<cfelse>
<cfset chkVal = "">
</cfif>
<option value="#trim(getname.dradrv[i])#"
#chkVal#>#getname.dranam[i]#_#getname.dradrv[i]#</option>
</cfloop>
</select>
</cfoutput>
<input name="enter" type="submit" id="enter" value="Enter">
</td>
</tr>
</table>
</form>
</div>
<cfelse>
<form action="vi_popup.cfm" method="post" name="violations" id="violations"
onSubmit="return require_Sel1AndSel2AndSel3()">
<cfset top = 303>
<cfloop index="seq" from="1" to="20">
<div id="violation<cfoutput>#seq#</cfoutput>" style="position:absolute;
left:9px; top:<cfoutput>#top#</cfoutput>px; width:1040px; height:300px;
z-index:7; visibility:
<cfif #seq# EQ 1>visible;<cfelse>hidden;</cfif>">
<table>
<tr>
<td width="1022" height="300"
background="images/vi_main_textbox2.gif"> <str ong>Inc
ident: </strong> & nbsp;
&n bsp; &nbs
p;
<strong>Reason:</strong><br>
<CF_TwoSelectsRelated
QUERY="events"
TYPE1="select"
NAME1="incident#seq#"
NAME2="reason#seq#"
VALUE1="evincode"
VALUE2="rereasoncode"
DISPLAY1="evindesc"
DISPLAY2="rereasondesc"
DEFAULT1="1"
SIZE1="6"
SIZE2="6"
WIDTH1="150"
WIDTH2="600"
FORCEWIDTH1="40"
FORCEWIDTH2="90"
HTMLBETWEEN=" & nbsp; "
AUTOSELECTFIRST="No"
FORMNAME="violations">
<br>
<strong>Additional comments for this inspection
(necessary):</strong><br>
<textarea name="comments<cfoutput>#seq#</cfoutput>" cols="100"
rows="3" id="comments<cfoutput>#seq#</cfoutput>">No
Violations-violation<cfoutput>#seq#</cfoutput></textarea>
<br>
<br>
<INPUT
name="submit<cfoutput>#seq#</cfoutput>" TYPE="Submit"
id="submit<cfoutput>#seq#</cfoutput>" value="Submit">
<cfset next = #seq#+1><input
name="maxseq" type="hidden" id="maxseq" value="<cfoutput>#seq#</cfoutput>">
<input name="additional<cfoutput>#seq#</cfoutput>" type="button"
id="additional<cfoutput>#seq#</cfoutput>"
onClick="MM_showHideLayers('previous','','hide','v iolation<cfoutput>#next#</
cfoutput>','','show')" value="Additional Violations">
</td>
</tr>
</table>
</div>
<cfset top = #top# + 310>
</cfloop>
</cfif>
<br>
<br>
<br>
<br>
<br>
<cfif isDefined("URL.ptoname")><br>
<br>
<br>
<br>
<input name="UserID" type="hidden" id="UserID"
value="<cfoutput>#UserID#</cfoutput>">
<input name="CreateDate" type="hidden" id="CreateDate"
value="<cfoutput>#rightnow#</cfoutput>">
<input name="event" type="hidden" id="event" value="nt">
</cfif>
<cfif isDefined("URL.ptoname")>
<input name="ptoname" type="hidden" id="ptoname"
value="<cfoutput>#right(URL.ptoname, diff)#</cfoutput>">
<input name="maxid" type="hidden" id="maxid"
value="<cfoutput>#qgetmaxid.maxid#</cfoutput>">
<font color="#00FF40">
<input name="followup_81" type="hidden" id="followup_81" <cfif
(#getfollowups.tm_followup# EQ "YES")>value="YES"<cfelse>value="NO"</cfif>>
<input name="followup_91" type="hidden" id="followup_91" <cfif
(#getfollowups.s1_followup# EQ "YES")>value="YES"<cfelse>value="NO"</cfif>>
<input name="followup_92" type="hidden" id="followup_92" <cfif
(#getfollowups.s2_followup# EQ "YES")>value="YES"<cfelse>value="NO"</cfif>>
<input name="followup_93" type="hidden" id="followup_93" <cfif
(#getfollowups.s3_followup# EQ "YES")>value="YES"<cfelse>value="NO"</cfif>>
<input name="followup_94" type="hidden" id="followup_94" <cfif
(#getfollowups.s4_followup# EQ "YES")>value="YES"<cfelse>value="NO"</cfif>>
</font>
</cfif>
</form>
<cfif isDefined("URL.ptoname")>
Click <a href="vi_main_old.cfm">here</a> to go back to main page.
</cfif>
<cfset session.sForm = structNew()>
</body>
</html>
pelican Guest
-
authenticate win32 form client with form based authentication web services
(Type your message here) -------------------------------- From: kitchai yong Hi, Can you tell me how i authenticate the win32 form client... -
#25676 [Opn->Bgs]: Form hidden input ouput when any form=* is in url_rewriter.tags
ID: 25676 Updated by: sniper@php.net Reported By: davey@php.net -Status: Open +Status: Bogus Bug... -
#25676 [Opn]: Form hidden input ouput when any form=* is in url_rewriter.tags
ID: 25676 Updated by: davey@php.net Reported By: davey@php.net Status: Open Bug Type: Session related... -
#25676 [Bgs->Opn]: Form hidden input ouput when any form=* is in url_rewriter.tags
ID: 25676 Updated by: davey@php.net Reported By: davey@php.net -Status: Bogus +Status: Open Bug... -
#25676 [NEW]: Form hidden input ouput when any form=* is in url_rewriter.tags
From: davey@php.net Operating system: WinXP/FreeBSD PHP version: 4CVS-2003-09-26 (stable) PHP Bug Type: Session related Bug...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
