Am using IDC/HTX via ODBC. Have 4 tables, and they are linked by a primary key (LFDO😎. I am able to do a fname, lname, and dob search, and it works wonderfully. I then select the name, and it retrieves the names again, but this time with the arrest number (for the first table). I then select one of those names to get the details (arrest date, release date, etc.), and I get a blank page!!!!
On my arrestdata.idc:
+SELECT LFDOB.LFDOB, LFDOB.LastName , LFDOB.FirstName, tblArsData.ArsIncNbr, tblArsData.ArsCaseNbr,
+tblArsData.ArsWarNo, tblArsData.ArsArrestNo, tblArsData.ArsDate, tblArsData.ArsTime, tblArsData.ArsOfficer,
+tblArsData.ArsAddress
+FROM LFDOB INNER JOIN tblArsData ON LFDOB.LFDOB = tblArsData.LFDOB
+WHERE tblArsData.LFDOB = '%LFDOB%'
on my arrestdata.htx:
<%begindetail%>
<%if CurrentRecord EQ 0 %>
<h2>Here are the selected contents of the RMSCAD database:</h2>
<p>
<%endif%>
<a href="ArrestDetail.idc?LFDOB=<%LFDOB%> "> <b><%ArsArrestNo%> <%LFDOB%> </b></a>
<p>
<%enddetail%>
on my arrestdetail.idc:
Template:ArrestDetail.htx
SQLStatement:
+SELECT tblArsData.ArsAgency, tblArsData.ArsIncNbr, tblArsData.ArsCaseNbr, tblArsData.ArsWarNo,
+tblArsData.ArsArrestNo, tblArsData.ArsDate, tblArsData.ArsTime, tblArsData.ArsOfficer, tblArsData.ArsRights,
+tblArsData.ArsFacial, tblArsData.ArsTeeth, tblArsData.ArsAddress
+FROM LFDOB LEFT JOIN tblArsData ON LFDOB.LFDOB = tblArsData.LFDOB
+WHERE tblArsData.LFDOB = '%LFDOB%'
on my arrestdtail.htx:
<h1>Arrest Database</h1>
<font size=2>
<h2>Here are contact details for <%LFDOB%>:<br>
<font size=1>
ArsAgency:<%ArsAgency%><BR>
ArsIncNbr:<%ArsIncNbr%><BR>
ArsCaseNbr:<%ArsCaseNbr%><BR>
ArsWarNo: <%ArsWarNo%><BR>
ArsArrestNo: <%ArsArrestNo%><BR>
ArsDate: <%ArsDate%><BR>
ArsTime: <%ArsTime%><BR>
ArsOfficer: <%ArsOfficer%><BR>
ArsRights: <%ArsRights%><BR>
ArsDrugQty: <%ArsDrugQty%><BR>
<hr>
<%EndDetail%>
<hr>
<p>
<a href="LFDOBLookupName.htm">Query RMSCAD Database</a>
Can anyone offer any suggestions as to where I am making my mistake????
Thank you so much!!!!
