I have been able to search from one table at a time per the fieldname.
I have been able to create a table on the site that is coming from different
tables in the database.
Now, I want to search that created table on the site that is created by
reading fields from different tables on the database.
I have my input textfield and my search button at the top of the page.
Below that I have the table with all the records that come from different
tables in the database.
When I enter a parameter to search for in the textfield and then click on
search, I get a javascript error.
Line 64, Char 1: Object doesn't support this property or method.
This is the line 64:</db:dbform>
This is the ending of the inner DBFORM 2. Please see code.
Here is the code:
<%@ taglib uri="/WEB-INF/dbForms.tld" prefix="db" %>
<HTML>
<HEAD>
<db:base/>
<TITLE>Payers Worksheet</TITLE>
</HEAD>
<BODY BGCOLOR="#ffffff">
<db:errors />
<H1>VA Health Care Insurance Verification</H1>
<P><HR ALIGN=LEFT></P>
<P><TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="2">
<%@ include file="navbar.jsp" %>
<TD>
<H3>Select Payers Worksheet</H3>
<P>For payer names like "A*" and all communications
partners</P>
<table border="1" cellspacing="0" cellpadding="2">
<db:dbform id="dbform" tableName="PAYER" maxRows="*"
followUp="select_worksheet2.jsp" autoUpdate="false">
<db:header>
<TR>
<td valign="top">Payer Name:</td>
<td valign="top"><input name="<%=searchFieldNames_PAYER.get("NAME") %>"
type="text" size="30"></td>
</TR>
</db:header>
<db:body></db:body>
<db:footer>
<tr>
<td><input value="Search" type="button"
onClick="javascript:document.dbform.submit()"></td>
</tr>
</db:footer>
</db:dbform>
</TABLE>
<P>See the bottom of the list for empty rows into which you may
enter new payers.</P>
<table>
<db:dbform tableName="PARTNERS_APPLICATIONS_PAYERS" orderBy="PAYER_PKEY"
maxRows="*" followUp="select_worksheet_searchable.jsp" autoUpdate="true">
<db:header>
<TR>
<TH>Payer Name</TH>
<TH>VA ID</TH>
<TH>Communications Partner</TH>
<TH>Eligibility ID</TH>
<TH>Hospital ID</TH>
<TH>Professional ID</TH>
</TR>
</db:header>
<db:body>
<!-- Here is the beginning of the dbforms 2 -->
<db:dbform id="dbform" tableName="PAYER" maxRows="*"
parentField="PAYER_PKEY" childField="PAYER_PKEY"
followUp="select_payers_worksheet_searchable.jsp" autoUpdate="true">
<db:header></db:header>
<db:body>
<tr>
<td><db:dataLabel fieldName="NAME" /></td>
<td><db:dataLabel fieldName="VA_NATIONAL_PAYER_ID" /></td>
</db:body>
<db:footer></db:footer>
</db:dbform>
<!-- end of dbforms2 -->
<TD VALIGN="TOP"><db:select fieldName="COMMUNICATIONS_PARTNER_PKEY">
<db:tableData name="CPName" foreignTable="COMMUNICATIONS_PARTNER"
visibleFields="NAME" storeField="COMMUNICATIONS_PARTNER_PKEY"/>
</db:select>
</TD>
<TD VALIGN="TOP">
<db:textField fieldName="PAYER_ID"/>
</TD>
<!-- this is the beginning of dbform 3 inner -->
<db:dbform id="dbform" tableName="PAYER" maxRows="*"
parentField="PAYER_PKEY" childField="PAYER_PKEY"
followUp="/iiv/select_payers_worksheet_searchable.jsp" autoUpdate="true">
<db:header></db:header>
<db:body>
<TD VALIGN="TOP"><db:textField fieldName="PROFESSIONAL_CLAIMS_ID"/></TD>
<TD VALIGN="TOP"><db:textField fieldName="INSTITUTIONAL_CLAIMS_ID"/></TD>
</db:body>
<db:footer></db:footer>
</db:dbform>
<!--end of dbforms 3-->
</TR>
</db:body>
<db:footer></db:footer>
</db:dbform>
<!-- end of dbforms1 -->
</TABLE>
</table>
</BODY>
</HTML>
-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
