Show Bid Request RecordID Increment & Post Bid Request Id: 4911 Bookmark in my 'To Do' list Posted by: (0 ratings) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Good Approved on: Nov 13, 2001 3:25:49 PM EDT Bidding Closes: Nov 27, 2001 3:26:57 PM EDT Viewed (by coders): 726 times 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: Database, Cold Fusion Enter chat room for this bid request (0 active users at Aug 17, 2003 7:34:46 AM EDT) Description: I've got a website that uses an Access 2000 database and Cold Fusion. I have a Trouble Report form already working but now need to add a unique RecordID to each form for later lookup by user as well as updating by Trouble Team Members. I'd like to make the RecordID a combination of Julian Date, last two digits of year and unique sequential number. This Record ID will show up on a confirmation page as well as be added to the database. I will be designing a search function around this RecordID. This shouldn't be too big of task for the experienced...just too big for me! Deliverables: I need the few lines of code to add to my forms as well as the database design structure (ie. new fields, formats, etc.) to be able to make this work. I will provide table as is and coder can add fields as needed. I will also provide existing html (cfml) for entry and action form of website. The code needs to grab the ReportDate (Julian + last two digits of year), stick the last record number to the end of it and make it the RecordID. If the coder has a better way to create this RecordID, I'm open for suggestions. I'd like it to have some meaning if possible so I thought the date was best. A simple increment task? Once it all works, the checks in the mail! Special Conditions / Other: I've got an end of the year deadline for the whole project so the quicker the better for this segment. 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! Anuj Gakhar (60 ratings) in Ludhiana, Punjab India Bid id: 51,592 $30 (USD) Nov 13, 2001 10:08:14 PM EDT  9.97 (Excellent)     I have done what u wanted. Please read the attached file..theres a file readme.txt in there. Thanks. Attached File           See 2 private reply(ies) to/from Anuj Gakhar.