No output from query...

ivalum21 · Aug 9, 2004

I run my query below, but I don't get any output. I outputted the URL.CatID to be sure that was getting passed, and it is...so it has to be something with my output statement.

Help please!

Code:

<cfquery name="GetQuestion" datasource="FAQ">
	SELECT *
	FROM FAQQandA
	WHERE FAQID = #URL.CatID#
</cfquery>

<html>
<head>
	<title>Compliance FAQ</title>
</head>

<body>
<cfoutput>
	<td>
	<b>#FAQQuestion#</b><br>
	<i>#FAQAnswer#</i>
	</td>
</cfoutput>

inlandpac · Aug 9, 2004

try this:

Code:

<cfdump var="#GetQuestion#">

and see if you are getting anything from your resultset.

ICQ: 54380631

grtfercho · Aug 9, 2004

Code:

<cfoutput  [b]query="GetQuestion"[/b]>

<!---all your statements here--->
</cfoutput>

try that and see if it works.

grtfercho çB^]\..
"Imagination is more important than Knowledge" A. Einstein
-----------------------------------------------

http://www.llajta.com

ecobb · Aug 9, 2004

grtfercho is right, you need to tell you're <cfoutput> tags what they're supposed to output.

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

ivalum21 · Aug 9, 2004

Well...I tried all of your suggestions, and I still get no output. When I used the <cfdump>, it displayed the headings of my columns, but no data.

And I put in the <cfoutput query> tags...and I still got nothing.

Any ideas?

ecobb · Aug 9, 2004

Then there must not be a record in the database matching the URL.CatID that you're passing.

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

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!

No output from query...

ivalum21

MIS

inlandpac

Programmer

grtfercho

Programmer

ecobb

Programmer

ivalum21

MIS

ecobb

Programmer

Similar threads

Part and Inventory Search

Sponsor