query results display twice - why???

MtnGirl · Mar 3, 2002

This seems like it should be fairly simple. I queried a database and want to display the results in a table but what I'm getting is the results of the query totally unformatted and comma delimited above the table on the web page. Then the table displays correctly underneath. Why are the results of the query displaying twice? I'm really new to this but I thought you would only see the results of your query if you used CFOUTPUT tags. So why is it showing up outside of these tags? I'd appreciate any help. Seems like it should be something simple. My code is below.

Thanks so much!

<CFSET temp.begindate = "#form.month#/#form.day#/#form.year#">
<CFQUERY NAME="resbydates" DATASOURCE="newaen1">
SELECT MEMNAME, ResumeID, rDate, rEmpPrefTitle, memid
FROM resumeview
WHERE rDate = #createodbcdate(temp.BeginDate)#
</CFQUERY>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
<title>Resumes By Date</title>
</head>

<body>
<table border="0" cellpadding="3" cellspacing="0" width="600">
<tr>
<td width=100>Job Reference Number
</td>
<td width=100>Job Listing ID
</td>
<td width=100>Job Title
</td>
<td width=100>Applicant ID
</td>
<td width=100>Applicant Name
</td>
<td width=100>Resume ID
</td>
</tr>

<CFOUTPUT QUERY="resbydates">
<tr>
<td width=100> </td>
<td width=100> </td>
<td width=100>#rEmpPrefTitle#</td>
<td width=100>#memid#</td>
<td width=100>#MEMNAME#</td>
<td width=100>#ResumeID#</td>
#rEmpPrefTitle#, #memid#, #MEMNAME#, #ResumeID#
</tr>
</CFOUTPUT>

</table>
</body>
</html>

DeZiner · Mar 3, 2002

<CFOUTPUT QUERY="resbydates">
<tr>
<td width=100> </td>
<td width=100> </td>
<td width=100>#rEmpPrefTitle#</td>
<td width=100>#memid#</td>
<td width=100>#MEMNAME#</td>
<td width=100>#ResumeID#</td>
#rEmpPrefTitle#, #memid#, #MEMNAME#, #ResumeID#
</tr>
</CFOUTPUT>

This is not in a cell therefore showing at the top of the table
DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

MtnGirl · Mar 3, 2002

Thank you! I knew it had to be something simple. Guess I've been at the computer too long today.

Thanks again!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

query results display twice - why???

MtnGirl

Programmer

DeZiner

Programmer

MtnGirl

Programmer

Similar threads

Part and Inventory Search

Sponsor