Member Avatar for krazykrisi

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
  • 131 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by Walyer
Member Avatar for Walyer

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.