Thinkpad
asked on
How to resolve the error Server busy or unable to fulfill request ?????
Hi,
We 've developed an Application with Cold Fusion as Front-End , Ingres as Database and IIS as Web Server.
When we are executing a particular page in our application which accesses a table of more than 30,000 records with lot of looping operation we get an error all of a sudden.
The Error we encountered is as Follows :
Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26)
Pls. do suggest us on how to resolve the error, whether we 've to do some settings in Cold Fusion Application Server or in the IIS web server for handlings the load.Also is there any way to release the memory thru. the code or in the Server settings. Pls. reply ASAP.
We 've developed an Application with Cold Fusion as Front-End , Ingres as Database and IIS as Web Server.
When we are executing a particular page in our application which accesses a table of more than 30,000 records with lot of looping operation we get an error all of a sudden.
The Error we encountered is as Follows :
Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26)
Pls. do suggest us on how to resolve the error, whether we 've to do some settings in Cold Fusion Application Server or in the IIS web server for handlings the load.Also is there any way to release the memory thru. the code or in the Server settings. Pls. reply ASAP.
ASKER
The Code (Top Frame and Bottom Frame) is enclosed for your reference. The error is encountered only in Top Frame.
Top Frame
*********
<cftry>
<cfparam name="form.hid_selsarea" default = "">
<cfparam name="form.hid_Src" default = "0">
<cfparam name="form.hid_Count" default="0">
<cfparam name="hid_Addedit" default="">
<cfparam name="cfqry_Result.RecordC
<cfparam name="Form.hid_Query" default="">
<cfparam name="hid_Pk" default="">
<cfparam name="hid_Sa" default="">
<cfparam name="hid_Ft" default="">
<cfparam name="hid_Fun" default="">
<cfparam name="hid_Sd" default="">
<cfparam name="hid_St" default="">
<cfparam name="hid_Sdu" default="">
<cfset tmp_Pk = trim(urldecode(hid_Pk))>
<cfset tmp_Sa = trim(urldecode(hid_Sa))>
<cfset tmp_Fun = trim(urldecode(hid_Fun))>
<cfset cflag='F'>
<cfset session.Addedit = "A">
<cfset FORM.hid_selsarea = #hid_selsarea#>
<html>
<head>
<title></title>
<link href="style.css" rel="STYLESHEET" type="TEXT/CSS">
</head>
<body>
<form name="frm_Addedittop" onload="frm_onload()" action="cf_AddEditstf.cfm"
<div align="center"><center>
<table border="1">
<tr>
<td colspan="13"><p align="center"><font size="4"><strong>Add
/ Edit Staff</strong></font><br>
</p>
</td>
</tr>
<tr>
<td><table border="0">
<tr>
<td> </td>
<td valign="top" nowrap><strong>Pmf Key</strong></td>
<td> </td>
<td valign="top" nowrap><strong>Last Name</strong></td>
<td> </td>
<td valign="top" nowrap><strong>First Name</strong></td>
<td> </td>
<td valign="top" nowrap><strong>Solution Area</strong></td>
<td> </td>
<td valign="top"><strong>Funct
<td> </td>
<td valign="top" nowrap><strong>Date</stron
<td> </td>
<td valign="top"><strong>Time<
<td> </td>
<td valign="top"><strong>Durat
<td> </td>
<td valign="top"><strong>Assig
</tr>
<cfif #hid_Addedit# neq "ADD">
<!--- <script language="JavaScript">
parent.Bottomform.document
</script> --->
<cfif #hid_Addedit# eq "EDIT">
<cfif parameterexists(Session.cf
<!--- <cfset Session.cfqry_AddEditStaff
<cfset Form.hid_Query = Session.cfqry_Staff>
<!--- <cfoutput>#Form.hid_Query#
</cfif>
<!--- <script language="JavaScript">
parent.Bottomform.document
</script> --->
</cfif>
<!--- <cfif isdefined("Session.cfqry_A
<cfif #Form.hid_Query# neq "">
<!--- Executing session qyery to load all values to new query --->
<!--- <cfx_ingres name="cfqry_Result" db=#Session.cawdbNode# sql= #Session.cfqry_AddEditStaf
<cfx_ingres name="cfqry_Result" db=#Session.cawdbNode# sql=#Form.hid_Query#>
<cfset cfqry_Resultnew = QueryNew("pmf_key,last_nam
<cfoutput query = "cfqry_Result">
<cfset cflag = 'F'>
<cfif #trim(hid_Ft)# eq 'ses'>
<cfif #trim(cfqry_Result.session
<cfset cflag = 'T'>
</cfif>
<cfelseif #trim(hid_Ft)# eq 'sta'>
<cfif #trim(cfqry_Result.station
<cfset cflag = 'T'>
</cfif>
<cfelseif #trim(hid_Ft)# eq 'loc'>
<cfif #trim(cfqry_Result.booth)#
<cfset cflag = 'T'>
</cfif>
</cfif>
<!--- (#trim(tmp_Pk)# neq #trim(cfqry_Result.pmf_key
<cfif (trim(tmp_Pk) neq trim(cfqry_Result.pmf_key)
<cfx_ingres name="cfqry_Primary" db=#Session.cawdbNode# sql="select primary_conference,primary
<cfx_ingres name="cfqry_Product" db=#Session.cawdbNode# sql="select schedule.product_code as product_code, productmaster.product as product from schedule,productmaster where schedule.pmf_key ='#trim(cfqry_Result.pmf_k
<cfset temp = QueryAddRow(cfqry_Resultne
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfif #trim(cfqry_Result.session
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfx_ingres name="cfqry_Spaeak" db=#Session.cawdbNode# sql="select * from sessions where primary_speaker = '#trim(cfqry_Result.pmf_ke
<cfif #cfqry_Spaeak.recordcount#
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfelseif #trim(cfqry_Result.station
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelseif #trim(cfqry_Result.booth)#
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfif #cfqry_Product.recordcount
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfif #hid_Addedit# eq "ADT">
<cfset pmf_key_temp =trim(cfqry_Result.pmf_key
<cfset last_name_temp = trim(cfqry_Result.last_nam
<cfset first_name_temp = trim(cfqry_Result.first_na
<cfset Conf_temp = trim(cfqry_Result.Conf)>
<cfset function_temp = trim(cfqry_Result.function
<cfset start_time_temp = trim(cfqry_Result.start_ti
<cfset stop_time_temp = trim(cfqry_Result.stop_tim
<cfset Duration_temp = trim(cfqry_Result.Duration
<cfset Sessions_temp = trim(cfqry_Result.sessions
<cfset Station_temp = trim(cfqry_Result.station)
<cfset Booth_temp =trim(cfqry_Result.booth)>
<cfset tid_temp = trim(cfqry_Result.tid)>
</cfif>
</cfif>
</cfoutput>
<cfif #hid_Addedit# eq "ADT">
<cfif Parameterexists(pmf_key_te
<cfset cflag = 'F'>
<cfif #trim(hid_Ft)# eq 'ses'>
<cfif #trim(Sessions_temp)# eq trim(tmp_Fun)>
<cfset cflag = 'T'>
</cfif>
<cfelseif #trim(hid_Ft)# eq 'sta'>
<cfif #trim(Station_temp)# eq trim(tmp_Fun)>
<cfset cflag = 'T'>
</cfif>
<cfelseif #trim(hid_Ft)# eq 'loc'>
<cfif #trim(Booth_temp)# eq trim(tmp_Fun)>
<cfset cflag = 'T'>
</cfif>
</cfif>
<cfx_ingres name="cfqry_Primary" db=#Session.cawdbNode# sql="select primary_conference,primary
<cfx_ingres name="cfqry_Product" db=#Session.cawdbNode# sql="select schedule.product_code as product_code, productmaster.product as product from schedule,productmaster where schedule.start_time = '#trim(start_time_temp)#' and schedule.stop_time = '#trim(stop_time_temp)#' and schedule.product_code = productmaster.product_code
<cfset temp = QueryAddRow(cfqry_Resultne
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfif #trim(Sessions_temp)# neq ''>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfx_ingres name="cfqry_Spaeak" db=#Session.cawdbNode# sql="select * from sessions where primary_speaker = '#trim(pmf_key_temp)#' and session_code ='#trim(Sessions_temp)#'">
<cfif #cfqry_Spaeak.recordcount#
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfelseif #trim(Station_temp)# neq ''>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelseif #trim(Booth_temp)# neq ''>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfif #cfqry_Product.recordcount
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
</cfif>
<!--- Holding selected values in relevant Hidden variables --->
<cfoutput query = "cfqry_Resultnew">
<tr align="left">
<td><input type="radio" name="rad_Select" onclick="rad_Select_Onclic
<td>#cfqry_Resultnew.pmf_k
<input type = "hidden" name = "hid_Pmfkey" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td>#cfqry_Resultnew.last_
<input type = "hidden" name = "hid_Lastname" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td>#cfqry_Resultnew.first
<input type = "hidden" name = "hid_Firstname" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td>#cfqry_Resultnew.Conf#
<input type = "hidden" name = "hid_Conf" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td>#cfqry_Resultnew.funct
<input type = "hidden" name = "hid_Function" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td nowrap>#left(trim(cfqry_Re
<input type = "hidden" name = "hid_Date" value = "#urlencodedformat(datefor
</td>
<td> </td>
<td nowrap>#left(right(trim(cf
<input type = "hidden" name = "hid_Time" value = "#urlencodedformat(left(ri
</td>
<td> </td>
<td nowrap>#cfqry_Resultnew.Du
<input type = "hidden" name = "hid_Dura" value = "#urlencodedformat(cfqry_R
</td>
<td> </td>
<td>#cfqry_Resultnew.Assig
<input type = "hidden" name = "hid_Stoptime" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Assignval" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Assign" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Pfunct" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Psarea" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Speak" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Sba" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Pprod" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_tid" value = "#trim(cfqry_Resultnew.tid
</td>
</cfoutput>
<cfelse>
<cfset cfqry_Result.RecordCount = 0>
</cfif>
</cfif>
<CFCATCH TYPE="Any">
<H1>Other Error: #CFCATCH.Type#</H1>
<CFOUTPUT>
<UL>
<LI><B>Message:</B> #CFCATCH.message#
<LI><B>Detail:</B> #CFCATCH.Detail#
</UL>
</CFOUTPUT>
</CFCATCH>
</CFTRY>
<!--- <cfcatch type="any">
<cfset CommitThis=FALSE>
</cfcatch>
</cftry> --->
</table>
</td>
</tr>
<!---
<tr>
<td align="center"><input type="button" name="btn_ok"
value=" OK "> <input type="button" name="btn_cancel"
value=" Cancel "></td>
</tr> --->
</table>
<cfoutput>
<input type = "hidden" name = "hid_Src" value = "#form.hid_Src#">
<input type = "hidden" name = "hid_Count" value = "#form.hid_Count#">
<input type = "hidden" name = "hid_Addedit" value = "#hid_Addedit#">
<input type = "hidden" name = "hid_Pk" value = "#hid_Pk#">
<input type = "hidden" name = "hid_Sa" value = "#hid_Sa#">
<input type = "hidden" name = "hid_Ft" value = "#hid_Ft#">
<input type = "hidden" name = "hid_Fun" value = "#hid_Fun#">
<input type = "hidden" name = "hid_Sd" value = "#hid_Sd#">
<input type = "hidden" name = "hid_St" value = "#hid_St#">
<input type = "hidden" name = "hid_Sdu" value = "#hid_Sdu#">
<input type="Hidden" name="hid_Query" value="#urlencodedformat(F
</cfoutput>
<script language="JavaScript">
frm_Addedittop.hid_Query.v
</script>
</center></div>
<p> </p>
<p> </p>
</from>
</body>
</html>
<script language = "javascript">
function rad_Select_Onclick()
{
parent.Bottomform.document
var count=<cfoutput>#cfqry_Res
if (count == 1)
{
if (document.frm_Addedittop.r
{
Reassigncnt1();
if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
parent.Bottomform.document
document.frm_Addedittop.hi
parent.Bottomform.document
parent.Bottomform.document
}
}
if (count > 1)
{
for (i=0;i<count;i++)
{
if (document.frm_Addedittop.r
{
Reassign(i);
if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
parent.Bottomform.document
//document.frm_Addedittop.
document.frm_Addedittop.hi
parent.Bottomform.document
parent.Bottomform.document
}
}
}
}
function Reassign(i)
{
var count= "";
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
//parent.Bottomform.docume
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
}
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else
{
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if(unescape(parent.Bottomf
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
if (document.frm_Addedittop.h
{
parent.Bottomform.document
}
else
{
parent.Bottomform.document
}
if (document.frm_Addedittop.h
{
parent.Bottomform.document
}
else
{
parent.Bottomform.document
}
} // end of function
function Reassigncnt1()
{
var count= "";
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
}
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else
{
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (unescape(parent.Bottomfor
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
if (document.frm_Addedittop.h
{
parent.Bottomform.document
}
else
{
parent.Bottomform.document
}
if (document.frm_Addedittop.h
{
parent.Bottomform.document
}
else
{
parent.Bottomform.document
}
}
function clear()
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
if(document.frm_Addedittop
{
var counter=<cfoutput>#cfqry_R
if (counter == 1)
{
Reassigncnt1()
document.frm_Addedittop.ra
if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
parent.Bottomform.document
document.frm_Addedittop.hi
parent.Bottomform.document
parent.Bottomform.document
}
if (counter > 1)
{
// var i = document.frm_Addedittop.hi
var i=0;
for (n=0;n < document.frm_Addedittop.hi
{
if (document.frm_Addedittop.h
{
i = n;
break ;
}
}
Reassign(i)
document.frm_Addedittop.ra
if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
parent.Bottomform.document
document.frm_Addedittop.hi
parent.Bottomform.document
parent.Bottomform.document
}
}
</script>
**************************
Bottom Frame
************
<cfparam name="form.hid_Source" default="">
<cfset flag = "T">
<cfif form.hid_Source eq 'Sessionmgmt'>
<cfif parameterexists(hid_Logche
<cfset flag = "T">
<cfelse>
<cfset flag = "F">
<cfoutput>
<script>
alert("Incorrect login");
self.location="../Travel&T
</script>
</cfoutput>
</cfif>
</cfif>
<cfif flag eq "T">
<cfinclude template="../cf_Errpage.cf
<cfparam name="form.hid_CMode" default="T">
<cfparam name="form.hid_SMode" default="">
<cfparam name="form.hid_Ass" default="">
<cfparam name="form.hid_valass" default="">
<cfparam name="form.rdo_Assign" default="ses">
<cfparam name="form.chk_Pspeak" default="F">
<cfparam name="form.chk_Sba" default="F">
<cfparam name="form.hid_Pinfo" default="F">
<cfparam name="form.hid_Proc" default="F">
<cfparam name="form.hid_Stoptime" default="">
<cfparam name="form.hid_Source1" default="">
<cfparam name="form.hid_Defsarea" default="">
<cfparam name="form.hid_Defses" default="">
<cfparam name="hid_Addedit" default="">
<cfparam name="url.tmp_Pmfkey" default="">
<cfparam name="Form.hid_Query" default="">
<!--- Temporary variable declaration part --->
<cfset msg = 0>
<cfset tmp_ses = ''>
<cfset tmp_sta = ''>
<cfset tmp_loc = ''>
<cfset counter = 0>
<cfset tmp_pmf=''>
<cfset tmp_sarea=''>
<cfset tmp_fname=''>
<cfset tmp_lname=''>
<cfset tmp_funct='SPEAKER'>
<cfset tmp_ass=''>
<cfset tmp_assval=''>
<cfset tmp_pfunct=''>
<cfset tmp_parea=''>
<cfset tmp_pprod=''>
<cfset tmp_pspeak=''>
<cfset tmp_sba=''>
<cfset tmp_date=''>
<cfset tmp_time=''>
<cfset tmp_dura=''>
<cfset tmp_sdate=''>
<cfset tmp_stime=''>
<cfset tmp_sdura=''>
<cfset tmp_spmf=''>
<cfset warning=''>
<cfset tmp_sassign=''>
<cfset tmp_sassignval=''>
<cfset ass_flag='F'>
<cfparam name="form.hid_Count" default="0">
<!--- Temporary variable declaration part ends here--->
<script language="JavaScript">
function cbo_Sarea_onchange()
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
function cbo_Assign_onchange()
{
if (frm_Edtstf.rdo_Assign[0].
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
else if(frm_Edtstf.rdo_Assign[1
{
frm_Edtstf.hid_Cmode.value
}
else if(frm_Edtstf.rdo_Assign[2
{
frm_Edtstf.hid_Cmode.value
}
//frm_Edtstf.submit()
}
function cbo_Pfunct_onchange()
{
frm_Edtstf.hid_Pinfo.value
}
function cbo_Psarea_onchange()
{
frm_Edtstf.hid_Pinfo.value
}
function chk_Sba_onclick()
{
frm_Edtstf.hid_Pinfo.value
}
function cbo_Funct_onchange()
{
var str
str=ltrim(rtrim(unescape(f
if(str.toUpperCase() == "SPEAKER")
{
frm_Edtstf.chk_Pspeak.disa
}
else
{
frm_Edtstf.chk_Pspeak.chec
frm_Edtstf.chk_Pspeak.valu
frm_Edtstf.chk_Pspeak.disa
}
}
function btn_Search_onclick()
{
if (frm_Edtstf.txt_Pmfkey.val
frm_Edtstf.txt_Lastname.va
{
Err_msg(199)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if (frm_Edtstf.txt_Pmfkey.val
frm_Edtstf.txt_Lastname.va
{
frm_Edtstf.hid_Search.valu
Pmfkey_Search()
}
if (frm_Edtstf.txt_Pmfkey.val
frm_Edtstf.txt_Lastname.va
{
frm_Edtstf.hid_Search.valu
//frm_Edtstf.txt_Firstname
Lastname_Search()
}
if (frm_Edtstf.txt_Pmfkey.val
frm_Edtstf.txt_Lastname.va
{
frm_Edtstf.hid_Search.valu
Pmfkey_Search()
}
}
function txt_Pmfkey_onchange()
{
frm_Edtstf.txt_Lastname.va
frm_Edtstf.txt_Firstname.v
}
function txt_Lastname_onchange()
{
frm_Edtstf.txt_Pmfkey.valu
frm_Edtstf.txt_Firstname.v
}
function rdo_onclick()
{
if(frm_Edtstf.rdo_Assign[0
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
else
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
}
function Pmfkey_Search() // Pmfkey Search
{
ret=window.open("Person.cf
lue)+"&FormNm=frm_Edtstf&L
txt_Pmfkey", "NewWind",
"left=50,top=50,height=500
,scrollbars=yes")
}
function Lastname_Search() // Lastname Search
{
ret=window.open("Person.cf
.value)+"&FormNm=frm_Edtst
t=txt_Lastname", "NewWind",
"left=50,top=50,height=500
,scrollbars=yes,locationba
}
function ltrim(argvalue)
{
while (1) {
if (argvalue.substring(0, 1) != "")
break;
argvalue = argvalue.substring(1, argvalue.length);
}
return argvalue;
}
function rtrim(argvalue)
{
while (1) {
if (argvalue.substring(argval
break;
argvalue = argvalue.substring(0, argvalue.length - 1);
}
return argvalue;
}
function btn_Add_onclick()
{
frm_Edtstf.hid_Query.value
uery.value
if(frm_Edtstf.txt_Pmfkey.v
{
Err_msg(244)
frm_Edtstf.txt_Pmfkey.focu
return false
}
else if(frm_Edtstf.cbo_Funct.va
{
Err_msg(245)
frm_Edtstf.cbo_Funct.focus
return false
}
else if (frm_Edtstf.cbo_Assign.val
{
Err_msg(246)
frm_Edtstf.cbo_Assign.focu
return false
}
if(frm_Edtstf.txt_Pmfkey.v
frm_Edtstf.txt_Firstname.v
== "")
{
Err_msg(66)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if (frm_Edtstf.cbo_Date.type == "text")
{
if(frm_Edtstf.cbo_Date.val
{
alert("Date is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
if(frm_Edtstf.cbo_Time.val
{
alert("Time is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
if(frm_Edtstf.cbo_Dura.val
{
alert("Duration is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
}
else
{
if(frm_Edtstf.cbo_Date.val
{
alert("Date is mandatory")
frm_Edtstf.cbo_Date.focus(
return false
}
if(frm_Edtstf.cbo_Time.val
{
alert("Time is mandatory")
frm_Edtstf.cbo_Time.focus(
return false
}
if(frm_Edtstf.cbo_Dura.val
{
alert("Duration is mandatory")
frm_Edtstf.cbo_Dura.focus(
return false
}
}
frm_Edtstf.hid_Cmode.value
frm_Edtstf.hid_Smode.value
frm_Edtstf.submit()
}
function btn_Change_onclick()
{
if(frm_Edtstf.txt_Pmfkey.v
{
Err_msg(244)
frm_Edtstf.txt_Pmfkey.focu
return false
}
else if(frm_Edtstf.cbo_Funct.va
{
Err_msg(245)
frm_Edtstf.cbo_Funct.focus
return false
}
else if (frm_Edtstf.cbo_Assign.val
{
Err_msg(246)
frm_Edtstf.cbo_Assign.focu
return false
}
if(frm_Edtstf.txt_Pmfkey.v
frm_Edtstf.txt_Firstname.v
== "")
{
Err_msg(66)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if (frm_Edtstf.cbo_Date.type == "text")
{
if(frm_Edtstf.cbo_Date.val
{
alert("Date is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
if(frm_Edtstf.cbo_Time.val
{
alert("Time is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
if(frm_Edtstf.cbo_Dura.val
{
alert("Duration is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
}
else
{
if(frm_Edtstf.cbo_Date.val
{
alert("Date is mandatory")
frm_Edtstf.cbo_Date.focus(
return false
}
if(frm_Edtstf.cbo_Time.val
{
alert("Time is mandatory")
frm_Edtstf.cbo_Time.focus(
return false
}
if(frm_Edtstf.cbo_Dura.val
{
alert("Duration is mandatory")
frm_Edtstf.cbo_Dura.focus(
return false
}
}
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
function btn_Delete_onclick()
{
var pmf = unescape(frm_Edtstf.hid_Sp
var func = unescape(frm_Edtstf.cbo_Fu
var sd = unescape(frm_Edtstf.hid_Sd
var sdt = unescape(frm_Edtstf.hid_St
var sdtd = unescape(frm_Edtstf.hid_Sd
var asg = unescape(frm_Edtstf.cbo_As
var st = unescape(frm_Edtstf.hid_St
if(frm_Edtstf.txt_Pmfkey.v
{
Err_msg(249)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if(frm_Edtstf.txt_Pmfkey.v
frm_Edtstf.txt_Firstname.v
== "")
{
Err_msg(66)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if(confirm("Delete " + pmf + "'s assignment as " + func + "\n" + "
From:" + sd + " " + sdt + " Duration:" + sdtd +" To:" + st + " At:" +
asg + "\n" +"Are you Sure?"))
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Count.value
frm_Edtstf.submit();
}
}
function btn_Close_onclick()
{
if(frm_Edtstf.hid_Source.v
{
frm_Edtstf.target = "_parent"
frm_Edtstf.action="cf_Staf
frm_Edtstf.submit();
}
if(frm_Edtstf.hid_Source1.
{
frm_Edtstf.target = "_parent"
frm_Edtstf.action="cf_sess
frm_Edtstf.submit();
}
}
function btn_Home_onclick()
{
parent.location.href = "cf_Mainmn.cfm?hid_Logchec
}
function clear()
{
frm_Edtstf.txt_Pmfkey.valu
frm_Edtstf.txt_Lastname.va
frm_Edtstf.txt_Firstname.v
frm_Edtstf.cbo_Sarea.selec
frm_Edtstf.cbo_Funct.selec
frm_Edtstf.cbo_Assign.sele
frm_Edtstf.cbo_Pfunct.sele
frm_Edtstf.cbo_Psarea.sele
frm_Edtstf.cbo_Pprod.selec
frm_Edtstf.chk_Pspeak.chec
frm_Edtstf.chk_Sba.checked
frm_Edtstf.cbo_Date.select
frm_Edtstf.cbo_Time.select
frm_Edtstf.cbo_Dura.select
}
function txt_Pmfkey_onblur()
{
frm_Edtstf.txt_Lastname.va
frm_Edtstf.txt_Firstname.v
if(frm_Edtstf.txt_Pmfkey.v
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
return true;
}
else
{
frm_Edtstf.txt_Lastname.fo
}
}
</script>
<cfif form.hid_Cmode neq "T">
<!--- holding screen values while submitting the form --->
<cfset tmp_pmf= '#trim(urldecode(form.txt_
<cfset tmp_sarea='#trim(urldecode
<cfset tmp_fname='#trim(urldecode
<cfset tmp_lname='#trim(urldecode
<cfset tmp_funct='#trim(urldecode
<cfset tmp_ass='#trim(urldecode(f
<cfif form.rdo_Assign eq 'ses'>
<cfset tmp_ses = #trim(urldecode(form.cbo_A
<cfset tmp_sta = ''>
<cfset tmp_loc = ''>
<cfelseif form.rdo_Assign eq 'sta'>
<cfset tmp_sta = #trim(urldecode(form.cbo_A
<cfset tmp_ses = ''>
<cfset tmp_loc = ''>
<cfelseif form.rdo_Assign eq 'loc'>
<cfset tmp_loc = #trim(urldecode(form.cbo_A
<cfset tmp_sta = ''>
<cfset tmp_ses = ''>
</cfif>
<cfset tmp_assval='#trim(urldecod
<cfset tmp_sdate=form.hid_Sdate>
<cfset tmp_stime=form.hid_Stime>
<cfset tmp_sdura=form.hid_Sdura>
<cfset tmp_spmf=form.hid_Spmf>
<cfset tmp_sassign = form.hid_Sassign>
<cfset tmp_sassignval = form.hid_Sassignval>
<cfset tmp_pfunct='#trim(urldecod
<cfset tmp_parea='#trim(urldecode
<cfset tmp_pprod='#trim(urldecode
<cfset tmp_pspeak='#trim(urldecod
<cfset tmp_sba='#trim(urldecode(f
<cfset tmp_date='#trim(urldecode(
<cfset tmp_time='#trim(urldecode(
<cfset tmp_dura='#trim(urldecode(
<!--- new code --->
<cfif form.hid_Source eq "Staff" and trim(form.hid_valass) neq ''>
<cfset
tmp_assval='#trim(urldecod
<cfset form.cbo_Assign =
'#trim(urldecode(form.hid_
<cfset form.hid_Cmode = "ASC">
<cfif form.rdo_Assign eq 'ses'>
<cfset tmp_ses = #trim(urldecode(form.cbo_A
<cfset tmp_sta = ''>
<cfset tmp_loc = ''>
<cfelseif form.rdo_Assign eq 'sta'>
<cfset tmp_sta = #trim(urldecode(form.cbo_A
<cfset tmp_ses = ''>
<cfset tmp_loc = ''>
<cfelseif form.rdo_Assign eq 'loc'>
<cfset tmp_loc = #trim(urldecode(form.cbo_A
<cfset tmp_sta = ''>
<cfset tmp_ses = ''>
</cfif>
<cfset form.hid_valass = ''>
</cfif>
<!--- new code ends --->
<cfelse>
<cfif parameterexists(url.hid_So
<cfset form.hid_Source = "Staff">
<cfset form.hid_Defsarea = #trim(url.hid_selsarea)#>
<cfset tmp_sarea = #trim(url.hid_selsarea)#>
<cfset form.hid_Defses = '#trim(url.hid_Defses)#'>
<cfelse>
<cfset form.hid_Source1 = "Sessionmgmt">
<cfset form.hid_Defsarea = #trim(url.hid_selsarea)#>
<cfset tmp_sarea = #trim(url.hid_selsarea)#>
<cfset form.hid_Defses = '#trim(url.hid_Defses)#'>
</cfif>
<cfif #trim(form.hid_Defses)# eq ''>
<cfset form.hid_Cmode = "SAC">
<cfelse>
<cfif parameterexists(url.hid_So
<cfset form.cbo_Assign = '#trim(url.hid_Defses)#'>
<cfelse>
<cfset form.cbo_Assign =
'#trim(url.hid_Defses)#'>
</cfif>
<cfset form.hid_Cmode = "ASC">
</cfif>
</cfif>
<cfif form.hid_Smode eq "A">
<cfif #form.hid_Proc# neq 'ATY'>
<cfif #tmp_pmf# neq "TBA">
<cfset #stdate# = #tmp_date# & ' ' &
#tmp_time#>
<cfx_ingres name="cfqry_ruledates"
db=#Session.cawdbNode# sql="select date('#stdate#') as
new_start,date('#stdate#')
<cfset new_start =
trim(cfqry_ruledates.new_s
<cfset new_stop =
trim(cfqry_ruledates.new_s
<!--- checking rule10 --->
<cfset warning = "Desired Schedule time " &
#new_start# & " to " & #new_stop# & "\n\n Currently scheduled
commitments include: \n\n ">
<cfx_ingres name="cfqry_Insrule10"
db=#Session.cawdbNode# sql="select start_time as old_start, stop_time
as old_stop,sessions as old_session_code, booth as
old_booth_code,station as old_station_code, conf as old_conf_code,
function as old_function from schedule
where uppercase(pmf_key) =
'#ucase(rereplace(tmp_pmf,
'#new_start#' and stop_time > '#new_start#') or (start_time <
'#new_stop#' and stop_time >= '#new_stop#') or ( start_time >=
'#new_start#' and stop_time <= '#new_stop#') or (( (stop_time <=
'#new_start#' and (stop_time + date('15 minutes')) > '#new_start#') or
(start_time >= '#new_stop#' and (start_time - date('15 minutes')) <
'#new_stop#' ) ))) order by 1">
<cfif #cfqry_Insrule10.recordcou
<cfset counter = 0>
<cfloop query="cfqry_Insrule10">
<cfset counter = counter + 1>
<cfset warning = warning & " " &
#counter# & " ">
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & "
Conference " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & "
Location " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & "
Station " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & "
Session " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & " as
a " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif #trim(cfqry_Insrule10.old_
neq "" and #trim(cfqry_Insrule10.old_
<cfset warning = warning & "
from " & #trim(cfqry_Insrule10.old_
#trim(cfqry_Insrule10.old_
</cfif>
<cfif
(((#rereplace(tmp_funct,"'
(#rereplace(tmp_funct,"'",
eq 'MONITOR' and '#trim(cfqry_Insrule10.old
and
((datecompare("#new_start#
and datecompare("#new_start#",
-1) or
(datecompare
("#new_stop#","#trim(cfqry
datecompare("#new_stop#","
(datecompare
("#new_start#","#trim(cfqr
datecompare("#new_stop#","
(datecompare
("#new_start#","#trim(cfqr
datecompare("#new_stop#","
<cfset #form.hid_Proc# = 'ATD'>
<cfelse>
<cfset #form.hid_Proc# = 'AT'>
</cfif>
</cfloop>
<cfelse>
<cfset #form.hid_Proc# = 'ATY'>
</cfif>
<cfelse>
<cfset #form.hid_Proc# = 'ATY'>
</cfif>
</cfif>
<!--- process skipped for getting rule 10 confirmation, see
code below for flag AT --->
<cfif #form.hid_Proc# eq 'ATY'>
<!--- After confirmation of rule control adding process starts
here --->
<cfset #form.hid_Proc# = ''>
<cfset #stdate# = #tmp_date# & ' ' & #tmp_time#>
<cfif trim(form.rdo_Assign) is "ses">
<cfx_ingres name="cfqry_Inssche"
db=#Session.cawdbNode# sql="insert into
schedule(pmf_key,start_tim
ion,product_code)
values('#ucase(rereplace(t
#' +
date('#tmp_dura#'),'#rerep
ce(tmp_sarea,"'","''","ALL
,'#rereplace(tmp_pprod,"'"
<cfelseif trim(form.rdo_Assign) is "sta">
<cfx_ingres name="cfqry_Inssche"
db=#Session.cawdbNode# sql="insert into
schedule(pmf_key,start_tim
ion,product_code)
values('#ucase(rereplace(t
#' +
date('#tmp_dura#'),'#rerep
ce(tmp_sarea,"'","''","ALL
,'#rereplace(tmp_pprod,"'"
<cfelseif trim(form.rdo_Assign) is "loc">
<cfx_ingres name="cfqry_Inssche"
db=#Session.cawdbNode# sql="insert into
schedule(pmf_key,start_tim
ion,product_code)
values('#ucase(rereplace(t
#' +
date('#tmp_dura#'),'#rerep
tmp_loc,"'","''","ALL")#',
,'#rereplace(tmp_pprod,"'"
</cfif>
<!--- <cfx_ingres name="cfqry_Inssche" db=#Session.cawdbNode#
sql="insert into
schedule(pmf_key,start_tim
ion,product_code)
values('#ucase(rereplace(t
#' +
date('#tmp_dura#'),'#rerep
tmp_loc,"'","''","ALL")#',
eplace(tmp_ses,"'","''","A
'#rereplace(tmp_pprod,"'",
<cfif #tmp_pspeak# eq 'T' and #tmp_ses# neq '' and
#tmp_funct# eq 'SPEAKER'>
<cfx_ingres name="cfqry_Insupdses"
db=#Session.cawdbNode# sql="update sessions set
primary_speaker='#ucase(re
session_code='#rereplace(t
</cfif>
<cfif form.hid_Pinfo eq 'T'>
<cfx_ingres name="cfqry_Insupdper"
db=#Session.cawdbNode# sql="update person set
primary_conference='#rerep
tion='#rereplace(tmp_pfunc
a#' where
uppercase(pmf_key)='#ucase
</cfif>
<cfx_ingres name="cfqry_Ssdate" db=#Session.cawdbNode#
sql="select start_time,stop_time from schedule where start_time =
'#stdate#' and stop_time = '#stdate#' + date('#tmp_dura#') and
uppercase(pmf_key) = '#ucase(rereplace(tmp_pmf,
<cfx_ingres name="cfqry_Inswasis"
db=#Session.cawdbNode# sql="insert into
wasis_log(table_affected,w
y,comments) values
('SCHEDULE','#ucase(rerepl
,'#Session.Inventpmfkey#',
'#rereplace(trim(tmp_funct
'#trim(cfqry_Ssdate.start_
'#trim(cfqry_Ssdate.stop_t
'#trim(tmp_sarea)#')">
<cfset msg = 4>
<!--- setting session query to reflect the changes to
the upper frame --->
<cfset clause = "schedule.pmf_key = person.pmf_key
and schedule.pmf_key = '#ucase(rereplace(tmp_pmf,
schedule.conf = '#trim(tmp_sarea)#'" >
<cfset clause = clause & " and schedule.function =
'#rereplace(trim(tmp_funct
<cfset #stdate# = #tmp_date# & ' ' & #tmp_time#>
<cfset clause = clause & " and start_time='#stdate#'
and stop_time ='#stdate#' + date('#tmp_dura#')">
<cfif form.rdo_Assign eq 'ses'>
<cfset clause=clause & " and
schedule.sessions = '#rereplace(trim(tmp_ses),
<cfset sqlstr = "select
Schedule.Pmf_Key , Person.Last_Name,Person.Fi
Schedule.Function,Schedule
Schedule.Stop_Time,Schedul
Schedule.Conf, char(Person.Shirt_Size) as Shirt_Size ,
Schedule.Stop_Time - Schedule.Start_Time as duration,Schedule.tid FROM
SCHEDULE, PERSON WHERE " & clause & " order by 1,5">
<cfelseif form.rdo_Assign eq 'sta'>
<cfset clause=clause & " and
schedule.station = '#rereplace(trim(tmp_sta),
<cfset sqlstr = "select
Schedule.Pmf_Key , Person.Last_Name,Person.Fi
Schedule.Function,Schedule
Schedule.Stop_Time,Schedul
Schedule.Conf, char(Person.Shirt_Size) as Shirt_Size ,
Schedule.Stop_Time - Schedule.Start_Time as duration,Schedule.tid FROM
SCHEDULE, PERSON WHERE " & clause & " order by 1,5">
<cfelseif form.rdo_Assign eq 'loc'>
<cfset clause= clause & " and
schedule.booth = '#rereplace(trim(tmp_loc),
<cfset sqlstr = "select
Schedule.Pmf_Key , Person.Last_Name,Person.Fi
Schedule.Function,Schedule
Schedule.Stop_Time,Schedul
Schedule.Conf, char(Person.Shirt_Size) as Shirt_Size ,
Schedule.Stop_Time - Schedule.Start_Time as duration,Schedule.tid FROM
SCHEDULE, PERSON WHERE " & clause & " order by 1,5">
</cfif>
<cfif form.hid_Addedit eq 'ADD'>
<!--- <cfset Session.cfqry_AddEditStaff
#sqlstr#> --->
<cfelse>
<script language="JavaScript">
parent.Topform.document.fr
"<cfoutput>#urlencodedform
parent.Topform.document.fr
"<cfoutput>#urlencodedform
parent.Topform.document.fr
"<cfoutput>#form.rdo_Assig
parent.Topform.document.fr
"<cfoutput>#urlencodedform
parent.Topform.document.fr
"<cfoutput>#tmp_date#</cfo
parent.Topform.document.fr
"<cfoutput>#tmp_time#</cfo
parent.Topform.document.fr
"<cfoutput>#tmp_dura#</cfo
</script>
<!--- setting session query to reflect the
changes to the upper frame --->
<cfset clause1 = "schedule.pmf_key =
person.pmf_key and schedule.pmf_key =
'#ucase(rereplace(tmp_pmf,
'#trim(tmp_sarea)#'" >
<cfset clause1 = clause1 & " and
schedule.function = '#rereplace(trim(tmp_funct
<cfset #stdate# = #tmp_date# & ' ' &
#tmp_time#>
<cfset clause1 = clause1 & " and
start_time='#stdate#' and stop_time ='#stdate#' + date('#tmp_dura#')">
<cfif form.rdo_Assign eq 'ses'>
<cfset clause1=clause1 & " and
schedule.sessions = '#rereplace(trim(tmp_ses),
<cfelseif form.rdo_Assign eq 'sta'>
<cfset clause1=clause1 & " and
schedule.station = '#rereplace(trim(tmp_sta),
<cfelseif form.rdo_Assign eq 'loc'>
<cfset clause1 = clause1 & " and
schedule.booth = '#rereplace(trim(tmp_loc),
</cfif>
<!--- <cfset sqlstr =
left(trim(Session.cfqry_Ad
ff)) - 13)> --->
<cfif len(trim(Form.hid_Query)) gt 0>
<cfset sqlstr =
left(trim(Form.hid_Query),
<cfset sqlstr = sqlstr & ' or
(' & clause1 & ' )' & ' order by 1,5'>
</cfif>
<!--- <cfset Session.cfqry_AddEditStaff
#sqlstr#> --->
</cfif>
<cfset tmp_pmf = ''>
<cfset tmp_lname = ''>
<cfset tmp_fname = ''>
<cfset form.chk_Pspeak = "F">
<cfset form.chk_Sba ="F">
<cfset tmp_pfunct=''>
<cfset tmp_parea=''>
<cfset tmp_pprod=''>
<cfset tmp_pspeak=''>
<cfset #form.hid_Smode# = ''>
<cfset #form.hid_Proc# =''>
</cfif>
<cfelseif form.hid_Smode eq "C">
<!--- Checking Rule10 starts here --->
<cfif #form.hid_Proc# neq 'CTY'>
<cfif #tmp_pmf# neq "TBA">
<cfif ((ucase(trim(tmp_Pmf)) neq
ucase(trim(tmp_spmf))) or (trim(tmp_date) neq trim(tmp_sdate)) or
(trim(tmp_time) neq trim(tmp_stime)) or (trim(tmp_dura) neq
trim(tmp_sdura)))>
<cfset #stdate# = #tmp_date# & ' ' &
#tmp_time#>
<cfx_ingres name="cfqry_ruledates"
db=#Session.cawdbNode# sql="select date('#stdate#') as
new_start,date('#stdate#')
<cfset new_start =
trim(cfqry_ruledates.new_s
<cfset new_stop =
trim(cfqry_ruledates.new_s
<cfset warning = "Desired Schedule time: " &
#new_start# & " to " & #new_stop# & "\n\n Currently scheduled
commitments include: \n\n">
<cfx_ingres name="cfqry_Insrule10"
db=#Session.cawdbNode# sql="select pmf_key, start_time as old_start,
stop_time as old_stop,sessions as old_session_code, booth as
old_booth_code,station as old_station_code, conf as old_conf_code,
function as old_function from schedule
where uppercase(pmf_key)=
'#ucase(rereplace(tmp_pmf,
'#new_start#' and stop_time > '#new_start#') or (start_time <
'#new_stop#' and stop_time >= '#new_stop#') or ( start_time >=
'#new_start#' and stop_time <= '#new_stop#') or (((stop_time <=
'#new_start#' and (stop_time + date('15 minutes')) > '#new_start#') or
(start_time >= '#new_stop#' and (start_time - date('15 minutes')) <
'#new_stop#' )))) order by 1">
<cfif #cfqry_Insrule10.recordcou
<cfset counter = 0>
<cfloop query="cfqry_Insrule10">
<cfif tmp_sassign eq 'ses'>
<cfif trim(tmp_sassignval) neq
trim(cfqry_Insrule10.old_s
<cfset ass_flag = "T">
</cfif>
<cfelseif tmp_sassign eq 'sta'>
<cfif trim(tmp_sassignval) neq
trim(cfqry_Insrule10.old_s
<cfset ass_flag = "T">
</cfif>
<cfelseif tmp_sassign eq 'loc'>
<cfif trim(tmp_sassignval) neq
trim(cfqry_Insrule10.old_b
<cfset ass_flag = "T">
</cfif>
</cfif>
<cfset #rsdate# = #tmp_sdate# & ' ' &
#tmp_stime#>
<cfx_ingres name="cfqry_compdates"
db=#Session.cawdbNode# sql="select date('#rsdate#') as
act_start,date('#rsdate#')
<cfif (ucase(trim(#tmp_spmf#)) neq
trim(#cfqry_Insrule10.pmf_
(datecompare("#trim(cfqry_
.old_start)#") neq 0) and
(datecompare("#trim(cfqry_
old_stop)#") neq 0) and (#ass_flag# eq "T")>
<cfset counter = counter + 1>
<cfset warning = warning & " "
& #counter# & " ">
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " Conference " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " Location " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " Station " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " Session " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " as a " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " from " & #trim(cfqry_Insrule10.old_
#trim(cfqry_Insrule10.old_
</cfif>
<cfif ((
(#rereplace(tmp_funct,"'",
(#rereplace(tmp_funct,"'",
'#trim(cfqry_Insrule10.old
((datecompare("#new_start#
and datecompare("#new_start#",
-1) or
(datecompare
("#new_stop#","#trim(cfqry
datecompare("#new_stop#","
(datecompare
("#new_start#","#trim(cfqr
datecompare("#new_stop#","
(datecompare
("#new_start#","#trim(cfqr
datecompare("#new_stop#","
<cfset #form.hid_Proc#
= 'CTD'>
<cfelse>
<cfset #form.hid_Proc#
= 'CT'>
</cfif>
<cfelse>
<cfset #form.hid_Proc# = 'CTY'>
</cfif>
</cfloop>
<cfelse>
<cfset #form.hid_Proc# = 'CTY'>
</cfif>
<cfelse>
<cfset #form.hid_Proc# = 'CTY'>
</cfif>
<cfelse>
<cfset #form.hid_Proc# = 'CTY'>
</cfif>
</cfif>
<!--- process skipped for getting rule 10 confirmation,see
code below for flag CT --->
<cfif #form.hid_Proc# eq 'CTY'>
<!--- After confirmation of rule control updation process
starts here --->
<cfset #wcsdate# = #tmp_sdate# & ' ' & #tmp_stime#>
<cfset #stdate# = #tmp_date# & ' ' & #tmp_time#>
<cfif trim(form.rdo_Assign) is "ses">
<cfx_ingres name="cfqry_Updsche"
db=#Session.cawdbNode# sql="update schedule set pmf_key =
'#ucase(rereplace(tmp_pmf,
start_time='#stdate#',stop
+date('#tmp_dura#'),functi
oth='',
conf='#rereplace(tmp_sarea
es,"'","''","ALL")#',stati
"''","ALL")#' where uppercase(pmf_key) = '#ucase(tmp_spmf)#' and
start_time='#wcsdate#' and stop_time ='#wcsdate#' +
date('#tmp_sdura#')">
<cfelseif trim(form.rdo_Assign) is "sta">
<cfx_ingres name="cfqry_Updsche"
db=#Session.cawdbNode# sql="update schedule set pmf_key =
'#ucase(rereplace(tmp_pmf,
start_time='#stdate#',stop
+date('#tmp_dura#'),functi
oth='', conf='#rereplace(tmp_sarea
station='#rereplace(tmp_st
tmp_pprod,"'","''","ALL")#
'#ucase(tmp_spmf)#' and start_time='#wcsdate#' and stop_time
='#wcsdate#' + date('#tmp_sdura#')">
<cfelseif trim(form.rdo_Assign) is "loc">
<cfx_ingres name="cfqry_Updsche"
db=#Session.cawdbNode# sql="update schedule set pmf_key =
'#ucase(rereplace(tmp_pmf,
start_time='#stdate#',stop
+date('#tmp_dura#'),functi
oth='#rereplace(tmp_loc,"'
","''","ALL")#',sessions='
od,"'","''","ALL")#' where uppercase(pmf_key) = '#ucase(tmp_spmf)#' and
start_time='#wcsdate#' and stop_time ='#wcsdate#' +
date('#tmp_sdura#')">
</cfif>
<!--- <cfx_ingres name="cfqry_Updsche"
db=#Session.cawdbNode# sql="update schedule set pmf_key =
'#ucase(rereplace(tmp_pmf,
start_time='#stdate#',stop
date('#tmp_dura#'),functio
th='#rereplace(tmp_loc,"'"
,"''","ALL")#',sessions='#
#rereplace(tmp_sta,"'","''
,"'","''","ALL")#' where uppercase(pmf_key) = '#ucase(tmp_spmf)#' and
start_time='#wcsdate#' and stop_time ='#wcsdate#' +
date('#tmp_sdura#')"> --->
<cfif tmp_pspeak eq "T" and tmp_ses neq '' and
#tmp_funct# eq 'SPEAKER'>
<cfx_ingres name="cfqry_chgupdses"
db=#Session.cawdbNode# sql="update sessions set
primary_speaker='#ucase(re
session_code='#rereplace(t
<cfelseif tmp_pspeak eq "F" and tmp_ses neq '' and
#tmp_funct# eq 'SPEAKER'>
<cfx_ingres name="cfqry_Speak"
db=#Session.cawdbNode# sql="select * from sessions where
primary_speaker = '#ucase(rereplace(tmp_pmf,
session_code='#rereplace(t
<cfif #cfqry_Speak.recordcount# gt 0>
<cfx_ingres name="cfqry_chgupdses"
db=#Session.cawdbNode# sql="update sessions set primary_speaker=''
where session_code='#rereplace(t
</cfif>
</cfif>
<cfif form.hid_Pinfo eq 'T'>
<cfx_ingres name="cfqry_chgupdper"
db=#Session.cawdbNode# sql="update person set
primary_conference='#rerep
tion='#rereplace(tmp_pfunc
a#' where
uppercase(pmf_key)='#ucase
</cfif>
<cfx_ingres name="cfqry_Ssdate" db=#Session.cawdbNode#
sql="select start_time,stop_time from schedule where
start_time='#stdate#' and stop_time = '#stdate#' + date('#tmp_dura#')
and uppercase(pmf_key) = '#ucase(tmp_pmf)#'">
<cfx_ingres name="cfqry_Chgwasis"
db=#Session.cawdbNode# sql="insert into
wasis_log(table_affected,w
y,comments) values
('SCHEDULE','#ucase(rerepl
,'#session.Inventpmfkey#',
'#rereplace(tmp_funct,"'",
'#trim(cfqry_Ssdate.start_
'#trim(cfqry_Ssdate.stop_t
'#tmp_sarea#')">
<cfset msg = 3>
<!--- setting session query to reflect the
changes to the upper frame --->
<cfset clause1 = "schedule.pmf_key =
person.pmf_key and schedule.pmf_key =
'#ucase(rereplace(tmp_pmf,
'#trim(tmp_sarea)#'" >
<cfset clause1 = clause1 & " and
schedule.function = '#rereplace(trim(tmp_funct
<cfset #stdate# = #tmp_date# & ' ' &
#tmp_time#>
<cfset clause1 = clause1 & " and
start_time='#stdate#' and stop_time ='#stdate#' + date('#tmp_dura#')">
<cfif form.rdo_Assign eq 'ses'>
<cfset clause1=clause1 & " and
schedule.sessions = '#rereplace(trim(tmp_ses),
<cfelseif form.rdo_Assign eq 'sta'>
<cfset clause1=clause1 & " and
schedule.station = '#rereplace(trim(tmp_sta),
<cfelseif form.rdo_Assign eq 'loc'>
<cfset clause1 = clause1 & " and
schedule.booth = '#rereplace(trim(tmp_loc),
</cfif>
<!--- <cfset sqlstr =
left(trim(Session.cfqry_Ad
ff)) - 13)>
--->
<cfif len(trim(Form.hid_Query)) gt 0>
<cfset sqlstr =
left(trim(Form.hid_Query),
<cfset sqlstr = sqlstr & ' or (' &
clause1 & ' )' & ' order by 1,5'>
</cfif>
<!--- <cfset sqlstr = sqlstr & ' or (' & clause1 & '
)' & ' order by 1,5'>
<cfset Session.cfqry_AddEditStaff
--->
<script language="JavaScript">
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
</script>
<cfset #form.hid_Smode# = ''>
<cfset #form.hid_Proc# = ''>
</cfif>
<cfelseif form.hid_Smode eq "D">
<!--- checking for alias --->
<cfx_ingres name="cfqry_alias" db=#Session.cawdbNode#
sql="select alias as ses_alias from alias where alias =
'#rereplace(tmp_ses,"'","'
<cfif cfqry_alias.ses_alias neq ''>
<cfset msg = 2>
</cfif>
<!--- delete process starts here --->
<cfif msg neq 2>
<cfset stdate = #tmp_sdate# & ' ' &
#tmp_stime#>
<cfset where_clause = "uppercase(pmf_key) =
'#ucase(rereplace(tmp_spmf
and stop_time ='#stdate#' + date('#tmp_sdura#')">
<cfx_ingres name="cfqry_Delsche"
db=#Session.cawdbNode# sql="delete from schedule where #where_clause#">
<cfx_ingres name="cfqry_Delwasis"
db=#Session.cawdbNode# sql="insert into
wasis_log(table_affected,w
y,comments) values
('SCHEDULE','#ucase(rerepl
,'#session.Inventpmfkey#',
<cfif tmp_pspeak eq "T" and tmp_ses neq '' and
#tmp_funct# eq 'SPEAKER'>
<cfx_ingres name="cfqry_delupdses1"
db=#Session.cawdbNode# sql="update sessions set primary_speaker=''
where session_code='#rereplace(t
primary_speaker='#ucase(re
</cfif>
<cfif cfqry_alias.ses_alias neq ''>
<cfx_ingres name="cfqry_delupdses2"
db=#Session.cawdbNode# sql="update sessions set primary_speaker=''
where session_code='#rereplace(c
and primary_speaker='#ucase(re
</cfif>
<cfset msg = 5>
<cfset form.hid_Smode = ''>
<cfset tmp_pmf = ''>
<cfset tmp_lname = ''>
<cfset tmp_fname = ''>
<cfset form.chk_Pspeak = "F">
<cfset form.chk_Sba ="F">
<cfset tmp_pfunct=''>
<cfset tmp_parea=''>
<cfset tmp_pprod=''>
<cfset tmp_pspeak=''>
</cfif>
</cfif>
<cfif #form.hid_Cmode# neq "">
<cfif Session.Security.Conf_All eq 1>
<cfx_ingres name="cfqry_Loadsarea" db=#Session.cawdbNode#
sql="Select name,uppercase(name) from conferences order by 2">
<cfelse>
<cfx_ingres name="cfqry_Loadsarea" db=#Session.cawdbNode#
sql="Select conference from security where username =
'#session.pmfkey#' and left(conference,4) != 'CWS-' order by 1">
</cfif>
<cfx_ingres name="cfqry_Loadfunct" db=#Session.cawdbNode# sql=
"Select name,uppercase(name) from Function order by 2">
<cfx_ingres name="cfqry_Loadprodcut" db=#Session.cawdbNode#
sql="Select product_code,product,upper
order by 3">
<cfx_ingres name="cfqry_Loadsession" db=#Session.cawdbNode#
sql="Select session_code, uppercase(session_code) from Sessions Where
Conference ='#rereplace(tmp_sarea,"'"
<!--- checking default --->
<cfif (#trim(urldecode(form.hid_
form.hid_Cmode eq 'T') or form.hid_Cmode eq 'SAC'>
<cfx_ingres
name="cfqry_Loadsession1" db=#Session.cawdbNode# sql="Select
session_code, uppercase(session_code) from Sessions Where Conference
='#rereplace(tmp_sarea,"'"
<cfset form.cbo_Assign =
'#urlencodedformat(trim(cf
<cfset form.hid_Defses =
'#urlencodedformat(trim(cf
<cfset tmp_assval =
urldecode(trim(form.cbo_As
<cfset tmp_ses =
urldecode(trim(form.cbo_As
<cfset form.hid_Cmode = 'ASCE'>
</cfif>
<cfx_ingres name="cfqry_Loaddate" db=#Session.cawdbNode#
sql="Select distinct(name),date(name) from ca_world_Dates Order by 2">
<cfx_ingres name="cfqry_Loadtime"
db=#Session.cawdbNode# sql="Select distinct(name) from
session_start_times Order by 1">
<cfx_ingres name="cfqry_Loaddura" db=#Session.cawdbNode#
sql="Select distinct(name) from session_stop_times Order by 1">
</cfif>
<cfif #form.hid_Cmode# eq 'SP'>
<cfset txt_Pmfkey =
Rereplace(#trim(form.txt_P
<cfx_ingres name="cfqry_Check" db=#Session.cawdbNode#
sql="select last_name, first_name ,
pmf_key,primary_function,p
person where uppercase(pmf_key) = '#trim(ucase(txt_Pmfkey))#
<cfif cfqry_Check.recordcount gt 0>
<cfset tmp_Ppmf = trim(cfqry_Check.pmf_key)>
<cfset tmp_lname = trim(cfqry_Check.last_name
<cfset tmp_fname = trim(cfqry_Check.first_nam
<cfif trim(cfqry_Check.sba_relat
<cfset form.chk_Sba = "T">
</cfif>
<cfset tmp_pfunct=trim(cfqry_Chec
<cfset tmp_parea=trim(cfqry_Check
</cfif>
</cfif>
<html>
<head>
<title></title>
<link href="style.css" rel="STYLESHEET" type="TEXT/CSS">
</head>
<body>
<form name="frm_Edtstf" action="Cf_AdEdtstf.cfm" method="post">
<input type="hidden" name="hid_Query"
value="<cfoutput>#trim(For
<script language="JavaScript">
frm_Edtstf.hid_Query.value
</script>
<div align="center"><center>
<table border="0" cellspacing="0" cellpading="0">
<tr>
<!--- loading solution area --->
<cfif session.Security.Conf_All eq 1>
<td>Solution Area<br>
<select name="cbo_Sarea" size="1" style="width:200px"
onchange="cbo_Sarea_onchan
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsarea">
<cfif #trim(tmp_sarea)# eq
#trim(cfqry_Loadsarea.name
<option
value="#urlencodedformat(t
>#trim(cfqry_Loadsarea.nam
<cfelse>
<option
value="#urlencodedformat(t
sarea.name)#</option>
</cfif>
</cfoutput>
</select></td>
<cfelse>
<td>Solution Area<br>
<select name="cbo_Sarea" size="1" style="width:200px"
onchange="cbo_Sarea_onchan
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsarea">
<cfif #trim(tmp_sarea)# eq
#trim(cfqry_Loadsarea.conf
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
y_Loadsarea.conference)#</
</cfif>
</cfoutput>
</select></td>
</cfif>
<cfoutput>
<td>PMF Key<br>
<input type="text" size="20" name="txt_Pmfkey" style="width:90"
value="#urlencodedformat(t
onchange="txt_Pmfkey_oncha
<td>First Name<br>
<input type="text" size="20" name="txt_Firstname"
style="width:125px" value="#urlencodedformat(t
maxlength="20" readonly></td>
<td>Last Name<br>
<input type="text" size="20" name="txt_Lastname"
style="width:150px" value="#urlencodedformat(t
maxlength="16" onchange="txt_Lastname_onc
<td><br>
<input type="button" name="btn_Search" value="Search"
style="width:50px" onclick="btn_Search_onclic
</cfoutput>
</tr>
<tr>
<!--- function loads here --->
<td>Function<br>
<select name="cbo_Funct" size="1" style="width:200px"
onchange="cbo_Funct_onchan
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadfunct">
<cfif #trim(tmp_funct)# eq
#trim(cfqry_Loadfunct.name
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadf
<cfelse>
<option
value="#urlencodedformat(t
funct.name)#</option>
</cfif>
</cfoutput>
</select></td>
<td colspan="2"><p align="center">Assignment<
<!--- Assignment radoi button checked for (session)
--->
<cfif form.rdo_Assign eq 'ses'>
<input type="radio" name="rdo_Assign" value="ses"
checked onclick="rdo_onclick()" >Session
<input type="radio" name="rdo_Assign"
value="sta" onclick="rdo_onclick()">St
<input type="radio" name="rdo_Assign"
value="loc" onclick="rdo_onclick()"> Location</p>
<!--- Assignment radoi button checked for (session) --->
<cfelseif form.rdo_Assign eq 'sta'>
<input type="radio" name="rdo_Assign" value="ses"
onclick="rdo_onclick()" >Session
<input type="radio" name="rdo_Assign"
value="sta" checked onclick="rdo_onclick()">St
<input type="radio" name="rdo_Assign"
value="loc" onclick="rdo_onclick()"> Location</p>
<!--- Assignment radoi button checked for (session)
--->
<cfelseif form.rdo_Assign eq 'loc'>
<input type="radio" name="rdo_Assign" value="ses"
onclick="rdo_onclick()" >Session
<input type="radio" name="rdo_Assign"
value="sta" onclick="rdo_onclick()">St
<input type="radio" name="rdo_Assign"
value="loc" checked onclick="rdo_onclick()"> Location</p>
</cfif>
</td>
<!--- Assignment list loading for session --->
<cfif form.rdo_Assign eq 'ses'>
<cfif #form.hid_Cmode# eq 'ASC' or
#form.hid_Cmode# eq 'ASCE' >
<cfset tmp_ses =
trim(URLdecode(form.cbo_As
<cfset tmp_assval =
trim(URLdecode(form.cbo_As
<cfx_ingres name="cfqry_alias"
db=#Session.cawdbNode# sql="select alias as ses_alias from alias where
alias = '#rereplace(tmp_ses,"'","'
<cfif trim(cfqry_alias.ses_alias
''>
<cfset msg = 1>
<cfset tmp_assval = form.hid_Ass>
<cfelse>
<cfset form.hid_Ass = tmp_assval>
</cfif>
<cfx_ingres name="cfqry_sesdate"
db=#Session.cawdbNode# sql="Select
start_date,stop_date,stop_
Session_code ='#rereplace(tmp_assval,"'
<cfset tmp_date =
left(trim(cfqry_sesdate.st
<cfset tmp_time =
left(right(trim(cfqry_sesd
<cfset tmp_dura =
trim(cfqry_sesdate.dura)>
</cfif>
<td colspan="2"><br>
<select name="cbo_Assign" size="1"
style="width:150px" onchange="cbo_Assign_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsession">
<cfif #trim(tmp_assval)# eq
#trim(cfqry_Loadsession.se
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
cfqry_Loadsession.session_
</cfif>
</cfoutput>
</select></td>
<!--- Assignment list loading for station
--->
<cfelseif form.rdo_Assign eq 'sta'>
<cfx_ingres name="cfqry_Loadstation"
db=#Session.cawdbNode# sql="Select stationid,uppercase(statio
station where conference ='#rereplace(tmp_sarea,"'"
by 2">
<td colspan="2"><br>
<select name="cbo_Assign" size="1" style="width:150px"
onchange="cbo_Assign_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadstation">
<cfif #trim(tmp_assval)# eq
#trim(cfqry_Loadstation.st
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
ry_Loadstation.stationid)#
</cfif>
</cfoutput>
</select></td>
<!--- Assignment list loading for station --->
<cfelseif form.rdo_Assign eq 'loc'>
<cfx_ingres name="cfqry_Loadbooth"
db=#Session.cawdbNode# sql="Select name,uppercase(name) from booth
where conf = '#rereplace(tmp_sarea,"'",
<td colspan="2"><br>
<select name="cbo_Assign" size="1" style="width:150px"
onchange="cbo_Assign_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadbooth">
<cfif #trim(tmp_assval)# eq
#trim(cfqry_Loadbooth.name
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadb
<cfelse>
<option
value="#urlencodedformat(t
booth.name)#</option>
</cfif>
</cfoutput>
</select></td>
</cfif>
</tr>
<tr>
<!--- Primary function list loading --->
<td>Primary Function<br>
<select name="cbo_Pfunct" size="1" style="width:200px"
onchange="cbo_Pfunct_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadfunct">
<cfif #trim(tmp_pfunct)# eq
#trim(cfqry_Loadfunct.name
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadf
<cfelse>
<option
value="#urlencodedformat(t
funct.name)#</option>
</cfif>
</cfoutput>
</select></td>
<!--- Primary solution list loading --->
<td colspan="2">Primary Solution Area<br>
<cfif session.Security.Conf_All eq 1>
<select name="cbo_Psarea" size="1"
style="width:200px" onchange="cbo_Psarea_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsarea">
<cfif #trim(tmp_parea)# eq
#trim(cfqry_Loadsarea.name
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
sarea.name)#</option>
</cfif>
</cfoutput>
</select>
<cfelse>
<select name="cbo_Psarea" size="1"
style="width:200px" onchange="cbo_Psarea_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsarea">
<cfif #trim(tmp_parea)# eq
#trim(cfqry_Loadsarea.conf
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
y_Loadsarea.conference)#</
</cfif>
</cfoutput>
</select>
</cfif></td>
<!--- Primary product list loading --->
<td colspan="2">Primary Product<br>
<select name="cbo_Pprod" size="1" style="width:250px">
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadprodcut">
<cfif #trim(tmp_pprod)# eq
#trim(cfqry_Loadprodcut.pr
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadp
<cfelse>
<option
value="#urlencodedformat(t
cfqry_Loadprodcut.product)
</cfif>
</cfoutput>
</select></td>
<td> </td>
</tr>
<tr> <!--- checking for primary speaker --->
<cfif form.chk_Pspeak eq "T">
<td><input type="checkbox" name="chk_Pspeak"
checked value="T">Primary Speaker</td>
<cfelse>
<td><input type="checkbox" name="chk_Pspeak"
value="T">Primary Speaker</td>
</cfif>
<!--- checking for sba relationship --->
<cfif form.chk_Sba eq "T">
<td><input type="checkbox" name="chk_Sba"
value="T" checked onclick="chk_Sba_onclick()
<cfelse>
<td><input type="checkbox" name="chk_Sba"
value="T" onclick="chk_Sba_onclick()
</cfif>
<td> </td>
<td> </td>
</tr>
<tr>
<cfif form.rdo_Assign eq 'ses'>
<cfif #form.hid_Proc# eq 'AT'>
<cfset tmp_date =
trim(form.hid_Sldate)>
<cfset tmp_time =
trim(form.hid_Sltime)>
<cfset tmp_dura =
trim(form.hid_Sldura)>
</cfif>
<cfoutput>
<td>Date<br><input type="text" name="cbo_Date"
size="1" style="width:80px"
value="#dateformat(trim(tm
<td>Time<br><input type="text" name="cbo_Time"
size="1" style="width:55px" value="#trim(tmp_time)#" readonly></td>
<td>Duration<br><input type="text" name="cbo_Dura"
size="1" style="width:100px" value="#trim(tmp_dura)#" readonly></td>
</cfoutput>
<cfelse>
<!--- loading date list --->
<td>Date<br>
<select name="cbo_Date" size="1"
style="width:80px">
<option value="Select">(Select)</o
<cfoutput query="cfqry_Loaddate">
<cfif #trim(tmp_date)# eq
#trim(cfqry_Loaddate.name)
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadd
<cfelse>
<option
value="#urlencodedformat(t
ate.name)#</option>
</cfif>
</cfoutput>
</select></td>
<!--- loading time list --->
<td>Time<br>
<select name="cbo_Time" size="1" style="width:55px">
<option value="Select">(Select)</o
<cfoutput query="cfqry_Loadtime">
<cfif #trim(tmp_time)# eq
#trim(cfqry_Loadtime.name)
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadt
<cfelse>
<option
value="#urlencodedformat(t
ime.name)#</option>
</cfif>
</cfoutput>
</select></td>
<!--- loading duration list --->
<td>Duration<br>
<select name="cbo_Dura" size="1" style="width:100px">
<option value="Select">(Select)</o
<cfoutput query="cfqry_Loaddura">
<cfif #trim(tmp_dura)# eq
#trim(cfqry_Loaddura.name)
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadd
<cfelse>
<option
value="#urlencodedformat(t
ura.name)#</option>
</cfif>
</cfoutput>
</select></td>
</cfif>
<td> </td>
<td> </td>
</tr>
</table>
</center></div><div align="center"><center>
<table border="0">
<tr>
<td><input type="button" name="btn_Add" value="Add"
style="width:50px" onclick="btn_Add_onclick()
<td><input type="button" name="btn_Change" value="Change"
style="width:50px" onclick="btn_Change_onclic
<td><input type="button" name="btn_Delete" value="Delete"
style="width:50px"onclick=
<td><input type="button" name="btn_Close" value="Close"
style="width:50px" onclick="btn_Close_onclick
<td><input type="button" name="btn_Home" value="Home"
style="width:50px" onclick="btn_Home_onclick(
</tr>
</table>
<cfoutput>
<input type = "hidden" name = "hid_Logcheck" value = "0">
<input type="hidden" name="hid_Search" value="False">
<input type="hidden" name="hid_Cmode" value="#form.hid_Cmode#">
<input type="hidden" name="hid_Pinfo" value="#form.hid_Pinfo#">
<input type="hidden" name="hid_Ass" value="#form.hid_Ass#">
<input type="hidden" name="hid_Smode" value="">
<input type="hidden" name="hid_Source" value="#form.hid_Source#">
<input type="hidden" name="hid_Source1" value="#form.hid_Source1#"
<input type="hidden" name="hid_Proc" value="#form.hid_Proc#">
<input type="hidden" name="hid_Addedit" value="#hid_Addedit#">
<input type="hidden" name="hid_Stoptime"
value="#dateformat(urldeco
<!--- <input type="hidden" name="hid_Stoptime" value="##"> --->
<input type="hidden" name="hid_Sdate" value="#tmp_sdate#">
<input type="hidden" name="hid_Stime" value="#tmp_stime#">
<input type="hidden" name="hid_Sdura" value="#tmp_sdura#">
<input type="hidden" name="hid_Spmf" value="#tmp_spmf#">
<input type="hidden" name="hid_Sassign" value="#tmp_sassign#">
<input type="hidden" name="hid_Sassignval"
value="#urlencodedformat(t
<input type="hidden" name="hid_Sldate" value="#tmp_date#">
<input type="hidden" name="hid_Sltime" value="#tmp_time#">
<input type="hidden" name="hid_Sldura" value="#tmp_dura#">
<input type="hidden" name="hid_Slpmf" value="#tmp_pmf#">
<input type="hidden" name="hid_valass" value="">
<input type="hidden" name="hid_Defsarea"
value="#urlencodedformat(f
<input type="hidden" name="hid_Defses"
value="#urlencodedformat(f
<input type="hidden" name="hid_Count"
value="#urlencodedformat(f
<!--- Added by Sheeba(4 hidden)--->
<input type="hidden" name="tmp_Solnarea" >
<input type="hidden" name="hid_Calledfrm" >
<input type = "hidden" name = "cbo_Track">
<input type = "hidden" name = "tmp_Pmfkey">
</cfoutput>
</center></div>
<p> </p>
</form>
</body>
</html>
<cfif parameterexists(url.hid_So
<script language = "javascript">
frm_Edtstf.tmp_Solnarea.va
="<cfoutput>#url.tmp_Solna
frm_Edtstf.hid_Calledfrm.v
"<cfoutput>#url.hid_Called
frm_Edtstf.cbo_Track.value
"<cfoutput>#url.cbo_Track#
frm_Edtstf.hid_Source.valu
"<cfoutput>#url.hid_Source
frm_Edtstf.tmp_Pmfkey.valu
"<cfoutput>#url.tmp_Pmfkey
</script>
<cfelseif parameterexists(form.tmp_S
<script language = "javascript">
frm_Edtstf.tmp_Solnarea.va
"<cfoutput>#urlencodedform
frm_Edtstf.hid_Calledfrm.v
"<cfoutput>#urlencodedform
frm_Edtstf.cbo_Track.value
"(<cfoutput>#urlencodedfor
frm_Edtstf.tmp_Pmfkey.valu
"<cfoutput>#urlencodedform
</script>
<cfelseif parameterexists(form.cbo_S
<script language = "javascript">
frm_Edtstf.tmp_Solnarea.va
"<cfoutput>#urlencodedform
frm_Edtstf.cbo_Track.value
"<cfoutput>#urlencodedform
</script>
</cfif>
<script language="javascript">
frm_Edtstf.txt_Pmfkey.valu
frm_Edtstf.txt_Firstname.v
unescape(frm_Edtstf.txt_Fi
frm_Edtstf.txt_Lastname.va
unescape(frm_Edtstf.txt_La
frm_Edtstf.hid_Calledfrm.v
unescape(frm_Edtstf.hid_Ca
frm_Edtstf.hid_Sassignval.
unescape(frm_Edtstf.hid_Sa
</script>
<!--- Retainnig primary speaker check box value --->
<script language="javascript">
var str
str=ltrim(rtrim(unescape(f
if(str.toUpperCase() == "SPEAKER")
{
frm_Edtstf.chk_Pspeak.disa
}
else
{
frm_Edtstf.chk_Pspeak.chec
frm_Edtstf.chk_Pspeak.valu
frm_Edtstf.chk_Pspeak.disa
}
</script>
<!--- Setting focus to controls --->
<cfif form.hid_Cmode eq 'ATC' or form.hid_Cmode eq 'ALC'>
<script language="javascript">
frm_Edtstf.cbo_Assign.focu
</script>
<cfelseif form.hid_Cmode eq 'ASC' or form.hid_Cmode eq 'Staff'>
<script language="javascript">
frm_Edtstf.cbo_Assign.focu
</script>
<cfelseif form.hid_Cmode eq 'SAC'>
<script language="javascript">
frm_Edtstf.cbo_Sarea.focus
</script>
<cfelseif form.hid_Cmode eq 'AC'>
<script language="javascript">
if (frm_Edtstf.cbo_Date.type == "text")
{
frm_Edtstf.cbo_Date.text = ""
frm_Edtstf.cbo_Time.text = ""
frm_Edtstf.cbo_Dura.text = ""
}
else
{
frm_Edtstf.cbo_Date.select
frm_Edtstf.cbo_Time.select
frm_Edtstf.cbo_Dura.select
}
frm_Edtstf.cbo_Assign.focu
</script>
<cfelseif #form.hid_Cmode# eq 'SP'>
<script language="javascript">
window.focus()
frm_Edtstf.btn_Search.focu
</script>
</cfif>
<!--- Confirmation messages given --->
<cfif msg eq 1>
<cfif form.hid_Cmode eq 'ASC'>
<script language="javascript">
Err_msg(248)
frm_Edtstf.cbo_Assign.focu
</script>
</cfif>
<cfelseif msg eq 4>
<!--- <cfif form.hid_Source eq "Staff"> --->
<script language="javascript">
document.frm_Edtstf.hid_Ad
parent.Topform.document.fr
//parent.Topform.document.
parent.Topform.document.fr
parent.Topform.document.fr
'<cfoutput>#urlencodedform
frm_Edtstf.hid_Query.value
'<cfoutput>#urlencodedform
parent.Topform.document.fr
=unescape(parent.Topform.d
frm_Edtstf.hid_Query.value
parent.Topform.document.fr
</script>
<cfelseif msg eq 3>
<!--- <cfif form.hid_Source eq "Staff"> --->
<script language="javascript">
document.frm_Edtstf.hid_Ad
parent.Topform.document.fr
//parent.Topform.document.
parent.Topform.document.fr
parent.Topform.document.fr
='<cfoutput>#urlencodedfor
frm_Edtstf.hid_Query.value
'<cfoutput>#urlencodedform
parent.Topform.document.fr
=unescape(parent.Topform.d
frm_Edtstf.hid_Query.value
parent.Topform.document.fr
</script>
<cfelseif msg eq 2>
<script language="javascript">
Err_msg(248)
frm_Edtstf.cbo_Assign.focu
</script>
<cfelseif msg eq 5>
<cfif form.hid_Source eq "Staff">
<script language="javascript">
parent.Topform.document.fr
parent.Topform.document.fr
'DR'
parent.Topform.document.fr
= 0
parent.Topform.document.fr
</script>
<cfelse>
<script language="javascript">
frm_Edtstf.cbo_Sarea.focus
</script>
</cfif>
</cfif>
<cfif form.hid_Proc eq 'AT'>
<script language="javascript">
var str = "<cfoutput>#warning#</cfou
conflict)";
str = str + "\n Would you like to schedule this person given
the time considerations?"
if(confirm(str))
{
frm_Edtstf.hid_Proc.value = "ATY"
frm_Edtstf.hid_Cmode.value
ALC
frm_Edtstf.hid_Smode.value
frm_Edtstf.submit()
}
else
{
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Proc.value = ""
frm_Edtstf.hid_Cmode.value
frm_Edtstf.cbo_Sarea.focus
}
</script>
<cfelseif form.hid_Proc eq 'CT'>
<script language="javascript">
var str = "<cfoutput>#warning#</cfou
conflict)";
str = str + "\n Would you like to schedule this person given
the time considerations?"
if(confirm(str))
{
frm_Edtstf.hid_Proc.value = "CTY"
frm_Edtstf.hid_Cmode.value
ALC
frm_Edtstf.hid_Smode.value
frm_Edtstf.submit()
}
else
{
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Proc.value = ""
frm_Edtstf.cbo_Sarea.focus
}
</script>
<cfelseif form.hid_Proc eq 'ATD'>
<script language="javascript">
var str = "<cfoutput>#warning#</cfou
alert(str + " ( This is a direct conflict )");
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Proc.value = ""
frm_Edtstf.cbo_Sarea.focus
</script>
<cfelseif form.hid_Proc eq 'CTD'>
<script language="javascript">
var str = "<cfoutput>#warning#</cfou
alert(str + " ( This is a direct conflict )");
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Proc.value = ""
frm_Edtstf.cbo_Sarea.focus
</script>
</cfif>
<cfif session.Security.Conf eq 2>
<script language="javascript">
frm_Edtstf.btn_Delete.disa
</script>
</cfif>
<cfif form.hid_Source1 eq 'Sessionmgmt'>
<!--- <script language="javascript">
frm_Edtstf.btn_Delete.disa
frm_Edtstf.btn_Change.disa
</script> --->
</cfif>
</cfif>
Top Frame
*********
<cftry>
<cfparam name="form.hid_selsarea" default = "">
<cfparam name="form.hid_Src" default = "0">
<cfparam name="form.hid_Count" default="0">
<cfparam name="hid_Addedit" default="">
<cfparam name="cfqry_Result.RecordC
<cfparam name="Form.hid_Query" default="">
<cfparam name="hid_Pk" default="">
<cfparam name="hid_Sa" default="">
<cfparam name="hid_Ft" default="">
<cfparam name="hid_Fun" default="">
<cfparam name="hid_Sd" default="">
<cfparam name="hid_St" default="">
<cfparam name="hid_Sdu" default="">
<cfset tmp_Pk = trim(urldecode(hid_Pk))>
<cfset tmp_Sa = trim(urldecode(hid_Sa))>
<cfset tmp_Fun = trim(urldecode(hid_Fun))>
<cfset cflag='F'>
<cfset session.Addedit = "A">
<cfset FORM.hid_selsarea = #hid_selsarea#>
<html>
<head>
<title></title>
<link href="style.css" rel="STYLESHEET" type="TEXT/CSS">
</head>
<body>
<form name="frm_Addedittop" onload="frm_onload()" action="cf_AddEditstf.cfm"
<div align="center"><center>
<table border="1">
<tr>
<td colspan="13"><p align="center"><font size="4"><strong>Add
/ Edit Staff</strong></font><br>
</p>
</td>
</tr>
<tr>
<td><table border="0">
<tr>
<td> </td>
<td valign="top" nowrap><strong>Pmf Key</strong></td>
<td> </td>
<td valign="top" nowrap><strong>Last Name</strong></td>
<td> </td>
<td valign="top" nowrap><strong>First Name</strong></td>
<td> </td>
<td valign="top" nowrap><strong>Solution Area</strong></td>
<td> </td>
<td valign="top"><strong>Funct
<td> </td>
<td valign="top" nowrap><strong>Date</stron
<td> </td>
<td valign="top"><strong>Time<
<td> </td>
<td valign="top"><strong>Durat
<td> </td>
<td valign="top"><strong>Assig
</tr>
<cfif #hid_Addedit# neq "ADD">
<!--- <script language="JavaScript">
parent.Bottomform.document
</script> --->
<cfif #hid_Addedit# eq "EDIT">
<cfif parameterexists(Session.cf
<!--- <cfset Session.cfqry_AddEditStaff
<cfset Form.hid_Query = Session.cfqry_Staff>
<!--- <cfoutput>#Form.hid_Query#
</cfif>
<!--- <script language="JavaScript">
parent.Bottomform.document
</script> --->
</cfif>
<!--- <cfif isdefined("Session.cfqry_A
<cfif #Form.hid_Query# neq "">
<!--- Executing session qyery to load all values to new query --->
<!--- <cfx_ingres name="cfqry_Result" db=#Session.cawdbNode# sql= #Session.cfqry_AddEditStaf
<cfx_ingres name="cfqry_Result" db=#Session.cawdbNode# sql=#Form.hid_Query#>
<cfset cfqry_Resultnew = QueryNew("pmf_key,last_nam
<cfoutput query = "cfqry_Result">
<cfset cflag = 'F'>
<cfif #trim(hid_Ft)# eq 'ses'>
<cfif #trim(cfqry_Result.session
<cfset cflag = 'T'>
</cfif>
<cfelseif #trim(hid_Ft)# eq 'sta'>
<cfif #trim(cfqry_Result.station
<cfset cflag = 'T'>
</cfif>
<cfelseif #trim(hid_Ft)# eq 'loc'>
<cfif #trim(cfqry_Result.booth)#
<cfset cflag = 'T'>
</cfif>
</cfif>
<!--- (#trim(tmp_Pk)# neq #trim(cfqry_Result.pmf_key
<cfif (trim(tmp_Pk) neq trim(cfqry_Result.pmf_key)
<cfx_ingres name="cfqry_Primary" db=#Session.cawdbNode# sql="select primary_conference,primary
<cfx_ingres name="cfqry_Product" db=#Session.cawdbNode# sql="select schedule.product_code as product_code, productmaster.product as product from schedule,productmaster where schedule.pmf_key ='#trim(cfqry_Result.pmf_k
<cfset temp = QueryAddRow(cfqry_Resultne
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfif #trim(cfqry_Result.session
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfx_ingres name="cfqry_Spaeak" db=#Session.cawdbNode# sql="select * from sessions where primary_speaker = '#trim(cfqry_Result.pmf_ke
<cfif #cfqry_Spaeak.recordcount#
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfelseif #trim(cfqry_Result.station
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelseif #trim(cfqry_Result.booth)#
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfif #cfqry_Product.recordcount
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfif #hid_Addedit# eq "ADT">
<cfset pmf_key_temp =trim(cfqry_Result.pmf_key
<cfset last_name_temp = trim(cfqry_Result.last_nam
<cfset first_name_temp = trim(cfqry_Result.first_na
<cfset Conf_temp = trim(cfqry_Result.Conf)>
<cfset function_temp = trim(cfqry_Result.function
<cfset start_time_temp = trim(cfqry_Result.start_ti
<cfset stop_time_temp = trim(cfqry_Result.stop_tim
<cfset Duration_temp = trim(cfqry_Result.Duration
<cfset Sessions_temp = trim(cfqry_Result.sessions
<cfset Station_temp = trim(cfqry_Result.station)
<cfset Booth_temp =trim(cfqry_Result.booth)>
<cfset tid_temp = trim(cfqry_Result.tid)>
</cfif>
</cfif>
</cfoutput>
<cfif #hid_Addedit# eq "ADT">
<cfif Parameterexists(pmf_key_te
<cfset cflag = 'F'>
<cfif #trim(hid_Ft)# eq 'ses'>
<cfif #trim(Sessions_temp)# eq trim(tmp_Fun)>
<cfset cflag = 'T'>
</cfif>
<cfelseif #trim(hid_Ft)# eq 'sta'>
<cfif #trim(Station_temp)# eq trim(tmp_Fun)>
<cfset cflag = 'T'>
</cfif>
<cfelseif #trim(hid_Ft)# eq 'loc'>
<cfif #trim(Booth_temp)# eq trim(tmp_Fun)>
<cfset cflag = 'T'>
</cfif>
</cfif>
<cfx_ingres name="cfqry_Primary" db=#Session.cawdbNode# sql="select primary_conference,primary
<cfx_ingres name="cfqry_Product" db=#Session.cawdbNode# sql="select schedule.product_code as product_code, productmaster.product as product from schedule,productmaster where schedule.start_time = '#trim(start_time_temp)#' and schedule.stop_time = '#trim(stop_time_temp)#' and schedule.product_code = productmaster.product_code
<cfset temp = QueryAddRow(cfqry_Resultne
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfif #trim(Sessions_temp)# neq ''>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfx_ingres name="cfqry_Spaeak" db=#Session.cawdbNode# sql="select * from sessions where primary_speaker = '#trim(pmf_key_temp)#' and session_code ='#trim(Sessions_temp)#'">
<cfif #cfqry_Spaeak.recordcount#
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfelseif #trim(Station_temp)# neq ''>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelseif #trim(Booth_temp)# neq ''>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfset temp = QuerySetCell(cfqry_Resultn
<cfif #cfqry_Product.recordcount
<cfset temp = QuerySetCell(cfqry_Resultn
<cfelse>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
<cfset temp = QuerySetCell(cfqry_Resultn
</cfif>
</cfif>
<!--- Holding selected values in relevant Hidden variables --->
<cfoutput query = "cfqry_Resultnew">
<tr align="left">
<td><input type="radio" name="rad_Select" onclick="rad_Select_Onclic
<td>#cfqry_Resultnew.pmf_k
<input type = "hidden" name = "hid_Pmfkey" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td>#cfqry_Resultnew.last_
<input type = "hidden" name = "hid_Lastname" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td>#cfqry_Resultnew.first
<input type = "hidden" name = "hid_Firstname" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td>#cfqry_Resultnew.Conf#
<input type = "hidden" name = "hid_Conf" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td>#cfqry_Resultnew.funct
<input type = "hidden" name = "hid_Function" value = "#urlencodedformat(trim(cf
</td>
<td> </td>
<td nowrap>#left(trim(cfqry_Re
<input type = "hidden" name = "hid_Date" value = "#urlencodedformat(datefor
</td>
<td> </td>
<td nowrap>#left(right(trim(cf
<input type = "hidden" name = "hid_Time" value = "#urlencodedformat(left(ri
</td>
<td> </td>
<td nowrap>#cfqry_Resultnew.Du
<input type = "hidden" name = "hid_Dura" value = "#urlencodedformat(cfqry_R
</td>
<td> </td>
<td>#cfqry_Resultnew.Assig
<input type = "hidden" name = "hid_Stoptime" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Assignval" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Assign" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Pfunct" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Psarea" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Speak" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Sba" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_Pprod" value = "#urlencodedformat(trim(cf
<input type = "hidden" name = "hid_tid" value = "#trim(cfqry_Resultnew.tid
</td>
</cfoutput>
<cfelse>
<cfset cfqry_Result.RecordCount = 0>
</cfif>
</cfif>
<CFCATCH TYPE="Any">
<H1>Other Error: #CFCATCH.Type#</H1>
<CFOUTPUT>
<UL>
<LI><B>Message:</B> #CFCATCH.message#
<LI><B>Detail:</B> #CFCATCH.Detail#
</UL>
</CFOUTPUT>
</CFCATCH>
</CFTRY>
<!--- <cfcatch type="any">
<cfset CommitThis=FALSE>
</cfcatch>
</cftry> --->
</table>
</td>
</tr>
<!---
<tr>
<td align="center"><input type="button" name="btn_ok"
value=" OK "> <input type="button" name="btn_cancel"
value=" Cancel "></td>
</tr> --->
</table>
<cfoutput>
<input type = "hidden" name = "hid_Src" value = "#form.hid_Src#">
<input type = "hidden" name = "hid_Count" value = "#form.hid_Count#">
<input type = "hidden" name = "hid_Addedit" value = "#hid_Addedit#">
<input type = "hidden" name = "hid_Pk" value = "#hid_Pk#">
<input type = "hidden" name = "hid_Sa" value = "#hid_Sa#">
<input type = "hidden" name = "hid_Ft" value = "#hid_Ft#">
<input type = "hidden" name = "hid_Fun" value = "#hid_Fun#">
<input type = "hidden" name = "hid_Sd" value = "#hid_Sd#">
<input type = "hidden" name = "hid_St" value = "#hid_St#">
<input type = "hidden" name = "hid_Sdu" value = "#hid_Sdu#">
<input type="Hidden" name="hid_Query" value="#urlencodedformat(F
</cfoutput>
<script language="JavaScript">
frm_Addedittop.hid_Query.v
</script>
</center></div>
<p> </p>
<p> </p>
</from>
</body>
</html>
<script language = "javascript">
function rad_Select_Onclick()
{
parent.Bottomform.document
var count=<cfoutput>#cfqry_Res
if (count == 1)
{
if (document.frm_Addedittop.r
{
Reassigncnt1();
if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
parent.Bottomform.document
document.frm_Addedittop.hi
parent.Bottomform.document
parent.Bottomform.document
}
}
if (count > 1)
{
for (i=0;i<count;i++)
{
if (document.frm_Addedittop.r
{
Reassign(i);
if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
parent.Bottomform.document
//document.frm_Addedittop.
document.frm_Addedittop.hi
parent.Bottomform.document
parent.Bottomform.document
}
}
}
}
function Reassign(i)
{
var count= "";
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
//parent.Bottomform.docume
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
}
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else
{
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if(unescape(parent.Bottomf
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
if (document.frm_Addedittop.h
{
parent.Bottomform.document
}
else
{
parent.Bottomform.document
}
if (document.frm_Addedittop.h
{
parent.Bottomform.document
}
else
{
parent.Bottomform.document
}
} // end of function
function Reassigncnt1()
{
var count= "";
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
}
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else
{
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
parent.Bottomform.document
break;
}
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (parent.Bottomform.documen
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
count=parent.Bottomform.do
for (j=1;j<count ;j++)
{
if (unescape(parent.Bottomfor
{
parent.Bottomform.document
break;
}
else
{
parent.Bottomform.document
}
}
if (document.frm_Addedittop.h
{
parent.Bottomform.document
}
else
{
parent.Bottomform.document
}
if (document.frm_Addedittop.h
{
parent.Bottomform.document
}
else
{
parent.Bottomform.document
}
}
function clear()
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
if(document.frm_Addedittop
{
var counter=<cfoutput>#cfqry_R
if (counter == 1)
{
Reassigncnt1()
document.frm_Addedittop.ra
if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
parent.Bottomform.document
document.frm_Addedittop.hi
parent.Bottomform.document
parent.Bottomform.document
}
if (counter > 1)
{
// var i = document.frm_Addedittop.hi
var i=0;
for (n=0;n < document.frm_Addedittop.hi
{
if (document.frm_Addedittop.h
{
i = n;
break ;
}
}
Reassign(i)
document.frm_Addedittop.ra
if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
else if ((document.frm_Addedittop.
{
parent.Bottomform.document
parent.Bottomform.document
parent.Bottomform.document
}
parent.Bottomform.document
document.frm_Addedittop.hi
parent.Bottomform.document
parent.Bottomform.document
}
}
</script>
**************************
Bottom Frame
************
<cfparam name="form.hid_Source" default="">
<cfset flag = "T">
<cfif form.hid_Source eq 'Sessionmgmt'>
<cfif parameterexists(hid_Logche
<cfset flag = "T">
<cfelse>
<cfset flag = "F">
<cfoutput>
<script>
alert("Incorrect login");
self.location="../Travel&T
</script>
</cfoutput>
</cfif>
</cfif>
<cfif flag eq "T">
<cfinclude template="../cf_Errpage.cf
<cfparam name="form.hid_CMode" default="T">
<cfparam name="form.hid_SMode" default="">
<cfparam name="form.hid_Ass" default="">
<cfparam name="form.hid_valass" default="">
<cfparam name="form.rdo_Assign" default="ses">
<cfparam name="form.chk_Pspeak" default="F">
<cfparam name="form.chk_Sba" default="F">
<cfparam name="form.hid_Pinfo" default="F">
<cfparam name="form.hid_Proc" default="F">
<cfparam name="form.hid_Stoptime" default="">
<cfparam name="form.hid_Source1" default="">
<cfparam name="form.hid_Defsarea" default="">
<cfparam name="form.hid_Defses" default="">
<cfparam name="hid_Addedit" default="">
<cfparam name="url.tmp_Pmfkey" default="">
<cfparam name="Form.hid_Query" default="">
<!--- Temporary variable declaration part --->
<cfset msg = 0>
<cfset tmp_ses = ''>
<cfset tmp_sta = ''>
<cfset tmp_loc = ''>
<cfset counter = 0>
<cfset tmp_pmf=''>
<cfset tmp_sarea=''>
<cfset tmp_fname=''>
<cfset tmp_lname=''>
<cfset tmp_funct='SPEAKER'>
<cfset tmp_ass=''>
<cfset tmp_assval=''>
<cfset tmp_pfunct=''>
<cfset tmp_parea=''>
<cfset tmp_pprod=''>
<cfset tmp_pspeak=''>
<cfset tmp_sba=''>
<cfset tmp_date=''>
<cfset tmp_time=''>
<cfset tmp_dura=''>
<cfset tmp_sdate=''>
<cfset tmp_stime=''>
<cfset tmp_sdura=''>
<cfset tmp_spmf=''>
<cfset warning=''>
<cfset tmp_sassign=''>
<cfset tmp_sassignval=''>
<cfset ass_flag='F'>
<cfparam name="form.hid_Count" default="0">
<!--- Temporary variable declaration part ends here--->
<script language="JavaScript">
function cbo_Sarea_onchange()
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
function cbo_Assign_onchange()
{
if (frm_Edtstf.rdo_Assign[0].
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
else if(frm_Edtstf.rdo_Assign[1
{
frm_Edtstf.hid_Cmode.value
}
else if(frm_Edtstf.rdo_Assign[2
{
frm_Edtstf.hid_Cmode.value
}
//frm_Edtstf.submit()
}
function cbo_Pfunct_onchange()
{
frm_Edtstf.hid_Pinfo.value
}
function cbo_Psarea_onchange()
{
frm_Edtstf.hid_Pinfo.value
}
function chk_Sba_onclick()
{
frm_Edtstf.hid_Pinfo.value
}
function cbo_Funct_onchange()
{
var str
str=ltrim(rtrim(unescape(f
if(str.toUpperCase() == "SPEAKER")
{
frm_Edtstf.chk_Pspeak.disa
}
else
{
frm_Edtstf.chk_Pspeak.chec
frm_Edtstf.chk_Pspeak.valu
frm_Edtstf.chk_Pspeak.disa
}
}
function btn_Search_onclick()
{
if (frm_Edtstf.txt_Pmfkey.val
frm_Edtstf.txt_Lastname.va
{
Err_msg(199)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if (frm_Edtstf.txt_Pmfkey.val
frm_Edtstf.txt_Lastname.va
{
frm_Edtstf.hid_Search.valu
Pmfkey_Search()
}
if (frm_Edtstf.txt_Pmfkey.val
frm_Edtstf.txt_Lastname.va
{
frm_Edtstf.hid_Search.valu
//frm_Edtstf.txt_Firstname
Lastname_Search()
}
if (frm_Edtstf.txt_Pmfkey.val
frm_Edtstf.txt_Lastname.va
{
frm_Edtstf.hid_Search.valu
Pmfkey_Search()
}
}
function txt_Pmfkey_onchange()
{
frm_Edtstf.txt_Lastname.va
frm_Edtstf.txt_Firstname.v
}
function txt_Lastname_onchange()
{
frm_Edtstf.txt_Pmfkey.valu
frm_Edtstf.txt_Firstname.v
}
function rdo_onclick()
{
if(frm_Edtstf.rdo_Assign[0
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
else
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
}
function Pmfkey_Search() // Pmfkey Search
{
ret=window.open("Person.cf
lue)+"&FormNm=frm_Edtstf&L
txt_Pmfkey", "NewWind",
"left=50,top=50,height=500
,scrollbars=yes")
}
function Lastname_Search() // Lastname Search
{
ret=window.open("Person.cf
.value)+"&FormNm=frm_Edtst
t=txt_Lastname", "NewWind",
"left=50,top=50,height=500
,scrollbars=yes,locationba
}
function ltrim(argvalue)
{
while (1) {
if (argvalue.substring(0, 1) != "")
break;
argvalue = argvalue.substring(1, argvalue.length);
}
return argvalue;
}
function rtrim(argvalue)
{
while (1) {
if (argvalue.substring(argval
break;
argvalue = argvalue.substring(0, argvalue.length - 1);
}
return argvalue;
}
function btn_Add_onclick()
{
frm_Edtstf.hid_Query.value
uery.value
if(frm_Edtstf.txt_Pmfkey.v
{
Err_msg(244)
frm_Edtstf.txt_Pmfkey.focu
return false
}
else if(frm_Edtstf.cbo_Funct.va
{
Err_msg(245)
frm_Edtstf.cbo_Funct.focus
return false
}
else if (frm_Edtstf.cbo_Assign.val
{
Err_msg(246)
frm_Edtstf.cbo_Assign.focu
return false
}
if(frm_Edtstf.txt_Pmfkey.v
frm_Edtstf.txt_Firstname.v
== "")
{
Err_msg(66)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if (frm_Edtstf.cbo_Date.type == "text")
{
if(frm_Edtstf.cbo_Date.val
{
alert("Date is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
if(frm_Edtstf.cbo_Time.val
{
alert("Time is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
if(frm_Edtstf.cbo_Dura.val
{
alert("Duration is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
}
else
{
if(frm_Edtstf.cbo_Date.val
{
alert("Date is mandatory")
frm_Edtstf.cbo_Date.focus(
return false
}
if(frm_Edtstf.cbo_Time.val
{
alert("Time is mandatory")
frm_Edtstf.cbo_Time.focus(
return false
}
if(frm_Edtstf.cbo_Dura.val
{
alert("Duration is mandatory")
frm_Edtstf.cbo_Dura.focus(
return false
}
}
frm_Edtstf.hid_Cmode.value
frm_Edtstf.hid_Smode.value
frm_Edtstf.submit()
}
function btn_Change_onclick()
{
if(frm_Edtstf.txt_Pmfkey.v
{
Err_msg(244)
frm_Edtstf.txt_Pmfkey.focu
return false
}
else if(frm_Edtstf.cbo_Funct.va
{
Err_msg(245)
frm_Edtstf.cbo_Funct.focus
return false
}
else if (frm_Edtstf.cbo_Assign.val
{
Err_msg(246)
frm_Edtstf.cbo_Assign.focu
return false
}
if(frm_Edtstf.txt_Pmfkey.v
frm_Edtstf.txt_Firstname.v
== "")
{
Err_msg(66)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if (frm_Edtstf.cbo_Date.type == "text")
{
if(frm_Edtstf.cbo_Date.val
{
alert("Date is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
if(frm_Edtstf.cbo_Time.val
{
alert("Time is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
if(frm_Edtstf.cbo_Dura.val
{
alert("Duration is mandatory")
frm_Edtstf.btn_Add.focus()
return false
}
}
else
{
if(frm_Edtstf.cbo_Date.val
{
alert("Date is mandatory")
frm_Edtstf.cbo_Date.focus(
return false
}
if(frm_Edtstf.cbo_Time.val
{
alert("Time is mandatory")
frm_Edtstf.cbo_Time.focus(
return false
}
if(frm_Edtstf.cbo_Dura.val
{
alert("Duration is mandatory")
frm_Edtstf.cbo_Dura.focus(
return false
}
}
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
}
function btn_Delete_onclick()
{
var pmf = unescape(frm_Edtstf.hid_Sp
var func = unescape(frm_Edtstf.cbo_Fu
var sd = unescape(frm_Edtstf.hid_Sd
var sdt = unescape(frm_Edtstf.hid_St
var sdtd = unescape(frm_Edtstf.hid_Sd
var asg = unescape(frm_Edtstf.cbo_As
var st = unescape(frm_Edtstf.hid_St
if(frm_Edtstf.txt_Pmfkey.v
{
Err_msg(249)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if(frm_Edtstf.txt_Pmfkey.v
frm_Edtstf.txt_Firstname.v
== "")
{
Err_msg(66)
frm_Edtstf.txt_Pmfkey.focu
return false
}
if(confirm("Delete " + pmf + "'s assignment as " + func + "\n" + "
From:" + sd + " " + sdt + " Duration:" + sdtd +" To:" + st + " At:" +
asg + "\n" +"Are you Sure?"))
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Count.value
frm_Edtstf.submit();
}
}
function btn_Close_onclick()
{
if(frm_Edtstf.hid_Source.v
{
frm_Edtstf.target = "_parent"
frm_Edtstf.action="cf_Staf
frm_Edtstf.submit();
}
if(frm_Edtstf.hid_Source1.
{
frm_Edtstf.target = "_parent"
frm_Edtstf.action="cf_sess
frm_Edtstf.submit();
}
}
function btn_Home_onclick()
{
parent.location.href = "cf_Mainmn.cfm?hid_Logchec
}
function clear()
{
frm_Edtstf.txt_Pmfkey.valu
frm_Edtstf.txt_Lastname.va
frm_Edtstf.txt_Firstname.v
frm_Edtstf.cbo_Sarea.selec
frm_Edtstf.cbo_Funct.selec
frm_Edtstf.cbo_Assign.sele
frm_Edtstf.cbo_Pfunct.sele
frm_Edtstf.cbo_Psarea.sele
frm_Edtstf.cbo_Pprod.selec
frm_Edtstf.chk_Pspeak.chec
frm_Edtstf.chk_Sba.checked
frm_Edtstf.cbo_Date.select
frm_Edtstf.cbo_Time.select
frm_Edtstf.cbo_Dura.select
}
function txt_Pmfkey_onblur()
{
frm_Edtstf.txt_Lastname.va
frm_Edtstf.txt_Firstname.v
if(frm_Edtstf.txt_Pmfkey.v
{
frm_Edtstf.hid_Cmode.value
frm_Edtstf.submit()
return true;
}
else
{
frm_Edtstf.txt_Lastname.fo
}
}
</script>
<cfif form.hid_Cmode neq "T">
<!--- holding screen values while submitting the form --->
<cfset tmp_pmf= '#trim(urldecode(form.txt_
<cfset tmp_sarea='#trim(urldecode
<cfset tmp_fname='#trim(urldecode
<cfset tmp_lname='#trim(urldecode
<cfset tmp_funct='#trim(urldecode
<cfset tmp_ass='#trim(urldecode(f
<cfif form.rdo_Assign eq 'ses'>
<cfset tmp_ses = #trim(urldecode(form.cbo_A
<cfset tmp_sta = ''>
<cfset tmp_loc = ''>
<cfelseif form.rdo_Assign eq 'sta'>
<cfset tmp_sta = #trim(urldecode(form.cbo_A
<cfset tmp_ses = ''>
<cfset tmp_loc = ''>
<cfelseif form.rdo_Assign eq 'loc'>
<cfset tmp_loc = #trim(urldecode(form.cbo_A
<cfset tmp_sta = ''>
<cfset tmp_ses = ''>
</cfif>
<cfset tmp_assval='#trim(urldecod
<cfset tmp_sdate=form.hid_Sdate>
<cfset tmp_stime=form.hid_Stime>
<cfset tmp_sdura=form.hid_Sdura>
<cfset tmp_spmf=form.hid_Spmf>
<cfset tmp_sassign = form.hid_Sassign>
<cfset tmp_sassignval = form.hid_Sassignval>
<cfset tmp_pfunct='#trim(urldecod
<cfset tmp_parea='#trim(urldecode
<cfset tmp_pprod='#trim(urldecode
<cfset tmp_pspeak='#trim(urldecod
<cfset tmp_sba='#trim(urldecode(f
<cfset tmp_date='#trim(urldecode(
<cfset tmp_time='#trim(urldecode(
<cfset tmp_dura='#trim(urldecode(
<!--- new code --->
<cfif form.hid_Source eq "Staff" and trim(form.hid_valass) neq ''>
<cfset
tmp_assval='#trim(urldecod
<cfset form.cbo_Assign =
'#trim(urldecode(form.hid_
<cfset form.hid_Cmode = "ASC">
<cfif form.rdo_Assign eq 'ses'>
<cfset tmp_ses = #trim(urldecode(form.cbo_A
<cfset tmp_sta = ''>
<cfset tmp_loc = ''>
<cfelseif form.rdo_Assign eq 'sta'>
<cfset tmp_sta = #trim(urldecode(form.cbo_A
<cfset tmp_ses = ''>
<cfset tmp_loc = ''>
<cfelseif form.rdo_Assign eq 'loc'>
<cfset tmp_loc = #trim(urldecode(form.cbo_A
<cfset tmp_sta = ''>
<cfset tmp_ses = ''>
</cfif>
<cfset form.hid_valass = ''>
</cfif>
<!--- new code ends --->
<cfelse>
<cfif parameterexists(url.hid_So
<cfset form.hid_Source = "Staff">
<cfset form.hid_Defsarea = #trim(url.hid_selsarea)#>
<cfset tmp_sarea = #trim(url.hid_selsarea)#>
<cfset form.hid_Defses = '#trim(url.hid_Defses)#'>
<cfelse>
<cfset form.hid_Source1 = "Sessionmgmt">
<cfset form.hid_Defsarea = #trim(url.hid_selsarea)#>
<cfset tmp_sarea = #trim(url.hid_selsarea)#>
<cfset form.hid_Defses = '#trim(url.hid_Defses)#'>
</cfif>
<cfif #trim(form.hid_Defses)# eq ''>
<cfset form.hid_Cmode = "SAC">
<cfelse>
<cfif parameterexists(url.hid_So
<cfset form.cbo_Assign = '#trim(url.hid_Defses)#'>
<cfelse>
<cfset form.cbo_Assign =
'#trim(url.hid_Defses)#'>
</cfif>
<cfset form.hid_Cmode = "ASC">
</cfif>
</cfif>
<cfif form.hid_Smode eq "A">
<cfif #form.hid_Proc# neq 'ATY'>
<cfif #tmp_pmf# neq "TBA">
<cfset #stdate# = #tmp_date# & ' ' &
#tmp_time#>
<cfx_ingres name="cfqry_ruledates"
db=#Session.cawdbNode# sql="select date('#stdate#') as
new_start,date('#stdate#')
<cfset new_start =
trim(cfqry_ruledates.new_s
<cfset new_stop =
trim(cfqry_ruledates.new_s
<!--- checking rule10 --->
<cfset warning = "Desired Schedule time " &
#new_start# & " to " & #new_stop# & "\n\n Currently scheduled
commitments include: \n\n ">
<cfx_ingres name="cfqry_Insrule10"
db=#Session.cawdbNode# sql="select start_time as old_start, stop_time
as old_stop,sessions as old_session_code, booth as
old_booth_code,station as old_station_code, conf as old_conf_code,
function as old_function from schedule
where uppercase(pmf_key) =
'#ucase(rereplace(tmp_pmf,
'#new_start#' and stop_time > '#new_start#') or (start_time <
'#new_stop#' and stop_time >= '#new_stop#') or ( start_time >=
'#new_start#' and stop_time <= '#new_stop#') or (( (stop_time <=
'#new_start#' and (stop_time + date('15 minutes')) > '#new_start#') or
(start_time >= '#new_stop#' and (start_time - date('15 minutes')) <
'#new_stop#' ) ))) order by 1">
<cfif #cfqry_Insrule10.recordcou
<cfset counter = 0>
<cfloop query="cfqry_Insrule10">
<cfset counter = counter + 1>
<cfset warning = warning & " " &
#counter# & " ">
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & "
Conference " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & "
Location " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & "
Station " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & "
Session " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning = warning & " as
a " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif #trim(cfqry_Insrule10.old_
neq "" and #trim(cfqry_Insrule10.old_
<cfset warning = warning & "
from " & #trim(cfqry_Insrule10.old_
#trim(cfqry_Insrule10.old_
</cfif>
<cfif
(((#rereplace(tmp_funct,"'
(#rereplace(tmp_funct,"'",
eq 'MONITOR' and '#trim(cfqry_Insrule10.old
and
((datecompare("#new_start#
and datecompare("#new_start#",
-1) or
(datecompare
("#new_stop#","#trim(cfqry
datecompare("#new_stop#","
(datecompare
("#new_start#","#trim(cfqr
datecompare("#new_stop#","
(datecompare
("#new_start#","#trim(cfqr
datecompare("#new_stop#","
<cfset #form.hid_Proc# = 'ATD'>
<cfelse>
<cfset #form.hid_Proc# = 'AT'>
</cfif>
</cfloop>
<cfelse>
<cfset #form.hid_Proc# = 'ATY'>
</cfif>
<cfelse>
<cfset #form.hid_Proc# = 'ATY'>
</cfif>
</cfif>
<!--- process skipped for getting rule 10 confirmation, see
code below for flag AT --->
<cfif #form.hid_Proc# eq 'ATY'>
<!--- After confirmation of rule control adding process starts
here --->
<cfset #form.hid_Proc# = ''>
<cfset #stdate# = #tmp_date# & ' ' & #tmp_time#>
<cfif trim(form.rdo_Assign) is "ses">
<cfx_ingres name="cfqry_Inssche"
db=#Session.cawdbNode# sql="insert into
schedule(pmf_key,start_tim
ion,product_code)
values('#ucase(rereplace(t
#' +
date('#tmp_dura#'),'#rerep
ce(tmp_sarea,"'","''","ALL
,'#rereplace(tmp_pprod,"'"
<cfelseif trim(form.rdo_Assign) is "sta">
<cfx_ingres name="cfqry_Inssche"
db=#Session.cawdbNode# sql="insert into
schedule(pmf_key,start_tim
ion,product_code)
values('#ucase(rereplace(t
#' +
date('#tmp_dura#'),'#rerep
ce(tmp_sarea,"'","''","ALL
,'#rereplace(tmp_pprod,"'"
<cfelseif trim(form.rdo_Assign) is "loc">
<cfx_ingres name="cfqry_Inssche"
db=#Session.cawdbNode# sql="insert into
schedule(pmf_key,start_tim
ion,product_code)
values('#ucase(rereplace(t
#' +
date('#tmp_dura#'),'#rerep
tmp_loc,"'","''","ALL")#',
,'#rereplace(tmp_pprod,"'"
</cfif>
<!--- <cfx_ingres name="cfqry_Inssche" db=#Session.cawdbNode#
sql="insert into
schedule(pmf_key,start_tim
ion,product_code)
values('#ucase(rereplace(t
#' +
date('#tmp_dura#'),'#rerep
tmp_loc,"'","''","ALL")#',
eplace(tmp_ses,"'","''","A
'#rereplace(tmp_pprod,"'",
<cfif #tmp_pspeak# eq 'T' and #tmp_ses# neq '' and
#tmp_funct# eq 'SPEAKER'>
<cfx_ingres name="cfqry_Insupdses"
db=#Session.cawdbNode# sql="update sessions set
primary_speaker='#ucase(re
session_code='#rereplace(t
</cfif>
<cfif form.hid_Pinfo eq 'T'>
<cfx_ingres name="cfqry_Insupdper"
db=#Session.cawdbNode# sql="update person set
primary_conference='#rerep
tion='#rereplace(tmp_pfunc
a#' where
uppercase(pmf_key)='#ucase
</cfif>
<cfx_ingres name="cfqry_Ssdate" db=#Session.cawdbNode#
sql="select start_time,stop_time from schedule where start_time =
'#stdate#' and stop_time = '#stdate#' + date('#tmp_dura#') and
uppercase(pmf_key) = '#ucase(rereplace(tmp_pmf,
<cfx_ingres name="cfqry_Inswasis"
db=#Session.cawdbNode# sql="insert into
wasis_log(table_affected,w
y,comments) values
('SCHEDULE','#ucase(rerepl
,'#Session.Inventpmfkey#',
'#rereplace(trim(tmp_funct
'#trim(cfqry_Ssdate.start_
'#trim(cfqry_Ssdate.stop_t
'#trim(tmp_sarea)#')">
<cfset msg = 4>
<!--- setting session query to reflect the changes to
the upper frame --->
<cfset clause = "schedule.pmf_key = person.pmf_key
and schedule.pmf_key = '#ucase(rereplace(tmp_pmf,
schedule.conf = '#trim(tmp_sarea)#'" >
<cfset clause = clause & " and schedule.function =
'#rereplace(trim(tmp_funct
<cfset #stdate# = #tmp_date# & ' ' & #tmp_time#>
<cfset clause = clause & " and start_time='#stdate#'
and stop_time ='#stdate#' + date('#tmp_dura#')">
<cfif form.rdo_Assign eq 'ses'>
<cfset clause=clause & " and
schedule.sessions = '#rereplace(trim(tmp_ses),
<cfset sqlstr = "select
Schedule.Pmf_Key , Person.Last_Name,Person.Fi
Schedule.Function,Schedule
Schedule.Stop_Time,Schedul
Schedule.Conf, char(Person.Shirt_Size) as Shirt_Size ,
Schedule.Stop_Time - Schedule.Start_Time as duration,Schedule.tid FROM
SCHEDULE, PERSON WHERE " & clause & " order by 1,5">
<cfelseif form.rdo_Assign eq 'sta'>
<cfset clause=clause & " and
schedule.station = '#rereplace(trim(tmp_sta),
<cfset sqlstr = "select
Schedule.Pmf_Key , Person.Last_Name,Person.Fi
Schedule.Function,Schedule
Schedule.Stop_Time,Schedul
Schedule.Conf, char(Person.Shirt_Size) as Shirt_Size ,
Schedule.Stop_Time - Schedule.Start_Time as duration,Schedule.tid FROM
SCHEDULE, PERSON WHERE " & clause & " order by 1,5">
<cfelseif form.rdo_Assign eq 'loc'>
<cfset clause= clause & " and
schedule.booth = '#rereplace(trim(tmp_loc),
<cfset sqlstr = "select
Schedule.Pmf_Key , Person.Last_Name,Person.Fi
Schedule.Function,Schedule
Schedule.Stop_Time,Schedul
Schedule.Conf, char(Person.Shirt_Size) as Shirt_Size ,
Schedule.Stop_Time - Schedule.Start_Time as duration,Schedule.tid FROM
SCHEDULE, PERSON WHERE " & clause & " order by 1,5">
</cfif>
<cfif form.hid_Addedit eq 'ADD'>
<!--- <cfset Session.cfqry_AddEditStaff
#sqlstr#> --->
<cfelse>
<script language="JavaScript">
parent.Topform.document.fr
"<cfoutput>#urlencodedform
parent.Topform.document.fr
"<cfoutput>#urlencodedform
parent.Topform.document.fr
"<cfoutput>#form.rdo_Assig
parent.Topform.document.fr
"<cfoutput>#urlencodedform
parent.Topform.document.fr
"<cfoutput>#tmp_date#</cfo
parent.Topform.document.fr
"<cfoutput>#tmp_time#</cfo
parent.Topform.document.fr
"<cfoutput>#tmp_dura#</cfo
</script>
<!--- setting session query to reflect the
changes to the upper frame --->
<cfset clause1 = "schedule.pmf_key =
person.pmf_key and schedule.pmf_key =
'#ucase(rereplace(tmp_pmf,
'#trim(tmp_sarea)#'" >
<cfset clause1 = clause1 & " and
schedule.function = '#rereplace(trim(tmp_funct
<cfset #stdate# = #tmp_date# & ' ' &
#tmp_time#>
<cfset clause1 = clause1 & " and
start_time='#stdate#' and stop_time ='#stdate#' + date('#tmp_dura#')">
<cfif form.rdo_Assign eq 'ses'>
<cfset clause1=clause1 & " and
schedule.sessions = '#rereplace(trim(tmp_ses),
<cfelseif form.rdo_Assign eq 'sta'>
<cfset clause1=clause1 & " and
schedule.station = '#rereplace(trim(tmp_sta),
<cfelseif form.rdo_Assign eq 'loc'>
<cfset clause1 = clause1 & " and
schedule.booth = '#rereplace(trim(tmp_loc),
</cfif>
<!--- <cfset sqlstr =
left(trim(Session.cfqry_Ad
ff)) - 13)> --->
<cfif len(trim(Form.hid_Query)) gt 0>
<cfset sqlstr =
left(trim(Form.hid_Query),
<cfset sqlstr = sqlstr & ' or
(' & clause1 & ' )' & ' order by 1,5'>
</cfif>
<!--- <cfset Session.cfqry_AddEditStaff
#sqlstr#> --->
</cfif>
<cfset tmp_pmf = ''>
<cfset tmp_lname = ''>
<cfset tmp_fname = ''>
<cfset form.chk_Pspeak = "F">
<cfset form.chk_Sba ="F">
<cfset tmp_pfunct=''>
<cfset tmp_parea=''>
<cfset tmp_pprod=''>
<cfset tmp_pspeak=''>
<cfset #form.hid_Smode# = ''>
<cfset #form.hid_Proc# =''>
</cfif>
<cfelseif form.hid_Smode eq "C">
<!--- Checking Rule10 starts here --->
<cfif #form.hid_Proc# neq 'CTY'>
<cfif #tmp_pmf# neq "TBA">
<cfif ((ucase(trim(tmp_Pmf)) neq
ucase(trim(tmp_spmf))) or (trim(tmp_date) neq trim(tmp_sdate)) or
(trim(tmp_time) neq trim(tmp_stime)) or (trim(tmp_dura) neq
trim(tmp_sdura)))>
<cfset #stdate# = #tmp_date# & ' ' &
#tmp_time#>
<cfx_ingres name="cfqry_ruledates"
db=#Session.cawdbNode# sql="select date('#stdate#') as
new_start,date('#stdate#')
<cfset new_start =
trim(cfqry_ruledates.new_s
<cfset new_stop =
trim(cfqry_ruledates.new_s
<cfset warning = "Desired Schedule time: " &
#new_start# & " to " & #new_stop# & "\n\n Currently scheduled
commitments include: \n\n">
<cfx_ingres name="cfqry_Insrule10"
db=#Session.cawdbNode# sql="select pmf_key, start_time as old_start,
stop_time as old_stop,sessions as old_session_code, booth as
old_booth_code,station as old_station_code, conf as old_conf_code,
function as old_function from schedule
where uppercase(pmf_key)=
'#ucase(rereplace(tmp_pmf,
'#new_start#' and stop_time > '#new_start#') or (start_time <
'#new_stop#' and stop_time >= '#new_stop#') or ( start_time >=
'#new_start#' and stop_time <= '#new_stop#') or (((stop_time <=
'#new_start#' and (stop_time + date('15 minutes')) > '#new_start#') or
(start_time >= '#new_stop#' and (start_time - date('15 minutes')) <
'#new_stop#' )))) order by 1">
<cfif #cfqry_Insrule10.recordcou
<cfset counter = 0>
<cfloop query="cfqry_Insrule10">
<cfif tmp_sassign eq 'ses'>
<cfif trim(tmp_sassignval) neq
trim(cfqry_Insrule10.old_s
<cfset ass_flag = "T">
</cfif>
<cfelseif tmp_sassign eq 'sta'>
<cfif trim(tmp_sassignval) neq
trim(cfqry_Insrule10.old_s
<cfset ass_flag = "T">
</cfif>
<cfelseif tmp_sassign eq 'loc'>
<cfif trim(tmp_sassignval) neq
trim(cfqry_Insrule10.old_b
<cfset ass_flag = "T">
</cfif>
</cfif>
<cfset #rsdate# = #tmp_sdate# & ' ' &
#tmp_stime#>
<cfx_ingres name="cfqry_compdates"
db=#Session.cawdbNode# sql="select date('#rsdate#') as
act_start,date('#rsdate#')
<cfif (ucase(trim(#tmp_spmf#)) neq
trim(#cfqry_Insrule10.pmf_
(datecompare("#trim(cfqry_
.old_start)#") neq 0) and
(datecompare("#trim(cfqry_
old_stop)#") neq 0) and (#ass_flag# eq "T")>
<cfset counter = counter + 1>
<cfset warning = warning & " "
& #counter# & " ">
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " Conference " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " Location " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " Station " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " Session " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " as a " & #trim(cfqry_Insrule10.old_
</cfif>
<cfif
#trim(cfqry_Insrule10.old_
#trim(cfqry_Insrule10.old_
<cfset warning =
warning & " from " & #trim(cfqry_Insrule10.old_
#trim(cfqry_Insrule10.old_
</cfif>
<cfif ((
(#rereplace(tmp_funct,"'",
(#rereplace(tmp_funct,"'",
'#trim(cfqry_Insrule10.old
((datecompare("#new_start#
and datecompare("#new_start#",
-1) or
(datecompare
("#new_stop#","#trim(cfqry
datecompare("#new_stop#","
(datecompare
("#new_start#","#trim(cfqr
datecompare("#new_stop#","
(datecompare
("#new_start#","#trim(cfqr
datecompare("#new_stop#","
<cfset #form.hid_Proc#
= 'CTD'>
<cfelse>
<cfset #form.hid_Proc#
= 'CT'>
</cfif>
<cfelse>
<cfset #form.hid_Proc# = 'CTY'>
</cfif>
</cfloop>
<cfelse>
<cfset #form.hid_Proc# = 'CTY'>
</cfif>
<cfelse>
<cfset #form.hid_Proc# = 'CTY'>
</cfif>
<cfelse>
<cfset #form.hid_Proc# = 'CTY'>
</cfif>
</cfif>
<!--- process skipped for getting rule 10 confirmation,see
code below for flag CT --->
<cfif #form.hid_Proc# eq 'CTY'>
<!--- After confirmation of rule control updation process
starts here --->
<cfset #wcsdate# = #tmp_sdate# & ' ' & #tmp_stime#>
<cfset #stdate# = #tmp_date# & ' ' & #tmp_time#>
<cfif trim(form.rdo_Assign) is "ses">
<cfx_ingres name="cfqry_Updsche"
db=#Session.cawdbNode# sql="update schedule set pmf_key =
'#ucase(rereplace(tmp_pmf,
start_time='#stdate#',stop
+date('#tmp_dura#'),functi
oth='',
conf='#rereplace(tmp_sarea
es,"'","''","ALL")#',stati
"''","ALL")#' where uppercase(pmf_key) = '#ucase(tmp_spmf)#' and
start_time='#wcsdate#' and stop_time ='#wcsdate#' +
date('#tmp_sdura#')">
<cfelseif trim(form.rdo_Assign) is "sta">
<cfx_ingres name="cfqry_Updsche"
db=#Session.cawdbNode# sql="update schedule set pmf_key =
'#ucase(rereplace(tmp_pmf,
start_time='#stdate#',stop
+date('#tmp_dura#'),functi
oth='', conf='#rereplace(tmp_sarea
station='#rereplace(tmp_st
tmp_pprod,"'","''","ALL")#
'#ucase(tmp_spmf)#' and start_time='#wcsdate#' and stop_time
='#wcsdate#' + date('#tmp_sdura#')">
<cfelseif trim(form.rdo_Assign) is "loc">
<cfx_ingres name="cfqry_Updsche"
db=#Session.cawdbNode# sql="update schedule set pmf_key =
'#ucase(rereplace(tmp_pmf,
start_time='#stdate#',stop
+date('#tmp_dura#'),functi
oth='#rereplace(tmp_loc,"'
","''","ALL")#',sessions='
od,"'","''","ALL")#' where uppercase(pmf_key) = '#ucase(tmp_spmf)#' and
start_time='#wcsdate#' and stop_time ='#wcsdate#' +
date('#tmp_sdura#')">
</cfif>
<!--- <cfx_ingres name="cfqry_Updsche"
db=#Session.cawdbNode# sql="update schedule set pmf_key =
'#ucase(rereplace(tmp_pmf,
start_time='#stdate#',stop
date('#tmp_dura#'),functio
th='#rereplace(tmp_loc,"'"
,"''","ALL")#',sessions='#
#rereplace(tmp_sta,"'","''
,"'","''","ALL")#' where uppercase(pmf_key) = '#ucase(tmp_spmf)#' and
start_time='#wcsdate#' and stop_time ='#wcsdate#' +
date('#tmp_sdura#')"> --->
<cfif tmp_pspeak eq "T" and tmp_ses neq '' and
#tmp_funct# eq 'SPEAKER'>
<cfx_ingres name="cfqry_chgupdses"
db=#Session.cawdbNode# sql="update sessions set
primary_speaker='#ucase(re
session_code='#rereplace(t
<cfelseif tmp_pspeak eq "F" and tmp_ses neq '' and
#tmp_funct# eq 'SPEAKER'>
<cfx_ingres name="cfqry_Speak"
db=#Session.cawdbNode# sql="select * from sessions where
primary_speaker = '#ucase(rereplace(tmp_pmf,
session_code='#rereplace(t
<cfif #cfqry_Speak.recordcount# gt 0>
<cfx_ingres name="cfqry_chgupdses"
db=#Session.cawdbNode# sql="update sessions set primary_speaker=''
where session_code='#rereplace(t
</cfif>
</cfif>
<cfif form.hid_Pinfo eq 'T'>
<cfx_ingres name="cfqry_chgupdper"
db=#Session.cawdbNode# sql="update person set
primary_conference='#rerep
tion='#rereplace(tmp_pfunc
a#' where
uppercase(pmf_key)='#ucase
</cfif>
<cfx_ingres name="cfqry_Ssdate" db=#Session.cawdbNode#
sql="select start_time,stop_time from schedule where
start_time='#stdate#' and stop_time = '#stdate#' + date('#tmp_dura#')
and uppercase(pmf_key) = '#ucase(tmp_pmf)#'">
<cfx_ingres name="cfqry_Chgwasis"
db=#Session.cawdbNode# sql="insert into
wasis_log(table_affected,w
y,comments) values
('SCHEDULE','#ucase(rerepl
,'#session.Inventpmfkey#',
'#rereplace(tmp_funct,"'",
'#trim(cfqry_Ssdate.start_
'#trim(cfqry_Ssdate.stop_t
'#tmp_sarea#')">
<cfset msg = 3>
<!--- setting session query to reflect the
changes to the upper frame --->
<cfset clause1 = "schedule.pmf_key =
person.pmf_key and schedule.pmf_key =
'#ucase(rereplace(tmp_pmf,
'#trim(tmp_sarea)#'" >
<cfset clause1 = clause1 & " and
schedule.function = '#rereplace(trim(tmp_funct
<cfset #stdate# = #tmp_date# & ' ' &
#tmp_time#>
<cfset clause1 = clause1 & " and
start_time='#stdate#' and stop_time ='#stdate#' + date('#tmp_dura#')">
<cfif form.rdo_Assign eq 'ses'>
<cfset clause1=clause1 & " and
schedule.sessions = '#rereplace(trim(tmp_ses),
<cfelseif form.rdo_Assign eq 'sta'>
<cfset clause1=clause1 & " and
schedule.station = '#rereplace(trim(tmp_sta),
<cfelseif form.rdo_Assign eq 'loc'>
<cfset clause1 = clause1 & " and
schedule.booth = '#rereplace(trim(tmp_loc),
</cfif>
<!--- <cfset sqlstr =
left(trim(Session.cfqry_Ad
ff)) - 13)>
--->
<cfif len(trim(Form.hid_Query)) gt 0>
<cfset sqlstr =
left(trim(Form.hid_Query),
<cfset sqlstr = sqlstr & ' or (' &
clause1 & ' )' & ' order by 1,5'>
</cfif>
<!--- <cfset sqlstr = sqlstr & ' or (' & clause1 & '
)' & ' order by 1,5'>
<cfset Session.cfqry_AddEditStaff
--->
<script language="JavaScript">
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
parent.Topform.document.fr
</script>
<cfset #form.hid_Smode# = ''>
<cfset #form.hid_Proc# = ''>
</cfif>
<cfelseif form.hid_Smode eq "D">
<!--- checking for alias --->
<cfx_ingres name="cfqry_alias" db=#Session.cawdbNode#
sql="select alias as ses_alias from alias where alias =
'#rereplace(tmp_ses,"'","'
<cfif cfqry_alias.ses_alias neq ''>
<cfset msg = 2>
</cfif>
<!--- delete process starts here --->
<cfif msg neq 2>
<cfset stdate = #tmp_sdate# & ' ' &
#tmp_stime#>
<cfset where_clause = "uppercase(pmf_key) =
'#ucase(rereplace(tmp_spmf
and stop_time ='#stdate#' + date('#tmp_sdura#')">
<cfx_ingres name="cfqry_Delsche"
db=#Session.cawdbNode# sql="delete from schedule where #where_clause#">
<cfx_ingres name="cfqry_Delwasis"
db=#Session.cawdbNode# sql="insert into
wasis_log(table_affected,w
y,comments) values
('SCHEDULE','#ucase(rerepl
,'#session.Inventpmfkey#',
<cfif tmp_pspeak eq "T" and tmp_ses neq '' and
#tmp_funct# eq 'SPEAKER'>
<cfx_ingres name="cfqry_delupdses1"
db=#Session.cawdbNode# sql="update sessions set primary_speaker=''
where session_code='#rereplace(t
primary_speaker='#ucase(re
</cfif>
<cfif cfqry_alias.ses_alias neq ''>
<cfx_ingres name="cfqry_delupdses2"
db=#Session.cawdbNode# sql="update sessions set primary_speaker=''
where session_code='#rereplace(c
and primary_speaker='#ucase(re
</cfif>
<cfset msg = 5>
<cfset form.hid_Smode = ''>
<cfset tmp_pmf = ''>
<cfset tmp_lname = ''>
<cfset tmp_fname = ''>
<cfset form.chk_Pspeak = "F">
<cfset form.chk_Sba ="F">
<cfset tmp_pfunct=''>
<cfset tmp_parea=''>
<cfset tmp_pprod=''>
<cfset tmp_pspeak=''>
</cfif>
</cfif>
<cfif #form.hid_Cmode# neq "">
<cfif Session.Security.Conf_All eq 1>
<cfx_ingres name="cfqry_Loadsarea" db=#Session.cawdbNode#
sql="Select name,uppercase(name) from conferences order by 2">
<cfelse>
<cfx_ingres name="cfqry_Loadsarea" db=#Session.cawdbNode#
sql="Select conference from security where username =
'#session.pmfkey#' and left(conference,4) != 'CWS-' order by 1">
</cfif>
<cfx_ingres name="cfqry_Loadfunct" db=#Session.cawdbNode# sql=
"Select name,uppercase(name) from Function order by 2">
<cfx_ingres name="cfqry_Loadprodcut" db=#Session.cawdbNode#
sql="Select product_code,product,upper
order by 3">
<cfx_ingres name="cfqry_Loadsession" db=#Session.cawdbNode#
sql="Select session_code, uppercase(session_code) from Sessions Where
Conference ='#rereplace(tmp_sarea,"'"
<!--- checking default --->
<cfif (#trim(urldecode(form.hid_
form.hid_Cmode eq 'T') or form.hid_Cmode eq 'SAC'>
<cfx_ingres
name="cfqry_Loadsession1" db=#Session.cawdbNode# sql="Select
session_code, uppercase(session_code) from Sessions Where Conference
='#rereplace(tmp_sarea,"'"
<cfset form.cbo_Assign =
'#urlencodedformat(trim(cf
<cfset form.hid_Defses =
'#urlencodedformat(trim(cf
<cfset tmp_assval =
urldecode(trim(form.cbo_As
<cfset tmp_ses =
urldecode(trim(form.cbo_As
<cfset form.hid_Cmode = 'ASCE'>
</cfif>
<cfx_ingres name="cfqry_Loaddate" db=#Session.cawdbNode#
sql="Select distinct(name),date(name) from ca_world_Dates Order by 2">
<cfx_ingres name="cfqry_Loadtime"
db=#Session.cawdbNode# sql="Select distinct(name) from
session_start_times Order by 1">
<cfx_ingres name="cfqry_Loaddura" db=#Session.cawdbNode#
sql="Select distinct(name) from session_stop_times Order by 1">
</cfif>
<cfif #form.hid_Cmode# eq 'SP'>
<cfset txt_Pmfkey =
Rereplace(#trim(form.txt_P
<cfx_ingres name="cfqry_Check" db=#Session.cawdbNode#
sql="select last_name, first_name ,
pmf_key,primary_function,p
person where uppercase(pmf_key) = '#trim(ucase(txt_Pmfkey))#
<cfif cfqry_Check.recordcount gt 0>
<cfset tmp_Ppmf = trim(cfqry_Check.pmf_key)>
<cfset tmp_lname = trim(cfqry_Check.last_name
<cfset tmp_fname = trim(cfqry_Check.first_nam
<cfif trim(cfqry_Check.sba_relat
<cfset form.chk_Sba = "T">
</cfif>
<cfset tmp_pfunct=trim(cfqry_Chec
<cfset tmp_parea=trim(cfqry_Check
</cfif>
</cfif>
<html>
<head>
<title></title>
<link href="style.css" rel="STYLESHEET" type="TEXT/CSS">
</head>
<body>
<form name="frm_Edtstf" action="Cf_AdEdtstf.cfm" method="post">
<input type="hidden" name="hid_Query"
value="<cfoutput>#trim(For
<script language="JavaScript">
frm_Edtstf.hid_Query.value
</script>
<div align="center"><center>
<table border="0" cellspacing="0" cellpading="0">
<tr>
<!--- loading solution area --->
<cfif session.Security.Conf_All eq 1>
<td>Solution Area<br>
<select name="cbo_Sarea" size="1" style="width:200px"
onchange="cbo_Sarea_onchan
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsarea">
<cfif #trim(tmp_sarea)# eq
#trim(cfqry_Loadsarea.name
<option
value="#urlencodedformat(t
>#trim(cfqry_Loadsarea.nam
<cfelse>
<option
value="#urlencodedformat(t
sarea.name)#</option>
</cfif>
</cfoutput>
</select></td>
<cfelse>
<td>Solution Area<br>
<select name="cbo_Sarea" size="1" style="width:200px"
onchange="cbo_Sarea_onchan
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsarea">
<cfif #trim(tmp_sarea)# eq
#trim(cfqry_Loadsarea.conf
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
y_Loadsarea.conference)#</
</cfif>
</cfoutput>
</select></td>
</cfif>
<cfoutput>
<td>PMF Key<br>
<input type="text" size="20" name="txt_Pmfkey" style="width:90"
value="#urlencodedformat(t
onchange="txt_Pmfkey_oncha
<td>First Name<br>
<input type="text" size="20" name="txt_Firstname"
style="width:125px" value="#urlencodedformat(t
maxlength="20" readonly></td>
<td>Last Name<br>
<input type="text" size="20" name="txt_Lastname"
style="width:150px" value="#urlencodedformat(t
maxlength="16" onchange="txt_Lastname_onc
<td><br>
<input type="button" name="btn_Search" value="Search"
style="width:50px" onclick="btn_Search_onclic
</cfoutput>
</tr>
<tr>
<!--- function loads here --->
<td>Function<br>
<select name="cbo_Funct" size="1" style="width:200px"
onchange="cbo_Funct_onchan
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadfunct">
<cfif #trim(tmp_funct)# eq
#trim(cfqry_Loadfunct.name
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadf
<cfelse>
<option
value="#urlencodedformat(t
funct.name)#</option>
</cfif>
</cfoutput>
</select></td>
<td colspan="2"><p align="center">Assignment<
<!--- Assignment radoi button checked for (session)
--->
<cfif form.rdo_Assign eq 'ses'>
<input type="radio" name="rdo_Assign" value="ses"
checked onclick="rdo_onclick()" >Session
<input type="radio" name="rdo_Assign"
value="sta" onclick="rdo_onclick()">St
<input type="radio" name="rdo_Assign"
value="loc" onclick="rdo_onclick()"> Location</p>
<!--- Assignment radoi button checked for (session) --->
<cfelseif form.rdo_Assign eq 'sta'>
<input type="radio" name="rdo_Assign" value="ses"
onclick="rdo_onclick()" >Session
<input type="radio" name="rdo_Assign"
value="sta" checked onclick="rdo_onclick()">St
<input type="radio" name="rdo_Assign"
value="loc" onclick="rdo_onclick()"> Location</p>
<!--- Assignment radoi button checked for (session)
--->
<cfelseif form.rdo_Assign eq 'loc'>
<input type="radio" name="rdo_Assign" value="ses"
onclick="rdo_onclick()" >Session
<input type="radio" name="rdo_Assign"
value="sta" onclick="rdo_onclick()">St
<input type="radio" name="rdo_Assign"
value="loc" checked onclick="rdo_onclick()"> Location</p>
</cfif>
</td>
<!--- Assignment list loading for session --->
<cfif form.rdo_Assign eq 'ses'>
<cfif #form.hid_Cmode# eq 'ASC' or
#form.hid_Cmode# eq 'ASCE' >
<cfset tmp_ses =
trim(URLdecode(form.cbo_As
<cfset tmp_assval =
trim(URLdecode(form.cbo_As
<cfx_ingres name="cfqry_alias"
db=#Session.cawdbNode# sql="select alias as ses_alias from alias where
alias = '#rereplace(tmp_ses,"'","'
<cfif trim(cfqry_alias.ses_alias
''>
<cfset msg = 1>
<cfset tmp_assval = form.hid_Ass>
<cfelse>
<cfset form.hid_Ass = tmp_assval>
</cfif>
<cfx_ingres name="cfqry_sesdate"
db=#Session.cawdbNode# sql="Select
start_date,stop_date,stop_
Session_code ='#rereplace(tmp_assval,"'
<cfset tmp_date =
left(trim(cfqry_sesdate.st
<cfset tmp_time =
left(right(trim(cfqry_sesd
<cfset tmp_dura =
trim(cfqry_sesdate.dura)>
</cfif>
<td colspan="2"><br>
<select name="cbo_Assign" size="1"
style="width:150px" onchange="cbo_Assign_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsession">
<cfif #trim(tmp_assval)# eq
#trim(cfqry_Loadsession.se
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
cfqry_Loadsession.session_
</cfif>
</cfoutput>
</select></td>
<!--- Assignment list loading for station
--->
<cfelseif form.rdo_Assign eq 'sta'>
<cfx_ingres name="cfqry_Loadstation"
db=#Session.cawdbNode# sql="Select stationid,uppercase(statio
station where conference ='#rereplace(tmp_sarea,"'"
by 2">
<td colspan="2"><br>
<select name="cbo_Assign" size="1" style="width:150px"
onchange="cbo_Assign_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadstation">
<cfif #trim(tmp_assval)# eq
#trim(cfqry_Loadstation.st
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
ry_Loadstation.stationid)#
</cfif>
</cfoutput>
</select></td>
<!--- Assignment list loading for station --->
<cfelseif form.rdo_Assign eq 'loc'>
<cfx_ingres name="cfqry_Loadbooth"
db=#Session.cawdbNode# sql="Select name,uppercase(name) from booth
where conf = '#rereplace(tmp_sarea,"'",
<td colspan="2"><br>
<select name="cbo_Assign" size="1" style="width:150px"
onchange="cbo_Assign_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadbooth">
<cfif #trim(tmp_assval)# eq
#trim(cfqry_Loadbooth.name
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadb
<cfelse>
<option
value="#urlencodedformat(t
booth.name)#</option>
</cfif>
</cfoutput>
</select></td>
</cfif>
</tr>
<tr>
<!--- Primary function list loading --->
<td>Primary Function<br>
<select name="cbo_Pfunct" size="1" style="width:200px"
onchange="cbo_Pfunct_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadfunct">
<cfif #trim(tmp_pfunct)# eq
#trim(cfqry_Loadfunct.name
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadf
<cfelse>
<option
value="#urlencodedformat(t
funct.name)#</option>
</cfif>
</cfoutput>
</select></td>
<!--- Primary solution list loading --->
<td colspan="2">Primary Solution Area<br>
<cfif session.Security.Conf_All eq 1>
<select name="cbo_Psarea" size="1"
style="width:200px" onchange="cbo_Psarea_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsarea">
<cfif #trim(tmp_parea)# eq
#trim(cfqry_Loadsarea.name
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
sarea.name)#</option>
</cfif>
</cfoutput>
</select>
<cfelse>
<select name="cbo_Psarea" size="1"
style="width:200px" onchange="cbo_Psarea_oncha
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadsarea">
<cfif #trim(tmp_parea)# eq
#trim(cfqry_Loadsarea.conf
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loads
<cfelse>
<option
value="#urlencodedformat(t
y_Loadsarea.conference)#</
</cfif>
</cfoutput>
</select>
</cfif></td>
<!--- Primary product list loading --->
<td colspan="2">Primary Product<br>
<select name="cbo_Pprod" size="1" style="width:250px">
<option value="">(Select)</option>
<cfoutput query="cfqry_Loadprodcut">
<cfif #trim(tmp_pprod)# eq
#trim(cfqry_Loadprodcut.pr
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadp
<cfelse>
<option
value="#urlencodedformat(t
cfqry_Loadprodcut.product)
</cfif>
</cfoutput>
</select></td>
<td> </td>
</tr>
<tr> <!--- checking for primary speaker --->
<cfif form.chk_Pspeak eq "T">
<td><input type="checkbox" name="chk_Pspeak"
checked value="T">Primary Speaker</td>
<cfelse>
<td><input type="checkbox" name="chk_Pspeak"
value="T">Primary Speaker</td>
</cfif>
<!--- checking for sba relationship --->
<cfif form.chk_Sba eq "T">
<td><input type="checkbox" name="chk_Sba"
value="T" checked onclick="chk_Sba_onclick()
<cfelse>
<td><input type="checkbox" name="chk_Sba"
value="T" onclick="chk_Sba_onclick()
</cfif>
<td> </td>
<td> </td>
</tr>
<tr>
<cfif form.rdo_Assign eq 'ses'>
<cfif #form.hid_Proc# eq 'AT'>
<cfset tmp_date =
trim(form.hid_Sldate)>
<cfset tmp_time =
trim(form.hid_Sltime)>
<cfset tmp_dura =
trim(form.hid_Sldura)>
</cfif>
<cfoutput>
<td>Date<br><input type="text" name="cbo_Date"
size="1" style="width:80px"
value="#dateformat(trim(tm
<td>Time<br><input type="text" name="cbo_Time"
size="1" style="width:55px" value="#trim(tmp_time)#" readonly></td>
<td>Duration<br><input type="text" name="cbo_Dura"
size="1" style="width:100px" value="#trim(tmp_dura)#" readonly></td>
</cfoutput>
<cfelse>
<!--- loading date list --->
<td>Date<br>
<select name="cbo_Date" size="1"
style="width:80px">
<option value="Select">(Select)</o
<cfoutput query="cfqry_Loaddate">
<cfif #trim(tmp_date)# eq
#trim(cfqry_Loaddate.name)
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadd
<cfelse>
<option
value="#urlencodedformat(t
ate.name)#</option>
</cfif>
</cfoutput>
</select></td>
<!--- loading time list --->
<td>Time<br>
<select name="cbo_Time" size="1" style="width:55px">
<option value="Select">(Select)</o
<cfoutput query="cfqry_Loadtime">
<cfif #trim(tmp_time)# eq
#trim(cfqry_Loadtime.name)
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadt
<cfelse>
<option
value="#urlencodedformat(t
ime.name)#</option>
</cfif>
</cfoutput>
</select></td>
<!--- loading duration list --->
<td>Duration<br>
<select name="cbo_Dura" size="1" style="width:100px">
<option value="Select">(Select)</o
<cfoutput query="cfqry_Loaddura">
<cfif #trim(tmp_dura)# eq
#trim(cfqry_Loaddura.name)
<option
value="#urlencodedformat(t
selected>#trim(cfqry_Loadd
<cfelse>
<option
value="#urlencodedformat(t
ura.name)#</option>
</cfif>
</cfoutput>
</select></td>
</cfif>
<td> </td>
<td> </td>
</tr>
</table>
</center></div><div align="center"><center>
<table border="0">
<tr>
<td><input type="button" name="btn_Add" value="Add"
style="width:50px" onclick="btn_Add_onclick()
<td><input type="button" name="btn_Change" value="Change"
style="width:50px" onclick="btn_Change_onclic
<td><input type="button" name="btn_Delete" value="Delete"
style="width:50px"onclick=
<td><input type="button" name="btn_Close" value="Close"
style="width:50px" onclick="btn_Close_onclick
<td><input type="button" name="btn_Home" value="Home"
style="width:50px" onclick="btn_Home_onclick(
</tr>
</table>
<cfoutput>
<input type = "hidden" name = "hid_Logcheck" value = "0">
<input type="hidden" name="hid_Search" value="False">
<input type="hidden" name="hid_Cmode" value="#form.hid_Cmode#">
<input type="hidden" name="hid_Pinfo" value="#form.hid_Pinfo#">
<input type="hidden" name="hid_Ass" value="#form.hid_Ass#">
<input type="hidden" name="hid_Smode" value="">
<input type="hidden" name="hid_Source" value="#form.hid_Source#">
<input type="hidden" name="hid_Source1" value="#form.hid_Source1#"
<input type="hidden" name="hid_Proc" value="#form.hid_Proc#">
<input type="hidden" name="hid_Addedit" value="#hid_Addedit#">
<input type="hidden" name="hid_Stoptime"
value="#dateformat(urldeco
<!--- <input type="hidden" name="hid_Stoptime" value="##"> --->
<input type="hidden" name="hid_Sdate" value="#tmp_sdate#">
<input type="hidden" name="hid_Stime" value="#tmp_stime#">
<input type="hidden" name="hid_Sdura" value="#tmp_sdura#">
<input type="hidden" name="hid_Spmf" value="#tmp_spmf#">
<input type="hidden" name="hid_Sassign" value="#tmp_sassign#">
<input type="hidden" name="hid_Sassignval"
value="#urlencodedformat(t
<input type="hidden" name="hid_Sldate" value="#tmp_date#">
<input type="hidden" name="hid_Sltime" value="#tmp_time#">
<input type="hidden" name="hid_Sldura" value="#tmp_dura#">
<input type="hidden" name="hid_Slpmf" value="#tmp_pmf#">
<input type="hidden" name="hid_valass" value="">
<input type="hidden" name="hid_Defsarea"
value="#urlencodedformat(f
<input type="hidden" name="hid_Defses"
value="#urlencodedformat(f
<input type="hidden" name="hid_Count"
value="#urlencodedformat(f
<!--- Added by Sheeba(4 hidden)--->
<input type="hidden" name="tmp_Solnarea" >
<input type="hidden" name="hid_Calledfrm" >
<input type = "hidden" name = "cbo_Track">
<input type = "hidden" name = "tmp_Pmfkey">
</cfoutput>
</center></div>
<p> </p>
</form>
</body>
</html>
<cfif parameterexists(url.hid_So
<script language = "javascript">
frm_Edtstf.tmp_Solnarea.va
="<cfoutput>#url.tmp_Solna
frm_Edtstf.hid_Calledfrm.v
"<cfoutput>#url.hid_Called
frm_Edtstf.cbo_Track.value
"<cfoutput>#url.cbo_Track#
frm_Edtstf.hid_Source.valu
"<cfoutput>#url.hid_Source
frm_Edtstf.tmp_Pmfkey.valu
"<cfoutput>#url.tmp_Pmfkey
</script>
<cfelseif parameterexists(form.tmp_S
<script language = "javascript">
frm_Edtstf.tmp_Solnarea.va
"<cfoutput>#urlencodedform
frm_Edtstf.hid_Calledfrm.v
"<cfoutput>#urlencodedform
frm_Edtstf.cbo_Track.value
"(<cfoutput>#urlencodedfor
frm_Edtstf.tmp_Pmfkey.valu
"<cfoutput>#urlencodedform
</script>
<cfelseif parameterexists(form.cbo_S
<script language = "javascript">
frm_Edtstf.tmp_Solnarea.va
"<cfoutput>#urlencodedform
frm_Edtstf.cbo_Track.value
"<cfoutput>#urlencodedform
</script>
</cfif>
<script language="javascript">
frm_Edtstf.txt_Pmfkey.valu
frm_Edtstf.txt_Firstname.v
unescape(frm_Edtstf.txt_Fi
frm_Edtstf.txt_Lastname.va
unescape(frm_Edtstf.txt_La
frm_Edtstf.hid_Calledfrm.v
unescape(frm_Edtstf.hid_Ca
frm_Edtstf.hid_Sassignval.
unescape(frm_Edtstf.hid_Sa
</script>
<!--- Retainnig primary speaker check box value --->
<script language="javascript">
var str
str=ltrim(rtrim(unescape(f
if(str.toUpperCase() == "SPEAKER")
{
frm_Edtstf.chk_Pspeak.disa
}
else
{
frm_Edtstf.chk_Pspeak.chec
frm_Edtstf.chk_Pspeak.valu
frm_Edtstf.chk_Pspeak.disa
}
</script>
<!--- Setting focus to controls --->
<cfif form.hid_Cmode eq 'ATC' or form.hid_Cmode eq 'ALC'>
<script language="javascript">
frm_Edtstf.cbo_Assign.focu
</script>
<cfelseif form.hid_Cmode eq 'ASC' or form.hid_Cmode eq 'Staff'>
<script language="javascript">
frm_Edtstf.cbo_Assign.focu
</script>
<cfelseif form.hid_Cmode eq 'SAC'>
<script language="javascript">
frm_Edtstf.cbo_Sarea.focus
</script>
<cfelseif form.hid_Cmode eq 'AC'>
<script language="javascript">
if (frm_Edtstf.cbo_Date.type == "text")
{
frm_Edtstf.cbo_Date.text = ""
frm_Edtstf.cbo_Time.text = ""
frm_Edtstf.cbo_Dura.text = ""
}
else
{
frm_Edtstf.cbo_Date.select
frm_Edtstf.cbo_Time.select
frm_Edtstf.cbo_Dura.select
}
frm_Edtstf.cbo_Assign.focu
</script>
<cfelseif #form.hid_Cmode# eq 'SP'>
<script language="javascript">
window.focus()
frm_Edtstf.btn_Search.focu
</script>
</cfif>
<!--- Confirmation messages given --->
<cfif msg eq 1>
<cfif form.hid_Cmode eq 'ASC'>
<script language="javascript">
Err_msg(248)
frm_Edtstf.cbo_Assign.focu
</script>
</cfif>
<cfelseif msg eq 4>
<!--- <cfif form.hid_Source eq "Staff"> --->
<script language="javascript">
document.frm_Edtstf.hid_Ad
parent.Topform.document.fr
//parent.Topform.document.
parent.Topform.document.fr
parent.Topform.document.fr
'<cfoutput>#urlencodedform
frm_Edtstf.hid_Query.value
'<cfoutput>#urlencodedform
parent.Topform.document.fr
=unescape(parent.Topform.d
frm_Edtstf.hid_Query.value
parent.Topform.document.fr
</script>
<cfelseif msg eq 3>
<!--- <cfif form.hid_Source eq "Staff"> --->
<script language="javascript">
document.frm_Edtstf.hid_Ad
parent.Topform.document.fr
//parent.Topform.document.
parent.Topform.document.fr
parent.Topform.document.fr
='<cfoutput>#urlencodedfor
frm_Edtstf.hid_Query.value
'<cfoutput>#urlencodedform
parent.Topform.document.fr
=unescape(parent.Topform.d
frm_Edtstf.hid_Query.value
parent.Topform.document.fr
</script>
<cfelseif msg eq 2>
<script language="javascript">
Err_msg(248)
frm_Edtstf.cbo_Assign.focu
</script>
<cfelseif msg eq 5>
<cfif form.hid_Source eq "Staff">
<script language="javascript">
parent.Topform.document.fr
parent.Topform.document.fr
'DR'
parent.Topform.document.fr
= 0
parent.Topform.document.fr
</script>
<cfelse>
<script language="javascript">
frm_Edtstf.cbo_Sarea.focus
</script>
</cfif>
</cfif>
<cfif form.hid_Proc eq 'AT'>
<script language="javascript">
var str = "<cfoutput>#warning#</cfou
conflict)";
str = str + "\n Would you like to schedule this person given
the time considerations?"
if(confirm(str))
{
frm_Edtstf.hid_Proc.value = "ATY"
frm_Edtstf.hid_Cmode.value
ALC
frm_Edtstf.hid_Smode.value
frm_Edtstf.submit()
}
else
{
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Proc.value = ""
frm_Edtstf.hid_Cmode.value
frm_Edtstf.cbo_Sarea.focus
}
</script>
<cfelseif form.hid_Proc eq 'CT'>
<script language="javascript">
var str = "<cfoutput>#warning#</cfou
conflict)";
str = str + "\n Would you like to schedule this person given
the time considerations?"
if(confirm(str))
{
frm_Edtstf.hid_Proc.value = "CTY"
frm_Edtstf.hid_Cmode.value
ALC
frm_Edtstf.hid_Smode.value
frm_Edtstf.submit()
}
else
{
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Proc.value = ""
frm_Edtstf.cbo_Sarea.focus
}
</script>
<cfelseif form.hid_Proc eq 'ATD'>
<script language="javascript">
var str = "<cfoutput>#warning#</cfou
alert(str + " ( This is a direct conflict )");
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Proc.value = ""
frm_Edtstf.cbo_Sarea.focus
</script>
<cfelseif form.hid_Proc eq 'CTD'>
<script language="javascript">
var str = "<cfoutput>#warning#</cfou
alert(str + " ( This is a direct conflict )");
frm_Edtstf.hid_Smode.value
frm_Edtstf.hid_Proc.value = ""
frm_Edtstf.cbo_Sarea.focus
</script>
</cfif>
<cfif session.Security.Conf eq 2>
<script language="javascript">
frm_Edtstf.btn_Delete.disa
</script>
</cfif>
<cfif form.hid_Source1 eq 'Sessionmgmt'>
<!--- <script language="javascript">
frm_Edtstf.btn_Delete.disa
frm_Edtstf.btn_Change.disa
</script> --->
</cfif>
</cfif>
hahahhaha
I tend to agree w/ DreamMaster, it seems a design issue, so I'd ask on the bandwidth - is query of one line, one record able to hit the backend with all due speed. 30K can be a quick bottleneck, consider decreasing it through design (what is most likely to be retrieved most regularly.)
That's a lot of code, and thankYe for being precise and not beating around the bush, but consider posting a zero pt q in ColdFusion topic area to solicit larger audience that might 'see' things they've more experience with for the looping issues.
A more obvious gotcha is not using an index at backend. Less obvious, is using query that either works too hard to find one record, or, neglects work already done in the query itself, which leads to unnecessary repetition.
Knowing the data itself has value. Consider the lengthy if-then else like:
> "...value) == "ses")"
If this is the least likely, then it runs more tests than needed. One speed move is to mentally presort the else-if tests by likelihood of success in passing the test, code the most popular one as first test, then the remaining code is executed less.
While I assume other cleanup operations can shave milliseconds here and there, as DreamMaster indicates, doing so in the innermost loops first gets the most bang_for_the-buck.
That's a lot of code, and thankYe for being precise and not beating around the bush, but consider posting a zero pt q in ColdFusion topic area to solicit larger audience that might 'see' things they've more experience with for the looping issues.
A more obvious gotcha is not using an index at backend. Less obvious, is using query that either works too hard to find one record, or, neglects work already done in the query itself, which leads to unnecessary repetition.
Knowing the data itself has value. Consider the lengthy if-then else like:
> "...value) == "ses")"
If this is the least likely, then it runs more tests than needed. One speed move is to mentally presort the else-if tests by likelihood of success in passing the test, code the most popular one as first test, then the remaining code is executed less.
While I assume other cleanup operations can shave milliseconds here and there, as DreamMaster indicates, doing so in the innermost loops first gets the most bang_for_the-buck.
This question has been open for some time and is now in need of wrapping up.
Please DO NOT accept this comment as the answer to the question, it is purely an alert to the fact that this question is still open.
It would be greatly appreciated if any of the participants could comment back here in order to give assistance in what the status of this question is and what should be done with it (delete, 0 PAQ, award points etc).
Kindest Regards
Ant
Please DO NOT accept this comment as the answer to the question, it is purely an alert to the fact that this question is still open.
It would be greatly appreciated if any of the participants could comment back here in order to give assistance in what the status of this question is and what should be done with it (delete, 0 PAQ, award points etc).
Kindest Regards
Ant
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<indignation>
25 open questions -- 30 points offered when it is worth 100 just to read all of that
</indignation>
It is time to clean this abandoned question up.
I am putting it on a clean up list for CS.
<recommendation>
DreamMaster and Sunbow Should each be awarded the full 30 points Plus a bonus.
I will ask that the account of Thinkpad be suspended until the old questions are delat with.
</recommendation>
If anyone participating in the Q disagrees with the recommendation,
please leave a comment for the mods.
Cd&
25 open questions -- 30 points offered when it is worth 100 just to read all of that
</indignation>
It is time to clean this abandoned question up.
I am putting it on a clean up list for CS.
<recommendation>
DreamMaster and Sunbow Should each be awarded the full 30 points Plus a bonus.
I will ask that the account of Thinkpad be suspended until the old questions are delat with.
</recommendation>
If anyone participating in the Q disagrees with the recommendation,
please leave a comment for the mods.
Cd&
You will hear no bad words from me there Cd&...
Max.
Max.
Thinkpad,
These questions are still open, and our records show you have logged in recently. Further, your record of responding and closing questions is deplorable. Please resolve these immediately; continued disregard of your open questions will result in the force/acceptance of a comment as an answer, and other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days.
https://www.experts-exchange.com/questions/Q.11917258.html
https://www.experts-exchange.com/questions/Q.20003765.html
https://www.experts-exchange.com/questions/Q.20042170.html
https://www.experts-exchange.com/questions/Q.20077526.html
https://www.experts-exchange.com/questions/Q.20079298.html
https://www.experts-exchange.com/questions/Q.20080026.html
https://www.experts-exchange.com/questions/Q.20090703.html
https://www.experts-exchange.com/questions/Q.20092470.html
https://www.experts-exchange.com/questions/Q.20090755.html
https://www.experts-exchange.com/questions/Q.20094545.html
https://www.experts-exchange.com/questions/Q.20097452.html
https://www.experts-exchange.com/questions/Q.20106026.html
https://www.experts-exchange.com/questions/Q.20111855.html
https://www.experts-exchange.com/questions/Q.20122592.html
https://www.experts-exchange.com/questions/Q.11971778.html
https://www.experts-exchange.com/questions/Q.11822578.html
https://www.experts-exchange.com/questions/Q.11618338.html
https://www.experts-exchange.com/questions/Q.11520158.html
https://www.experts-exchange.com/questions/Q.11495358.html
https://www.experts-exchange.com/questions/Q.20129373.html
https://www.experts-exchange.com/questions/Q.20131212.html
https://www.experts-exchange.com/questions/Q.20094548.html
https://www.experts-exchange.com/questions/Q.20184779.html
https://www.experts-exchange.com/questions/Q.20185293.html
https://www.experts-exchange.com/questions/Q.20131218.html
https://www.experts-exchange.com/questions/Q.20206981.html
https://www.experts-exchange.com/questions/Q.20227490.html
https://www.experts-exchange.com/questions/Q.20228191.html
https://www.experts-exchange.com/questions/Q.20242801.html
https://www.experts-exchange.com/questions/Q.20247143.html
https://www.experts-exchange.com/questions/Q.20248480.html
https://www.experts-exchange.com/questions/Q.20250984.html
https://www.experts-exchange.com/questions/Q.20256536.html
https://www.experts-exchange.com/questions/Q.20256334.html
https://www.experts-exchange.com/questions/Q.20256535.html
https://www.experts-exchange.com/questions/Q.20267197.html
https://www.experts-exchange.com/questions/Q.20273340.html
https://www.experts-exchange.com/questions/Q.20274774.html
https://www.experts-exchange.com/questions/Q.20276269.html
EXPERTS: Please leave your thoughts on this question here.
Thanks,
Netminder
Community Support Moderator
Experts Exchange
These questions are still open, and our records show you have logged in recently. Further, your record of responding and closing questions is deplorable. Please resolve these immediately; continued disregard of your open questions will result in the force/acceptance of a comment as an answer, and other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days.
https://www.experts-exchange.com/questions/Q.11917258.html
https://www.experts-exchange.com/questions/Q.20003765.html
https://www.experts-exchange.com/questions/Q.20042170.html
https://www.experts-exchange.com/questions/Q.20077526.html
https://www.experts-exchange.com/questions/Q.20079298.html
https://www.experts-exchange.com/questions/Q.20080026.html
https://www.experts-exchange.com/questions/Q.20090703.html
https://www.experts-exchange.com/questions/Q.20092470.html
https://www.experts-exchange.com/questions/Q.20090755.html
https://www.experts-exchange.com/questions/Q.20094545.html
https://www.experts-exchange.com/questions/Q.20097452.html
https://www.experts-exchange.com/questions/Q.20106026.html
https://www.experts-exchange.com/questions/Q.20111855.html
https://www.experts-exchange.com/questions/Q.20122592.html
https://www.experts-exchange.com/questions/Q.11971778.html
https://www.experts-exchange.com/questions/Q.11822578.html
https://www.experts-exchange.com/questions/Q.11618338.html
https://www.experts-exchange.com/questions/Q.11520158.html
https://www.experts-exchange.com/questions/Q.11495358.html
https://www.experts-exchange.com/questions/Q.20129373.html
https://www.experts-exchange.com/questions/Q.20131212.html
https://www.experts-exchange.com/questions/Q.20094548.html
https://www.experts-exchange.com/questions/Q.20184779.html
https://www.experts-exchange.com/questions/Q.20185293.html
https://www.experts-exchange.com/questions/Q.20131218.html
https://www.experts-exchange.com/questions/Q.20206981.html
https://www.experts-exchange.com/questions/Q.20227490.html
https://www.experts-exchange.com/questions/Q.20228191.html
https://www.experts-exchange.com/questions/Q.20242801.html
https://www.experts-exchange.com/questions/Q.20247143.html
https://www.experts-exchange.com/questions/Q.20248480.html
https://www.experts-exchange.com/questions/Q.20250984.html
https://www.experts-exchange.com/questions/Q.20256536.html
https://www.experts-exchange.com/questions/Q.20256334.html
https://www.experts-exchange.com/questions/Q.20256535.html
https://www.experts-exchange.com/questions/Q.20267197.html
https://www.experts-exchange.com/questions/Q.20273340.html
https://www.experts-exchange.com/questions/Q.20274774.html
https://www.experts-exchange.com/questions/Q.20276269.html
EXPERTS: Please leave your thoughts on this question here.
Thanks,
Netminder
Community Support Moderator
Experts Exchange
Force-accepted by
Netminder
Community Support Moderator
Experts Exchange
SunBow: points for you at https://www.experts-exchange.com/jsp/qShow.jsp?qid=20275268
Netminder
Community Support Moderator
Experts Exchange
SunBow: points for you at https://www.experts-exchange.com/jsp/qShow.jsp?qid=20275268
wow.
meThinx there are lounge pts available to anyone who can accumulate this many open Q's.
Race ya there and back !!!
meThinx there are lounge pts available to anyone who can accumulate this many open Q's.
Race ya there and back !!!
hmm, now nominating: Cd&=PUCK
SunBow,
Nope. Do we get to deduct points for wrong answers? <smirk>
N
Nope. Do we get to deduct points for wrong answers? <smirk>
N
lol
Cd&
Cd&
Closing connections when they are not needed, releasing references to objects when they are not in use...etc...etc...
Personally I have no experience with Ingres as a database so I do not know if it has any issues with speed when large numbers of records are requested...although 30.000 is not all that much...
You say that your page uses a lot of looping itterations...are you sure you use the most efficient way? Sometime redesigning your loops can help a lot for performance...
That's about what springs to mind now....
Cheers,
Max.