I need help with cf coding.
This should be very simple. All I want to do is display the price of the item that I choose in my HTML code. Here is what I came up with but it doesn't work. I get an error.
<cfquery name="prodpricing" datasource="#Request.DS#" username="#user#" password="#pass#">
WHERE ProdID= #product#
I can tell something is wrong but I can't figure it out. Thanks. I attached an excel file for my table.