little help please ;)

wxdqz · Aug 22, 2008

I'm trying to search 2 databases with 1 input....

Here are the 2 forms that are used to search the seperate databases.
----------------------------------------------------------
<HTML>
<HEAD>
<TITLE>Account Verification</TITLE>
</HEAD>
<BODY bgcolor="#FFFFFF">

<P ALIGN="center">
<CENTER>
<H2>Customer Maintenance Options</H2>
<H2>(Account Verification)</H2>
<HR align="center">
<H3>Enter the customer's <FONT COLOR="#ff0000">mobile number</FONT> or their <FONT COLOR="#ff0000">account number, billing system, market and district</FONT> below:</H3>
<BR>
<FORM ACTION="/jstage_mgr/plsql/jstage_meprofile.verify_acct" METHOD="post">
<INPUT TYPE="hidden" NAME="page_type" VALUE=http://www.webdeveloper.com/forum/archive/index.php/"'CF'">
<TABLE 0 cellpadding=0 width="357">
<TR>
<TD width="77">Mobile Number:</TD>
<TD ALIGN="left"><INPUT TYPE="text" NAME="p_npa" SIZE="3" MAXLENGTH="3"> - <INPUT TYPE="text" NAME="p_nxx" SIZE="3" MAXLENGTH="3"> - <INPUT TYPE="text" NAME="p_line" SIZE="4" MAXLENGTH="4"></TD>
</TR>
</TABLE>
<BR>
<H4>OR</H4>
<BR>
<TABLE 0 cellpadding=0 width="357">
<TR>
<TD width="77">Account #:</TD>
<TD width="214"><INPUT TYPE="text" NAME="p_acct" SIZE="20" MAXLENGTH="20"></TD>
</TR>
<TR>
<TD width="77">Billing System:</TD>
<TD width="214"><select name="p_host"><option>PRISM</option> <option>OMNI</option> <option>ACTION</option> </select></TD>
</TR>
<TR>
<TD width="77">Market:</TD>
<TD width="214"><select name="p_mkt"><option>LA</option> <option>NC</option> <option>SD</option> <option>MI</option> <option>OH</option> <option>WR</option> </select></TD>
</TR>
<TR>
<TD width="77">District:</TD>
<TD width="214"><select name="p_dist"><option>AN</option> <option>LA</option> <option>NC</option> <option>NV</option> <option>SD</option> <option>OH</option> <option>MI</option> <option>WR</option> </select></TD>
</TR>
</TABLE>
<BR>
<INPUT TYPE="submit" VALUE=http://www.webdeveloper.com/forum/archive/index.php/"Find Account">
<BR>
<BR>
<HR align="center">
<BR>
</CENTER>
</BODY>
</HTML>

INPUT 2

<LINK rel="STYLESHEET" href="../include/verizon.css" type="text/css"/>
<LINK rel="STYLESHEET" href="../include/ecare2.css" type="text/css"/>
<SCRIPT LANGUAGE="JavaScript" SRC="../include/validateForm.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../include/checkInput.js"></SCRIPT>

<html>
<head>
<title>Retail Account Search</title>
</head>
<body bgcolor="#FFFFFF" text="#000000" onLoad="document.retailaccountsearchform.mobileNumber.focus();">
<form method="post" action="retailaccountresult" name="retailaccountsearchform" onSubmit="if (checkInput(document.retailaccountsearchform)==false) return false;">
<table width="90%" border="0">
<tr>
<td colspan="2" align="center" class="sectitle">VZServe Customer Database Search</td>
</tr>
<tr>
<td colspan="2" align="center" class="pdkred">No results found.</td>
</tr>
<tr>
<td colspan="2">Please enter either the wireless number <b>or</b> the account number to begin your search:</td>
</tr>
<tr>
<td width="50%" align="right">Wireless Number </td>
<td width="*" align="left"><input type="text" name="mobileNumber" size="10" maxlength="10" /></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td align="right">Account Number </td>
<td align="left"><input type="text" name="accountNumber" size="15" maxlength="15" /></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="Submit" value="Submit"/>
<input type="reset" name="Clear" value="Clear"/></td>
</tr>
</table>
</form>
</body>
</html>
-------------------------------------------------------------------

Here is what I was trying to work with with no success:
*********************************************

<HTML><HEAD><TITLE> Test </TITLE></HEAD><BODY>

<form action="" target="" name=f method="post" enctype="application/x-www-form-urlencoded" >
<table cellspacing=0 cellpadding=0>
<tr>
<td align=center>
<input type="text" name="mobileNumber" size="10" maxlength="10" />
<br><input type='button' value=http://www.webdeveloper.com/forum/archive/index.php/"Search" onclick='submitthem()'>
</td>
</tr></table></form>

<SCRIPT>
function submitthem()
{
var f = document.forms["f"];

var w1 = window.open('about :blank','trg1','location=yes,menubar=yes;height='+
screen.height+';width='+(screen.width / 2))
w1.focus();
var w2 = window.open('about :blank','trg2','location=yes,menubar=yes;height='+
screen.height+';width='+(screen.width / 2))
w2.moveTo((screen.width / 2),0)
w2.focus();

f.action = 'http://app1.idc.vzwcorp.com:5191/login/user/retailaccountresult'; //the 1st site
f.target = 'trg1'; //the 1st window name
f.submit();

f.action = 'http://hayes.idc.vzwcorp.com:9009/jstage_mgr/plsql/jstage_meprofile.verify_acct'; //the 2nd site
f.target = 'trg2'; //the 2nd window name
f.submit();

}
</SCRIPT></BODY></HTML>

**************************************************
*****

little help please ;)

wxdqz

New Member