it will work for product ids of : ABCD1 12-1234 AB-123 123-A23-123
But not for 12-34-17 ----- Original Message ----- From: "Russ" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, August 23, 2005 10:04 PM Subject: RE: URL string not working... HELP! > Hmm... you're doing a query of queries... this might be a bug with that... > have you tried doing the same thing on the db? What version of CF are you > using and have you tried all the latest hotfixes? > > -----Original Message----- > From: Sharon Creese [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 23, 2005 10:49 PM > To: CF-Talk > Subject: Re: URL string not working... HELP! > > sorry about that. Here is what I have now but it fails for everything. > > > <!----get product details-------> > <cfparam type="string" name="tempVar"> > > <cfset tempVar = #URL.thisProduct#> > > <cfquery name="getProductDetail" dbtype="query"> > SELECT ProductID, ProductName, Price, LongDescription, LargeImage,Company > FROM getCatalog > WHERE ProductID = '#tempVar#' > </cfquery> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:216137 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
