<cfquery name="getcatalog" datasource="#Request.App.datasource#"> SELECT PC.CategoryID, C.CategoryName, PC.SubCatID, PC.ProductID, SC.SubCatName, P.ProductName, P.ShortDescription, P.LongDescription, P.Price,P.SmallImage, P.LargeImage,P.Status,P.Company,p.proddoc FROM ProductsCategories PC,Categories C,SubCategories SC,Products P WHERE C.CategoryID = PC.CategoryID AND SC.SubCatID = PC.SubCatID AND P.ProductID = PC.ProductID AND P.Status = 'Yes' ORDER BY P.ProductName </cfquery>
<cfquery name="getProductDetail" dbtype="query"> SELECT ProductID, ProductName, Price, LongDescription, LargeImage,Company FROM getCatalog WHERE ProductID = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#URL.thisProduct#"> </cfquery> ERROR: There is a problem with the page you are trying to reach and it cannot be displayed. HTTP 500 - Internal server error Internet Explorer ----- Original Message ----- From: "Russ" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, August 23, 2005 11:01 PM Subject: RE: URL string not working... HELP! > Can you post the new code you're using? Also what error are you getting? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216160 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
