iolike
asked on
Problem displaying the right results from my form to the results table
The History of this started from
https://www.experts-exchange.com/questions/21155027/Problem-building-a-Search-Interface-that-can-Search-with-more-than-one-parameter.html
Thank you for your help. I modified the query and it works fine but the result page does not seem to output the right results.
I want the users to search with ItemNo and any other data and have the result page show the search criteria. e.g if I search with ItemNo and Date, I want the reult page to show the itemno, date and any other data I want.
I have the following query for the result page:
<cfparam name="FORM.AgendaItemNo" default="">
<cfparam name="FORM.Comm_CouncilDat e" default="">
<cfparam name="FORM.Comm_CouncilNam e" default="">
<cfquery name="spResults" datasource="SpeakerCard">
SELECT *
FROM SpeakerCard
WHERE AgendaItemNo IN ('#FORM.AgendaItemNo#', '#FORM.Comm_CouncilDate#', '#FORM.Comm_CouncilName#')
ORDER BY SpeakerCard.AgendaItemNo, Comm_CouncilDate, Comm_CouncilName</cfquery>
Then I have my output table.
How do I fix this
https://www.experts-exchange.com/questions/21155027/Problem-building-a-Search-Interface-that-can-Search-with-more-than-one-parameter.html
Thank you for your help. I modified the query and it works fine but the result page does not seem to output the right results.
I want the users to search with ItemNo and any other data and have the result page show the search criteria. e.g if I search with ItemNo and Date, I want the reult page to show the itemno, date and any other data I want.
I have the following query for the result page:
<cfparam name="FORM.AgendaItemNo" default="">
<cfparam name="FORM.Comm_CouncilDat
<cfparam name="FORM.Comm_CouncilNam
<cfquery name="spResults" datasource="SpeakerCard">
SELECT *
FROM SpeakerCard
WHERE AgendaItemNo IN ('#FORM.AgendaItemNo#', '#FORM.Comm_CouncilDate#',
ORDER BY SpeakerCard.AgendaItemNo, Comm_CouncilDate, Comm_CouncilName</cfquery>
Then I have my output table.
How do I fix this
Yes, it is still unclear as to what you want to do.
>>" I want the reult page to show the itemno, date and any other data I want."
if the query works fine and you just want help outputing I would do something like this.
<cfoutput>
<table>
<tr>
<td>ItemNo</td>
<td>Date</td>
<td>Other Data</td>
</tr>
<cfloop query="spResults">
<tr class="">#iif(current mod 2,'"altbg"','""')#
<td>ItemNo</td>
<td>Date</td>
<td>Other Data</td>
</tr>
</cfloop>
</table>
</cfoutput>
if the query works fine and you just want help outputing I would do something like this.
<cfoutput>
<table>
<tr>
<td>ItemNo</td>
<td>Date</td>
<td>Other Data</td>
</tr>
<cfloop query="spResults">
<tr class="">#iif(current mod 2,'"altbg"','""')#
<td>ItemNo</td>
<td>Date</td>
<td>Other Data</td>
</tr>
</cfloop>
</table>
</cfoutput>
Perhaps showing an example of what output you are getting versus what output you want.....
Try this:
<cfparam name="form.ConNumber" default="%">
<cfparam name="form.ItemNo" default="">
<cfparam name="form.Name" default="">
<cfparam name="form.Date" default="">
<cfquery name="SearchForm" datasource="ChrisForTest">
SELECT * FROM SpeakerCard WHERE 0=0
<cfif form.ConNumber NEQ "">AND ConNumber LIKE '%#form.ConNumber#%'</cfif >
<cfif form.ItemNo NEQ "">AND ItemNo = '#form.ItemNo#'</cfif>
<cfif form.Name NEQ ""> AND Name= '#form.Name#'</cfif>
<cfif form.Date NEQ ""> AND Date = '#form.Date#'</cfif>
</cfquery>
<title>Speaker Card Search Form</title>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif;font-size: 14px;font-weight: bold;}
.style2 {font-size: 16px}
.style3 {font-family: Arial, Helvetica, sans-serif;font-size: 11px;font-weight: bold;color:#ffffff;}
-->
</style>
</head>
<body bgcolor="#CCFFFF">
<p align="center" class="style1 style2"><strong>Search Form</strong></p>
<table width="25%" align="center" >
<tr>
<td><div align="center" class="style14 style17"><strong><cfoutput >#DateForm at(Now(), "mmmm dd, yyyy")#</cfoutput> </strong></div></td>
<td><cfoutput><span class="style14 style1 style17"><strong>#TimeForm at(Now(), "hh:mm:sstt")#</strong></s pan></cfou tput></td>
</tr>
</table>
<div align="right">
<input type="submit" name="Submit2" value="Back to Menu Page" style="font:Arial, Helvetica, sans-serif; font-size:12px; font-weight:bolder" onClick="window.open('Sear chandRepor tMenu.cfm' );" onMouseOver="this.style.co lor='red'; " onMouseOut="this.style.col or='black' ;" >
</div>
<hr size="5" color="#333333">
<form action="blah.cfm?a=results " method="post" name="SearchForm" id="SearchForm">
<p align="center" class="style1">Con<br>
Number:<br>
<input name="ConNumber" type="text" id="ConNumber" size="20" maxlength="25">
<br>
<br>
Item Number/<br>
<input name="ItemNo" type="text" id="ItemNo" size="30" maxlength="35">
</p>
<p align="center" class="style1">Name:<br>
<select name="Name" size="1" id="Name">
<option value=""></option>
<cfoutput query="SearchForm">
<option value="#SearchForm.Name#"> #SearchFor m.Name#</o ption>
</cfoutput>
</select>
</p>
<p align="center" class="style1">Date:<br>
<select name="Date" size="1" id="Date">
<option value=""></option>
<cfoutput query="SearchForm">
<option value="#SearchForm.Date#"> #SearchFor m.Date#</o ption>
</cfoutput>
</select>
</p>
<p align="center" class="style1"><span class="style1">
<input type="submit" name="Submit" value="Search">
</span> </p>
</form>
<p> </p>
<cfif isdefined("url.a")>
<cfquery name="SearchForm2" datasource="ChrisForTest">
SELECT * FROM SpeakerCard WHERE 0=0
<cfif form.ConNumber NEQ "">AND ConNumber LIKE '%#form.ConNumber#%'</cfif >
<cfif form.ItemNo NEQ "">AND ItemNo = '#form.ItemNo#'</cfif>
<cfif form.Name NEQ ""> AND Name= '#form.Name#'</cfif>
<cfif form.Date NEQ ""> AND Date = '#form.Date#'</cfif>
</cfquery>
<table align="center" width="700" cellpadding="3" cellspacing="1" bgcolor="cccccc">
<tr bgcolor="808080">
<td class="style3">Con Number:</td>
<td class="style3">Item Number:</td>
<td class="style3">Name:</td>
<td class="style3">Date:</td>
</tr>
<cfoutput query="searchform2">
<tr bgcolor="ffffff">
<td>#connumber#</td>
<td>#itemno#</td>
<td>#name#</td>
<td>#date#</td>
</tr>
</cfoutput>
</table>
</cfif>
</body>
</html>
<cfparam name="form.ConNumber" default="%">
<cfparam name="form.ItemNo" default="">
<cfparam name="form.Name" default="">
<cfparam name="form.Date" default="">
<cfquery name="SearchForm" datasource="ChrisForTest">
SELECT * FROM SpeakerCard WHERE 0=0
<cfif form.ConNumber NEQ "">AND ConNumber LIKE '%#form.ConNumber#%'</cfif
<cfif form.ItemNo NEQ "">AND ItemNo = '#form.ItemNo#'</cfif>
<cfif form.Name NEQ ""> AND Name= '#form.Name#'</cfif>
<cfif form.Date NEQ ""> AND Date = '#form.Date#'</cfif>
</cfquery>
<title>Speaker Card Search Form</title>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif;font-size: 14px;font-weight: bold;}
.style2 {font-size: 16px}
.style3 {font-family: Arial, Helvetica, sans-serif;font-size: 11px;font-weight: bold;color:#ffffff;}
-->
</style>
</head>
<body bgcolor="#CCFFFF">
<p align="center" class="style1 style2"><strong>Search Form</strong></p>
<table width="25%" align="center" >
<tr>
<td><div align="center" class="style14 style17"><strong><cfoutput
<td><cfoutput><span class="style14 style1 style17"><strong>#TimeForm
</tr>
</table>
<div align="right">
<input type="submit" name="Submit2" value="Back to Menu Page" style="font:Arial, Helvetica, sans-serif; font-size:12px; font-weight:bolder" onClick="window.open('Sear
</div>
<hr size="5" color="#333333">
<form action="blah.cfm?a=results
<p align="center" class="style1">Con<br>
Number:<br>
<input name="ConNumber" type="text" id="ConNumber" size="20" maxlength="25">
<br>
<br>
Item Number/<br>
<input name="ItemNo" type="text" id="ItemNo" size="30" maxlength="35">
</p>
<p align="center" class="style1">Name:<br>
<select name="Name" size="1" id="Name">
<option value=""></option>
<cfoutput query="SearchForm">
<option value="#SearchForm.Name#">
</cfoutput>
</select>
</p>
<p align="center" class="style1">Date:<br>
<select name="Date" size="1" id="Date">
<option value=""></option>
<cfoutput query="SearchForm">
<option value="#SearchForm.Date#">
</cfoutput>
</select>
</p>
<p align="center" class="style1"><span class="style1">
<input type="submit" name="Submit" value="Search">
</span> </p>
</form>
<p> </p>
<cfif isdefined("url.a")>
<cfquery name="SearchForm2" datasource="ChrisForTest">
SELECT * FROM SpeakerCard WHERE 0=0
<cfif form.ConNumber NEQ "">AND ConNumber LIKE '%#form.ConNumber#%'</cfif
<cfif form.ItemNo NEQ "">AND ItemNo = '#form.ItemNo#'</cfif>
<cfif form.Name NEQ ""> AND Name= '#form.Name#'</cfif>
<cfif form.Date NEQ ""> AND Date = '#form.Date#'</cfif>
</cfquery>
<table align="center" width="700" cellpadding="3" cellspacing="1" bgcolor="cccccc">
<tr bgcolor="808080">
<td class="style3">Con Number:</td>
<td class="style3">Item Number:</td>
<td class="style3">Name:</td>
<td class="style3">Date:</td>
</tr>
<cfoutput query="searchform2">
<tr bgcolor="ffffff">
<td>#connumber#</td>
<td>#itemno#</td>
<td>#name#</td>
<td>#date#</td>
</tr>
</cfoutput>
</table>
</cfif>
</body>
</html>
Sorry, try this:
<cfquery name="SearchFormNames" datasource="ChrisForTest">
SELECT * FROM SpeakerCard order by name
</cfquery>
<cfquery name="SearchFormDates" datasource="ChrisForTest">
SELECT * FROM SpeakerCard order by date
</cfquery>
<title>Speaker Card Search Form</title>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif;font-size: 14px;font-weight: bold;}
.style2 {font-size: 16px}
.style3 {font-family: Arial, Helvetica, sans-serif;font-size: 11px;font-weight: bold;color:#ffffff;}
-->
</style>
</head>
<body bgcolor="#CCFFFF">
<p align="center" class="style1 style2"><strong>Search Form</strong></p>
<table width="25%" align="center" >
<tr>
<td><div align="center" class="style14 style17"><strong><cfoutput >#DateForm at(Now(), "mmmm dd, yyyy")#</cfoutput> </strong></div></td>
<td><cfoutput><span class="style14 style1 style17"><strong>#TimeForm at(Now(), "hh:mm:sstt")#</strong></s pan></cfou tput></td>
</tr>
</table>
<div align="right">
<input type="submit" name="Submit2" value="Back to Menu Page" style="font:Arial, Helvetica, sans-serif; font-size:12px; font-weight:bolder" onClick="window.open('Sear chandRepor tMenu.cfm' );" onMouseOver="this.style.co lor='red'; " onMouseOut="this.style.col or='black' ;" >
</div>
<hr size="5" color="#333333">
<form action="blah.cfm?a=results " method="post" name="SearchForm" id="SearchForm">
<p align="center" class="style1">Con<br>
Number:<br>
<input name="ConNumber" type="text" id="ConNumber" size="20" maxlength="25">
<br>
<br>
Item Number/<br>
<input name="ItemNo" type="text" id="ItemNo" size="30" maxlength="35">
</p>
<p align="center" class="style1">Name:<br>
<select name="Name" size="1" id="Name">
<option value=""></option>
<cfoutput query="SearchFormNames">
<option value="#SearchFormNames.Na me#">#Sear chFormName s.Name#</o ption>
</cfoutput>
</select>
</p>
<p align="center" class="style1">Date:<br>
<select name="Date" size="1" id="Date">
<option value=""></option>
<cfoutput query="SearchFormDates">
<option value="#SearchFormDates.Da te#">#Sear chFormDate s.Date#</o ption>
</cfoutput>
</select>
</p>
<p align="center" class="style1"><span class="style1">
<input type="submit" name="Submit" value="Search">
</span> </p>
</form>
<p> </p>
<cfif isdefined("url.a")>
<cfquery name="SearchForm2" datasource="ChrisForTest">
SELECT * FROM SpeakerCard WHERE 0=0
<cfif form.ConNumber NEQ "">AND ConNumber LIKE '%#form.ConNumber#%'</cfif >
<cfif form.ItemNo NEQ "">AND ItemNo = '#form.ItemNo#'</cfif>
<cfif form.Name NEQ ""> AND Name= '#form.Name#'</cfif>
<cfif form.Date NEQ ""> AND Date = '#form.Date#'</cfif>
</cfquery>
<table align="center" width="700" cellpadding="3" cellspacing="1" bgcolor="cccccc">
<tr bgcolor="808080">
<td class="style3">Con Number:</td>
<td class="style3">Item Number:</td>
<td class="style3">Name:</td>
<td class="style3">Date:</td>
</tr>
<cfoutput query="searchform2">
<tr bgcolor="ffffff">
<td>#connumber#</td>
<td>#itemno#</td>
<td>#name#</td>
<td>#date#</td>
</tr>
</cfoutput>
</table>
</cfif>
</body>
</html>
<cfquery name="SearchFormNames" datasource="ChrisForTest">
SELECT * FROM SpeakerCard order by name
</cfquery>
<cfquery name="SearchFormDates" datasource="ChrisForTest">
SELECT * FROM SpeakerCard order by date
</cfquery>
<title>Speaker Card Search Form</title>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif;font-size: 14px;font-weight: bold;}
.style2 {font-size: 16px}
.style3 {font-family: Arial, Helvetica, sans-serif;font-size: 11px;font-weight: bold;color:#ffffff;}
-->
</style>
</head>
<body bgcolor="#CCFFFF">
<p align="center" class="style1 style2"><strong>Search Form</strong></p>
<table width="25%" align="center" >
<tr>
<td><div align="center" class="style14 style17"><strong><cfoutput
<td><cfoutput><span class="style14 style1 style17"><strong>#TimeForm
</tr>
</table>
<div align="right">
<input type="submit" name="Submit2" value="Back to Menu Page" style="font:Arial, Helvetica, sans-serif; font-size:12px; font-weight:bolder" onClick="window.open('Sear
</div>
<hr size="5" color="#333333">
<form action="blah.cfm?a=results
<p align="center" class="style1">Con<br>
Number:<br>
<input name="ConNumber" type="text" id="ConNumber" size="20" maxlength="25">
<br>
<br>
Item Number/<br>
<input name="ItemNo" type="text" id="ItemNo" size="30" maxlength="35">
</p>
<p align="center" class="style1">Name:<br>
<select name="Name" size="1" id="Name">
<option value=""></option>
<cfoutput query="SearchFormNames">
<option value="#SearchFormNames.Na
</cfoutput>
</select>
</p>
<p align="center" class="style1">Date:<br>
<select name="Date" size="1" id="Date">
<option value=""></option>
<cfoutput query="SearchFormDates">
<option value="#SearchFormDates.Da
</cfoutput>
</select>
</p>
<p align="center" class="style1"><span class="style1">
<input type="submit" name="Submit" value="Search">
</span> </p>
</form>
<p> </p>
<cfif isdefined("url.a")>
<cfquery name="SearchForm2" datasource="ChrisForTest">
SELECT * FROM SpeakerCard WHERE 0=0
<cfif form.ConNumber NEQ "">AND ConNumber LIKE '%#form.ConNumber#%'</cfif
<cfif form.ItemNo NEQ "">AND ItemNo = '#form.ItemNo#'</cfif>
<cfif form.Name NEQ ""> AND Name= '#form.Name#'</cfif>
<cfif form.Date NEQ ""> AND Date = '#form.Date#'</cfif>
</cfquery>
<table align="center" width="700" cellpadding="3" cellspacing="1" bgcolor="cccccc">
<tr bgcolor="808080">
<td class="style3">Con Number:</td>
<td class="style3">Item Number:</td>
<td class="style3">Name:</td>
<td class="style3">Date:</td>
</tr>
<cfoutput query="searchform2">
<tr bgcolor="ffffff">
<td>#connumber#</td>
<td>#itemno#</td>
<td>#name#</td>
<td>#date#</td>
</tr>
</cfoutput>
</table>
</cfif>
</body>
</html>
Sorry, keep adding more and more features on to this: =)
<cfquery name="SearchFormNames" datasource="ChrisForTest">
SELECT * FROM SpeakerCard order by name
</cfquery>
<cfquery name="SearchFormDates" datasource="ChrisForTest">
SELECT * FROM SpeakerCard order by date
</cfquery>
<title>Speaker Card Search Form</title>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif;font-size: 14px;font-weight: bold;}
.style2 {font-size: 16px}
.style3 {font-family: Arial, Helvetica, sans-serif;font-size: 11px;font-weight: bold;color:#ffffff;}
-->
</style>
</head>
<body bgcolor="#CCFFFF">
<p align="center" class="style1 style2"><strong>Search Form</strong></p>
<table width="25%" align="center" >
<tr>
<td><div align="center" class="style14 style17"><strong><cfoutput >#DateForm at(Now(), "mmmm dd, yyyy")#</cfoutput> </strong></div></td>
<td><cfoutput><span class="style14 style1 style17"><strong>#TimeForm at(Now(), "hh:mm:sstt")#</strong></s pan></cfou tput></td>
</tr>
</table>
<div align="right">
<input type="button" name="Submit2" value="Back to Menu Page" style="font:Arial, Helvetica, sans-serif; font-size:12px; font-weight:bolder" onClick="window.open('Sear chandRepor tMenu.cfm' );" onMouseOver="this.style.co lor='red'; " onMouseOut="this.style.col or='black' ;" >
</div>
<hr size="5" color="#333333">
<form action="report.cfm?a=resul ts" method="post" name="SearchForm" id="SearchForm">
<p align="center" class="style1">Con<br>
Number:<br>
<input name="ConNumber" type="text" id="ConNumber" size="20" maxlength="25">
<br>
<br>
Item Number/<br>
<input name="ItemNo" type="text" id="ItemNo" size="30" maxlength="35">
</p>
<p align="center" class="style1">Name:<br>
<select name="Name" size="1" id="Name">
<option value=""></option>
<cfoutput query="SearchFormNames" group="name">
<option value="#SearchFormNames.Na me#">#Sear chFormName s.Name#</o ption>
</cfoutput>
</select>
</p>
<p align="center" class="style1">Date:<br>
<select name="Date" size="1" id="Date">
<option value=""></option>
<cfoutput query="SearchFormDates" group="date">
<option value="#SearchFormDates.Da te#">#Sear chFormDate s.Date#</o ption>
</cfoutput>
</select>
</p>
<p align="center" class="style1"><span class="style1">
<input type="submit" name="Submit" value="Search">
</span> </p>
</form>
<p> </p>
<cfif isdefined("url.a")>
<cfquery name="SearchForm2" datasource="ChrisForTest">
SELECT * FROM SpeakerCard WHERE 0=0
<cfif form.ConNumber NEQ "">AND ConNumber LIKE '%#form.ConNumber#%'</cfif >
<cfif form.ItemNo NEQ "">AND ItemNo = '#form.ItemNo#'</cfif>
<cfif form.Name NEQ ""> AND Name= '#form.Name#'</cfif>
<cfif form.Date NEQ ""> AND Date = '#form.Date#'</cfif>
</cfquery>
<cfif SearchForm2.RecordCount EQ 0>
<script language="javascript">
alert('Your search found 0 records');
self.location='report.cfm' ;
</script>
</cfif>
<table align="center" width="700" cellpadding="3" cellspacing="1" bgcolor="cccccc">
<tr bgcolor="808080">
<td class="style3">Con Number:</td>
<td class="style3">Item Number:</td>
<td class="style3">Name:</td>
<td class="style3">Date:</td>
</tr>
<cfoutput query="searchform2">
<tr bgcolor="ffffff">
<td>#connumber#</td>
<td>#itemno#</td>
<td>#name#</td>
<td>#date#</td>
</tr>
</cfoutput>
</table>
</cfif>
<script language="javascript">
document.SearchForm.ConNum ber.focus( );
</script>
</body>
</html>
<cfquery name="SearchFormNames" datasource="ChrisForTest">
SELECT * FROM SpeakerCard order by name
</cfquery>
<cfquery name="SearchFormDates" datasource="ChrisForTest">
SELECT * FROM SpeakerCard order by date
</cfquery>
<title>Speaker Card Search Form</title>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif;font-size: 14px;font-weight: bold;}
.style2 {font-size: 16px}
.style3 {font-family: Arial, Helvetica, sans-serif;font-size: 11px;font-weight: bold;color:#ffffff;}
-->
</style>
</head>
<body bgcolor="#CCFFFF">
<p align="center" class="style1 style2"><strong>Search Form</strong></p>
<table width="25%" align="center" >
<tr>
<td><div align="center" class="style14 style17"><strong><cfoutput
<td><cfoutput><span class="style14 style1 style17"><strong>#TimeForm
</tr>
</table>
<div align="right">
<input type="button" name="Submit2" value="Back to Menu Page" style="font:Arial, Helvetica, sans-serif; font-size:12px; font-weight:bolder" onClick="window.open('Sear
</div>
<hr size="5" color="#333333">
<form action="report.cfm?a=resul
<p align="center" class="style1">Con<br>
Number:<br>
<input name="ConNumber" type="text" id="ConNumber" size="20" maxlength="25">
<br>
<br>
Item Number/<br>
<input name="ItemNo" type="text" id="ItemNo" size="30" maxlength="35">
</p>
<p align="center" class="style1">Name:<br>
<select name="Name" size="1" id="Name">
<option value=""></option>
<cfoutput query="SearchFormNames" group="name">
<option value="#SearchFormNames.Na
</cfoutput>
</select>
</p>
<p align="center" class="style1">Date:<br>
<select name="Date" size="1" id="Date">
<option value=""></option>
<cfoutput query="SearchFormDates" group="date">
<option value="#SearchFormDates.Da
</cfoutput>
</select>
</p>
<p align="center" class="style1"><span class="style1">
<input type="submit" name="Submit" value="Search">
</span> </p>
</form>
<p> </p>
<cfif isdefined("url.a")>
<cfquery name="SearchForm2" datasource="ChrisForTest">
SELECT * FROM SpeakerCard WHERE 0=0
<cfif form.ConNumber NEQ "">AND ConNumber LIKE '%#form.ConNumber#%'</cfif
<cfif form.ItemNo NEQ "">AND ItemNo = '#form.ItemNo#'</cfif>
<cfif form.Name NEQ ""> AND Name= '#form.Name#'</cfif>
<cfif form.Date NEQ ""> AND Date = '#form.Date#'</cfif>
</cfquery>
<cfif SearchForm2.RecordCount EQ 0>
<script language="javascript">
alert('Your search found 0 records');
self.location='report.cfm'
</script>
</cfif>
<table align="center" width="700" cellpadding="3" cellspacing="1" bgcolor="cccccc">
<tr bgcolor="808080">
<td class="style3">Con Number:</td>
<td class="style3">Item Number:</td>
<td class="style3">Name:</td>
<td class="style3">Date:</td>
</tr>
<cfoutput query="searchform2">
<tr bgcolor="ffffff">
<td>#connumber#</td>
<td>#itemno#</td>
<td>#name#</td>
<td>#date#</td>
</tr>
</cfoutput>
</table>
</cfif>
<script language="javascript">
document.SearchForm.ConNum
</script>
</body>
</html>
Woops, this is using the database fields from your last question. Will modify to work for this question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what is borken? The question is not clear.
If you want to dispaly the form field in teh table you can do like from query it will be like that... if you want form variable then replace queryname.variable with form.youravariable
<cfoutput>
<table>
<tr>
<td>
#spresutls.yourvariable#
</td>
</tr>
<table>
</cfoutput>
Regards,
---Pinal