Ian Vaughan wrote: > > Just run what you sent, no errors returned but do not think that parameter 2 > is not working as it has again not been populated.
Just modify your first query so it returns rows. > What are the benefits of doing it your way ?? Speed and security. > Queries > > UserGroups (Records=0, Time=27ms) > SQL = > SELECT * FROM usergroupmembership, groups WHERE UserID = 75 > AND > usergroupmembership.groupid = groups.groupid Aparently UserID 75 is not a member of any groups. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
