vchris Posted November 7, 2006 Share Posted November 7, 2006 I have a form where unapproved users are displayed, could be 1 like it could be 100. Each user has a checkbox beside him so he can be approved easily.The list returned by the check boxes is not really usable since it looks like this: test,test234.I currently have this query:UPDATE User_TableSET Approved = 1WHERE UserName IN ('#form.users#')So what I want to do with this query is set the approve field to 1 for all checked users. The problem is the list of users needs to be between quotes so sql can update them. I tried converting the list to an array and maybe I would have more power over it but I still don't know how to update the users.Any hints? Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now