Hi All
I know this is probably something small but it is frustrating me no end!
I am trying to generate a nested repeat region but all I am getting at the moment is every record from the recordset openedits being displayed instead of just the ones relating to the recordset openreqs.
See code below:
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/itreqdb.
asp" -->
<%
var openreqs__MMColParam = "1";
if (String(Session("MM_userna
me")) != "undefined" &&
String(Session("MM_usernam
e")) != "") {
openreqs__MMColParam = String(Session("MM_usernam
e"));
}
%>
<%
var openreqs = Server.CreateObject("ADODB
.Recordset
");
openreqs.ActiveConnection = MM_itreqdb_STRING;
openreqs.Source = "SELECT fullrequestdata.reqid, fullrequestdata.dateadded,
users.user, users.username, users.centrename, fullrequestdata.loggeduser
, fullrequestdata.centre, fullrequestdata.reportedby
, fullrequestdata.priority, fullrequestdata.requesttyp
e, fullrequestdata.affecting,
fullrequestdata.errorcode,
fullrequestdata.descriptio
n FROM users, fullrequestdata WHERE users.username = '"+ openreqs__MMColParam.repla
ce(/'/g, "''") + "' AND users.user = fullrequestdata.loggeduser
AND fullrequestdata.requesttyp
e IN (1, 2)";
openreqs.CursorType = 0;
openreqs.CursorLocation = 2;
openreqs.LockType = 1;
openreqs.Open();
var openreqs_numRows = 0;
%>
<%
var openedits = Server.CreateObject("ADODB
.Recordset
");
openedits.ActiveConnection
= MM_itreqdb_STRING;
openedits.Source = "SELECT * FROM editdata";
openedits.CursorType = 0;
openedits.CursorLocation = 2;
openedits.LockType = 1;
openedits.Open();
var openedits_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
openreqs_numRows += Repeat1__numRows;
%>
<%
var Repeat2__numRows = -1;
var Repeat2__index = 0;
openedits_numRows += Repeat2__numRows;
%>
<body>
<% while ((Repeat1__numRows-- != 0) && (!openreqs.EOF)) { %>
<table width="80%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td><%=(openreqs.Fields.It
em("reqid"
).Value)%>
</td>
<td><%=(openreqs.Fields.It
em("datead
ded").Valu
e)%></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>
<%
FilterParam = openreqs.Fields.Item("reqi
d").Value
openedits.Filter = "reid = " & FilterParam
while ((Repeat2__numRows-- != 0) && (!openedits.EOF)){
%><td>
<%=(openedits.Fields.Item(
"dateadded
").Value)%
>;
</td>
<%
Repeat2__index++;
openedits.MoveNext();
}
%>
</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<%
Repeat1__index++;
openreqs.MoveNext();
}
%>
<p> </p>
</body>
