Show Bid Request Fix ASP Script Bid Request Id: 68038 Bookmark in my 'To Do' list Posted by: Handy Productions (85 ratings) (Software buyer rating 9.98) Non-action Ratio: Very Good - 12.37% Buyer Security Verifications: Excellent Approved on: Jun 12, 2003 6:42:29 AM EDT Bidding Closes: Jun 14, 2003 6:41:38 AM EDT Viewed (by coders): 40 times Deadline: 6/17/2003 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: ASP Enter chat room for this bid request (0 active users at Aug 1, 2003 1:26:49 AM EDT) Description: We need some changes to a small (less than 250 line) ASP/VBScript script that works as a crude report generator. Stage 1 lets the user enter a SQL statement. Stage 2 shows the fields and a list of fields with checkboxes that allow the removal of a field, and gives the option to "subtotal on change" for fields that appear in the "order by" clause, and "total" for numeric fields. Stage 3 displays the results. We need the following changes: 1. Currently in Stage 2 it only allows the user to select "subtotal on change" for fields that appear in the ORDER BY clause. Also, It works when 1 is selected, but when more than 1 is selected it does not work properly, and there is no way to specify the order. We would therefore like a) The checkboxes replaced with 3 dropdown lists that show all fields. Default to "None". b) Automatic modification of the ORDER BY clause - i.e. the first (up to) 3 fields should be the ones selected for "subtotal when change". If they already appear elsewhere in the ORDER BY then they need to be removed. c) Fix the display code so that it works correctly. 2. The "Total" option always works ok, however when a null value appears the total comes out as blank. We would prefer for it to ignore NULL values, but add an "*" to the total to indicate that a NULL appeared. 3. We'd like the result table to be centered, and some cell padding as the field names run next to each other at present. Deliverables: 1) Complete and fully-functional working script. 2) Complete ownership and distribution copyrights to all work purchased. Platform: IIS/ASP Must be 100% finished and received by buyer on: Jun 17, 2003 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! Smart Buzz (20 ratings) in Panchkula, Haryana India Bid id: 728,270   $55 (USD) Jun 12, 2003 6:49:31 AM EDT  9.9 (Excellent)     Accept this bid and you will get the finished product in less then 2 days time. Please check out our latest feedbacks which will tell you about our ability in ASP. Looking to hear a positive response from your side and we are ready to start on this project immediately. Thanks,           See 5 private reply(ies) to/from Smart Buzz.