works from query analyzer ----- Original Message ----- From: "Russ" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, August 23, 2005 10:22 PM Subject: RE: URL string not working... HELP!
> The other question was have you tried doing the same query straight from the > database, not query of queries... if it works from the database, then it's a > QoQ problem. There might be some hotfixes available that fix this, for > example, are you running updater 1? > > Here is a list of macromedia hotfixes: > > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17883 > > And there might be workarounds for the issue as well... have you tried using > cfqueryparam like somebody suggested? > > Russ > > -----Original Message----- > From: Sharon Creese [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 23, 2005 11:11 PM > To: CF-Talk > Subject: Re: URL string not working... HELP! > > Server Product > ColdFusion MX > > Version > 6,1,0,63958 > > > > what is the other question > > ----- Original Message ----- > From: "Russ" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Tuesday, August 23, 2005 10:12 PM > Subject: RE: URL string not working... HELP! > > > > You still havent' answered either of my questions... > > > > -----Original Message----- > > From: Sharon Creese [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, August 23, 2005 11:04 PM > > To: CF-Talk > > Subject: Re: URL string not working... HELP! > > > > 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> > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:216141 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
