It could be like someone said. You are only calling stat when your id is blank. But again, if you are doing a cfcatch (I don't see that here), and dumping the URL string, you should not get this error. Unless 'stat' is some kind of reserved word in CF5, or something like that. You might also look at the useragent string for these errors. Maybe it's a specific browser/os that is causing the error, because it doesn't pass URL parameters correctly.
> -----Original Message----- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 16, 2006 12:58 PM > > Why not : > The page is called with ... index.cfm?p=partenaires&stat=P > > <CFPARAM NAME="id" DEFAULT=""> > <CFQUERY DATASOURCE=#application.applicationName# NAME="GetMembers"> > SELECT orgs.*, > logo.fileName AS orgLogo, > users.* > FROM ((orgs LEFT JOIN images AS logo ON orgs.logo = logo.imageID) > LEFT JOIN users ON orgs.orgId = users.organization) > LEFT JOIN images AS photo ON users.photo = photo.imageID > <CFIF id EQ ""> > > <!--- Error on line > below ---> > WHERE orgs.orgStatus = <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" > VALUE="#stat#"> > AND NOT ismember > <CFELSE> > WHERE orgs.orgId = <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER" > VALUE="#orgId#"> > </CFIF> > ORDER BY orgs.orgName, users.surName > </CFQUERY> > > Again, the error message : > > Error resolving parameter STAT > And the queryString is p=partenaires&stat=P [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235569 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
