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
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235568
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
