Why are you doing this query of queries??? What is it that you are trying to accomplish which you don't think can be done in the one single query, "getCatalog"? Are you really running that whole getCatalog query when you don't need all of the items?
--Ferg Sharon Creese wrote: ><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? >> >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216163 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
