0

This is not working for some reason it is telling me that ds_products does not exist. here is the code...
<CFQUERY NAME="products" DATASOURCE="ds_products">
SELECT ProductName
FROM tblProducts
</CFQUERY>
<html>
<head>
<title></title>
</head>
<body>
<h1>Product Listing</h1>
<ul><li><CFOUTPUT QUERY="products">
#ProductName#
</CFOUTPUT></li></ul>

</body>
</html>

2
Contributors
1
Reply
2
Views
11 Years
Discussion Span
Last Post by Walyer
0

Hey Krazykrisi,

Try this, your query is right it’s just your output

***your output was

<h1>Product Listing</h1>
<ul><li><CFOUTPUT QUERY="products">
#ProductName#
</CFOUTPUT></li></ul>

***

The mistake was here,

#ProductName#

It should have been,

# products.ProductName#

You need to include the query name with the column(s) you select within your query.
So if you were searching two things like productName and productType, their part of the output would look like

# products.productName#
# products.productType#


And if you have more than one product to display don’t forget to and a line break “<br /> after # products.ProductName#.

Good luck with everything and take care,

Walyer

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.