Gossamer Forum
Home : Products : DBMan : Customization :

How to DBman Custom Search Output this way?

Quote Reply
How to DBman Custom Search Output this way?
Hello!
I need help on how to display the results like below:
There are overall 34 Fields. I need Field1 thru Field Field8 and again Field27 thru Field34 to be shown only once in the results page.

Field9 thru Field26 belong to each record thats output via search as such I need mutiple records ( each conatining Filed9 thru Field26) to be printed out one below the other say if there are 8 matches then i wwant those 8 matches to show within the same fram one under the other.

below is the layout HTML so that you can understand better perhaps if the above dont make much sense.

I would appreciate any help that I can get on this right away.
Thanks for your assiatance in anticipation.

Regards
Tera

----------------------LAYOUT HTML -------------------------

<table border="0" width="100%" bgcolor="#99CCFF">
<tr>
<td width="100%" bgcolor="#3399FF">
<table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td width="12%" bgcolor="#99CCFF">
<p align="left"><b><font face="Arial" size="2" color="#000000">Field1</font></b></td>
<td width="12%" bgcolor="#99CCFF"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field1" SIZE="10" VALUE="$rec{'Field1'}" MAXLENGTH="20"></font></td>
<td width="12%" bgcolor="#99CCFF">
<p align="center"><b><font face="Arial" size="2" color="#000000">Field2</font></b></td>
<td width="12%" bgcolor="#99CCFF"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field2" SIZE="10" VALUE="$rec{'Field2'}" MAXLENGTH="255"></font></td>
<td width="13%" bgcolor="#99CCFF">
<p align="center"><b><font face="Arial" size="2" color="#000000">Field3</font></b></td>
<td width="13%" bgcolor="#99CCFF"><font color="#000000">|</font><font face="Arial" size="2" color="#000000"><INPUT NAME="Field3" SIZE="10" VALUE="$rec{'Field3'}" MAXLENGTH="255"></font></td>
<td width="13%" bgcolor="#99CCFF">
<p align="center"><b><font face="Arial" size="2" color="#000000">Field4</font></b></td>
<td width="13%" bgcolor="#99CCFF"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field4" SIZE="10" VALUE="$rec{'Field4'}" MAXLENGTH="20"></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bordercolor="#99CCFF">
<table border="0" cellpadding="0" cellspacing="0" width="104%">
<tr>
<td width="15%" bgcolor="#99CCFF" align="left">
<p align="left"><font face="Arial" size="2"><b>Field5</b></font></td>
<td width="19%" bgcolor="#99CCFF" align="left"><INPUT NAME="Field5" SIZE="20" VALUE="$rec{'Field5'}" MAXLENGTH="50"></td>
<td width="9%" bgcolor="#99CCFF" align="left">
<p align="center"><font face="Arial" size="2"><b>Field6</b></font></td>
<td width="12%" bgcolor="#99CCFF" align="left"><INPUT NAME="Field6" SIZE="10" VALUE="$rec{'Field6'}" MAXLENGTH="20"></td>
<td width="12%" bgcolor="#99CCFF" align="left">
<p align="center"><font face="Arial" size="2"><b>Field7</b></font></td>
<td width="12%" bgcolor="#99CCFF" align="left"><INPUT NAME="Field7" SIZE="10" VALUE="$rec{'Field7'}" MAXLENGTH="20">
</td>
<td width="14%" bgcolor="#99CCFF" align="left">
<p align="center"><font face="Arial" size="2"><b>Field8</b></font></td>
<td><INPUT NAME="Field8" SIZE="5" VALUE="$rec{'Field8'}" MAXLENGTH="20"></td>
<td width="13%" bgcolor="#99CCFF" align="left">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#FFCCCC" align="left">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" width="103%">
<tr>
<td width="8%" align="center"><font face="Arial" size="1"><b>Field9</b></font></td>
<td width="20%" align="center"><font face="Arial" size="1"><b>Field10</b></font></td>
<td width="25%" align="center"><b><font face="Arial" size="1">Field11</font></b></td>
<td width="15%" align="center"><font face="Arial" size="1"><b>Field12</b></font></td>
<td width="15%" align="center"><font face="Arial" size="1"><b>Field13</b></font></td>
<td width="6%" align="center"><font face="Arial" size="1"><b>Field14</b></font></td>
<td width="15%" align="center"><font face="Arial" size="1"><b>Field15</b></font></td>
</tr>
<tr>
<td width="8%" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field9" SIZE="3" VALUE="$rec{'Field9'}" MAXLENGTH="20"></font></td>
<td width="20%" align="center"><INPUT NAME="Field10" SIZE="20" VALUE="$rec{'Field10'}" MAXLENGTH="50"></td>
<td width="25%" align="center"><INPUT NAME="Field11" SIZE="20" VALUE="$rec{'Field11'}" MAXLENGTH="50"></td>
<td width="15%" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field12" SIZE="10" VALUE="$rec{'Field12}" MAXLENGTH="255"></font></td>
<td width="15%" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field13" SIZE="10" VALUE="$rec{'Field13'}" MAXLENGTH="255"></font></td>
<td width="6%" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field14" SIZE="2" VALUE="$rec{'Field14}" MAXLENGTH="255"></font></td>
<td width="15%" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field15" SIZE="10" VALUE="$rec{'Field15'}" MAXLENGTH="255"></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%" height="37">
<tr>
<td width="8%" align="center" height="16"><font face="Arial" size="1"><b>Field16</b></font></td>
<td width="9%" align="center" height="16"><font face="Arial" size="1"><b>Field17</b></font></td>
<td width="11%" align="center" height="16"><font face="Arial" size="1"><b>Filed18</b></font></td>
<td width="9%" align="center" height="16"><font face="Arial" size="1"><b>Field19</b></font></td>
<td width="10%" align="center" height="16"><font face="Arial" size="1"><b>Field20</b></font></td>
<td width="7%" align="center" height="16"><font face="Arial" size="1"><b>Field21</b></font></td>
<td width="10%" align="center" height="16"><font face="Arial" size="1"><b>Field22</b></font></td>
<td width="18%" align="center" height="16"><font face="Arial" size="1"><b>Field23</b></font></td>
<td width="8%" align="center" height="16"><font face="Arial" size="1"><b>Field24</b></font></td>
<td width="10%" align="center" height="16"><font face="Arial" size="1"><b>Field25</b></font></td>
<td width="10%" align="center" height="16"><font face="Arial" size="1"><b>Field26</b></font></td>
</tr>
<tr>
<td width="8%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field16" SIZE="5" VALUE="$rec{'Field16'}" MAXLENGTH="20"></font></td>
<td width="9%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field17" SIZE="5" VALUE="$rec{'Field17'}" MAXLENGTH="20"></font></td>
<td width="11%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field18" SIZE="5" VALUE="$rec{'Field18'}" MAXLENGTH="20"></font></td>
<td width="9%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field19" SIZE="5" VALUE="$rec{'Field19'}" MAXLENGTH="20"></font></td>
<td width="10%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field20" SIZE="5" VALUE="$rec{'Field20'}" MAXLENGTH="20"></font></td>
<td width="7%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field21" SIZE="5" VALUE="$rec{'Field21'}" MAXLENGTH="20"></font></td>
<td width="10%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field22" SIZE="5" VALUE="$rec{'Field22'}" MAXLENGTH="20"></font></td>
<td width="18%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field23" SIZE="15" VALUE="$rec{'Field23'}" MAXLENGTH="20"></font></td>
<td width="8%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field24" SIZE="5" VALUE="$rec{'Field24'}" MAXLENGTH="20"></font></td>
<td width="10%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field25" SIZE="5" VALUE="$rec{'Field25'}" MAXLENGTH="20"></font></td>
<td width="10%" height="21" align="center"><font face="Arial" size="2" color="#000000"><INPUT NAME="Field26" SIZE="10" VALUE="$rec{'Field26'}" MAXLENGTH="20"></font></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#FF9966">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="12%">
<p align="left"><font face="Arial" size="2"><b>Field27</b></font></td>
<td width="12%"><INPUT NAME="Field27" SIZE="10" VALUE="$rec{'Field27'}" MAXLENGTH="20" style="background-color: #FF9966; border-style: solid; border-color: #FF9966"></td>
<td width="12%">
<p align="center"><font face="Arial" size="2"><b>Filed28</b></font></td>
<td width="12%"><INPUT NAME="Field28" SIZE="10" VALUE="$rec{'Field28'}" MAXLENGTH="20"></td>
<td width="13%">
<p align="center"><font face="Arial" size="2"><b>Field29</b></font></td>
<td width="13%"><INPUT NAME="Field29" SIZE="10" VALUE="$rec{'Field29'}" MAXLENGTH="20"></td>
<td width="13%">
<p align="center"><font face="Arial" size="2"><b>Field30</b></font></td>
<td width="13%"><INPUT NAME="Field30" SIZE="10" VALUE="$rec{'Field30'}" MAXLENGTH="20"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#FF9966">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="12%"><font face="Arial" size="2"><b>Field31</b></font></td>
<td width="12%"><INPUT NAME="Field31" SIZE="10" VALUE="$rec{'Field31'}" MAXLENGTH="20"></td>
<td width="12%">
<p align="center"><font face="Arial" size="2"><b>Field 32</b></font></td>
<td width="12%"><INPUT NAME="Field32" SIZE="10" VALUE="$rec{'Field32'}" MAXLENGTH="20"></td>
<td width="13%">
<p align="center"><font face="Arial" size="2"><b>Field 33</b></font></td>
<td width="13%"><INPUT NAME="Field33" SIZE="10" VALUE="$rec{'Field33'}" MAXLENGTH="20"></td>
<td width="13%">
<p align="center"><font face="Arial" size="2"><b>Field34</b></font></td>
<td width="13%"><INPUT NAME="Field34" SIZE="10" VALUE="$rec{'Field34'}" MAXLENGTH="20"></td>
</tr>
</table>
</td>
</tr>
</table>
</html>

--------------------- END OF LAYOUT HTML ------------------