Show Bid Request Database script (ASP) Bid Request Id: 11295 Bookmark in my 'To Do' list Posted by: ULTRAMARINE (0 ratings) Non-action Ratio: Very Good - 0.00% Posted: Mar 20, 2002 3:27:07 AM EDT Bidding Closes: Apr 28, 2002 3:53:06 AM EDT Viewed (by coders): 438 times Deadline: 4/29/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Windows, Database, ASP Enter chat room for this bid request (0 active users at Jul 8, 2003 9:42:56 PM EDT) Description: I'm working on a web based database project. I use ASP, Access and win 2000 (IIS 5). I Simply need a script to do the following: Users are in several groups. One is, for example in group A and the other is in group C. "One" wants to change group and become a member of group C. The system doesn't allow this UNLESS the "other" wants to change group too. The number of the members of the groups cannot be changed so the system only allows mutual changes. "you cannot change group unless there is a person who wants to go to your group" I hope this is helpful enough. The script must be running once a day...I also want automatic warnings to users participating in wrong groups (or not participate at all) as they login to the system. (I can check that). Example: A user is registered in group C but I realise that he participates (or had participated once) in group B Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Platform: Windows NT Server or Windows 2000 Server IIS 4 or IIS 5 Must be 100% finished and received by buyer on: Apr 29, 2002 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Tili (14 ratings) in Karachi, Sind Pakistan Bid id: 127,406   $15 (USD) Mar 20, 2002 4:39:58 AM EDT  9.85 (Excellent)     I'll do it .The idea is to have an extra field to show that a articular user wants to move ot other group C from A. THat field will be filled and user will have to wait untill another field is filled by other user who wants to get into C. SO now if this field is CHANGEGROUP field and there are two entries for users who want to interchange their groups then the database will allow them to change. If you have your idea to do then tell me.           See 14 private reply(ies) to/from Tili.