DD Error: The request has exceeded the allowable time limit Tag: CFLOOP
Hi, I have just purchased Web Assist, followed all instructions and get the following error at the following webpage:
www.amdramtheatre.com.test.cfm, here is the code:
<cfquery name="qGetGroupsandShowsandShows" datasource="amdram">
SELECT memberID, memberGroupName, showID, showName
FROM tblmembers, tblshow
WHERE memberTypeINT = 1
AND memberActive = 1
AND showActive = 1
</cfquery>
<cfsilent>
<cfif (qGetGroupsandShowsandShows.RecordCount GT 0) >
<cfset WA_DDArray = "<script>" & Chr(13)&Chr(10) &"var WAJA = new Array();" & Chr(13)&Chr(10)>
<cfset oldmainid = 0>
<cfset newmainid = qGetGroupsandShowsandShows.memberID>
<cfif (NOT IsNumeric(newmainid))>
<cfset newmainid = ToString(newmainid)>
</cfif>
<cfif (oldmainid EQ newmainid) >
<cfset oldmainid = "">
</cfif>
<cfset n=-1>
<cfloop query="qGetGroupsandShowsandShows">
<cfset newmainid = qGetGroupsandShowsandShows.memberID>
<cfif (oldmainid NEQ newmainid)>
<cfset n=n+1>
<cfset WA_DDArray = WA_DDArray & "WAJA["&n&"] = new Array();" & Chr(13)&Chr(10) & "WAJA["&n&"][0] = '"&WA_DD_Replace(ToString(newmainid))&"';" & Chr(13)&Chr(10)>
<cfset m=1>
</cfif>
<cfset WA_DDArray = WA_DDArray & "WAJA["&n&"]["&m&"] = new Array();" & Chr(13)&Chr(10) & "WAJA["&n&"]["&m&"][0] = '" & WA_DD_Replace(ToString(qGetGroupsandShowsandShows.showID)) & "';" & Chr(13)&Chr(10) & "WAJA["&n&"]["&m&"][1] = '"&WA_DD_Replace(ToString(qGetGroupsandShowsandShows.showName))&"';" & Chr(13)&Chr(10)>
<cfset m=m+1>
<cfset oldmainid = newmainid>
<cfif (NOT IsNumeric(newmainid)) >
<cfset newmainid = ToString(newmainid)>
</cfif>
</cfloop>
<cfset WA_DDArray = WA_DDArray & "var qGetGroupsandShowsandShows_WAJA = WAJA;" & Chr(13)&Chr(10) & "WAJA = null;" & Chr(13)&Chr(10) & "</script>"& Chr(13)&Chr(10)>
</cfif>
<cffunction name="WA_DD_Replace">
<cfargument name="startStr" type="string" required="true">
<cfset startStr = Replace(startStr, "'", "|WA|")>
<cfset startStr = Replace(startStr, "\\", "\\\\")>
<cfreturn startStr>
</cffunction>
</cfsilent>
<cfoutput>#WA_DDArray#</cfoutput>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script type="text/javascript">
<!--
function WA_ClientSideReplace(theval,findvar,repvar) {
var retval = "";
while (theval.indexOf(findvar) >= 0) {
retval += theval.substring(0,theval.indexOf(findvar));
retval += repvar;
theval = theval.substring(theval.indexOf(findvar) + String(findvar).length);
}
retval += theval;
if (retval == "" && theval.indexOf(findvar) < 0) {
retval = theval;
}
return retval;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function WA_UnloadList(thelist,leavevals,bottomnum) {
while (thelist.options.length > leavevals+bottomnum) {
if (thelist.options[leavevals]) {
thelist.options[leavevals] = null;
}
}
return leavevals;
}
function WA_FilterAndPopulateSubList(thearray,sourceselect,targetselect,leaveval,bottomleave,usesource,delimiter) {
if (bottomleave > 0) {
leaveArray = new Array(bottomleave);
if (targetselect.options.length >= bottomleave) {
for (var m=0; m<bottomleave; m++) {
leavetext = targetselect.options[(targetselect.options.length - bottomleave + m)].text;
leavevalue = targetselect.options[(targetselect.options.length - bottomleave + m)].value;
leaveArray[m] = new Array(leavevalue,leavetext);
}
}
else {
for (var m=0; m<bottomleave; m++) {
leavetext = "";
leavevalue = "";
leaveArray[m] = new Array(leavevalue,leavetext);
}
}
}
startid = WA_UnloadList(targetselect,leaveval,0);
mainids = new Array();
if (usesource) maintext = new Array();
for (var j=0; j<sourceselect.options.length; j++) {
if (sourceselect.options[j].selected) {
mainids[mainids.length] = sourceselect.options[j].value;
if (usesource) maintext[maintext.length] = sourceselect.options[j].text + delimiter;
}
}
for (var i=0; i<thearray.length; i++) {
goodid = false;
for (var h=0; h<mainids.length; h++) {
if (thearray[i][0] == mainids[h]) {
goodid = true;
break;
}
}
if (goodid) {
theBox = targetselect;
theLength = parseInt(theBox.options.length);
theServices = thearray[i].length + startid;
var l=1;
for (var k=startid; k<theServices; k++) {
if (l == thearray[i].length) break;
theBox.options[k] = new Option();
theBox.options[k].value = thearray[i][l][0];
if (usesource) theBox.options[k].text = maintext[h] + WA_ClientSideReplace(thearray[i][l][1],"|WA|","'");
else theBox.options[k].text = WA_ClientSideReplace(thearray[i][l][1],"|WA|","'");
l++;
}
startid = k;
}
}
if (bottomleave > 0) {
for (var n=0; n<leaveArray.length; n++) {
targetselect.options[startid+n] = new Option();
targetselect.options[startid+n].value = leaveArray[n][0];
targetselect.options[startid+n].text = leaveArray[n][1];
}
}
for (var l=0; l < targetselect.options.length; l++) {
targetselect.options[l].selected = false;
}
if (targetselect.options.length > 0) {
targetselect.options[0].selected = true;
}
}
//-->
</script>
</head>
<body>
<form action="memberhome.cfm" method="get" name="frm_bio">
<select name="allgroups" id="allgroups" onchange="WA_FilterAndPopulateSubList(qGetGroupsandShowsandShows_WAJA,MM_findObj('allgroups'),MM_findObj('allshows'),0,0,false,': ')">
<cfoutput query="qGetGroupsandShowsandShows">
<option value="#qGetGroupsandShowsandShows.memberID#">#qGetGroupsandShowsandShows.memberGroupName#</option>
</cfoutput>
</select>
<select name="allshows" id="allshows">
<cfoutput query="qGetGroupsandShowsandShows">
<option value="#qGetGroupsandShowsandShows.showID#">#qGetGroupsandShowsandShows.showName#</option>
</cfoutput>
</select>
</form>
</body>
</html>