<cfparam name="url.id" question?

Report · Nov 23, 2011

My question: why am i able to see some items display and not others when the id of the url.id changes

I have a page listing items of which each item links to a master detail page of the single product. the master detail page will display on some items when clicked. howver the master detail page will not display on other item that are clicked. the master detail page has only one syntax structure so the only thing that changes is the url.id that is passed to it from my first page

(i.e.

THIS SHOWS THE CORRECT DISPLAY http://localhost:8500/shotthp/Product_Order_page.cfm?proid=66

THIS SHOWS NOTHING http://localhost:8500/shotthp/Product_Order_page.cfm?proid=67

Please note also note the the database exist and has all of the information populated

<a href="Product_Order_page.cfm?proid=#proid#" class="product_name">#product.proname#</a>

SELECT *

FROM discount

</cfquery>

SELECT *

FROM product, catagory, subcatagory

WHERE product.proid = <cfqueryparam value="#URL.proid#" cfsqltype="cf_sql_numeric">

AND product.procatagoryid = catagory.catid

AND product.prosubcatid = subcatagory.subcatid

Group by product.proname

</cfquery>

<body>

<img src="<cfoutput>#product.proimage#</cfoutput>" alt="" name="proimage" width="358" height="477" class="whiteBorder" />

<span class="product_name">#product.proname#</span><br />

Item No: #product.proid#<br /><br />

<span class="lable_product_name">Name</span><span class="price">Price</span> <span class="qty">Qty.</span><br />

</div><br />

<cfif #product.proprice# eq ""><span class="lable_product_name">Call For Pricing</span>

<cfelse><span class="lable_product_name">#product.proname# </span><span class="label_price">#DollarFormat(product.proprice)#</span>

</cfif>

</select><br>

<br />

<span class="lable_product_name">#product.proitem2#</span><input name="proitem2" type="hidden" value="#product.proitem2#" />

<span class="label_price">#DollarFormat(product.proitem2price)#</span><input name="proitem2price" type="hidden" value="#product.proitem2price#" />

</select><br>

<span class="lable_product_name">#product.proitem3#</span><input name="proitem3" type="hidden" value="#product.proitem3#" />

<span class="label_price">#DollarFormat(product.proitem3price)#</span><input name="proitem3price" type="hidden" value="#product.proitem3price#" />

</select><br>

<span class="lable_product_name">#product.proitem4#</span>:<input name="proitem4" type="hidden" value="#product.proitem4#" />

<span class="label_price">#DollarFormat(product.proitem4price)#</span>:<input name="proitem4price" type="hidden" value="#product.proitem4price#" />

</select><br>-------------------------<br /></cfif>

</div>

</div>

</cfoutput>

</div>

</div>

</div>

</form>

<cf_footer>

</div>

</body>

</html>

Report · Nov 23, 2011

Disclaimer I only skimmed the thread as that is too much code to wade through.

WHERE product.proid = <cfqueryparam value="#URL.proid#" cfsqltype="cf_sql_numeric">
AND product.procatagoryid = catagory.catid
AND product.prosubcatid = subcatagory.subcatid

When you are not seeing the expected output of a query, the first thing to do is cfdump the query object. If it is empty, it is most likely an issue with the query (or underlying data). Query the "product" table (only) for prodid=67. If that record is not found, the problem is your data. Otherwise, it is most likely a problem with your JOIN.

INNER joins only pick up items that have matching records in all of the referenced tables. So in your case it would only return products that are assigned to a category AND have one or more subcategories. If you want to include all products, regardless of whether they have matching categories/subcategories you need to use an OUTER join instead.

http://www.w3schools.com/SQl/sql_join.asp

Report · Nov 23, 2011

Thanks for your help. The CFdump helped me to pinpoint an mis-types syntax. I really appreciate you assistance. Thanks again.

Report · Nov 23, 2011

Yep, cfdump is a great debugging tool. Glad you figured things out.

-Leigh

Report · Nov 30, 2011

Looking at your ColdFusion code, I see that you are using # to dereference variables where you do not actually need to use the # mark.

You can actually rewrite this ColdFusion statement so that it is like the following:

This will work equally well, also the following are examples of not having to use the # characters with your string:

Michael G. Workman

mworkman@usbid.com

http://www.usbid.com

http://ic.locate-ic.com