How Software Gets Done  


(No Login on Secured Page)

Custom Software Buyers
Request new bids
Search Coders
My Account
 
My Buyer 'To Do' List
 
My bid requests
  My escrow account
 
My General Info
Verification
 
Help for Buyers
Articles for Buyers
FAQ for Buyers
Latest News
 

Custom Software Coders

Newest open work
Browse all work
Search all work
My Account
 
My Coder 'To Do' List
 
My bids
 
My General Info
  My credit account
 
Help for Coders
Articles for Coders
FAQ for Coders
Latest News
 

Affiliates

My account
 
My pipeline
 
My credit account
 
Help for Affiliates
Latest News
 
Newest Open Bid Requests.
Anti-spam mail system
By Incentral on May 14
Max Bid: Open to fair suggestions


Icon Creation for Storefront
By kweather on May 14
Max Bid: $200


Listing website
By Ty Marler on May 14
Max Bid: Open to fair suggestions


Software Clone
By Taz8U on May 14
Max Bid: $500


Win 9X/2000/XP Print Driver
By Trinity Solutions on May 14
Max Bid: $100


e- governance report
By gioulh on May 14
Max Bid: $80


Click here to put this ticker on your own site

Open Work Categories.
Database 
(138 open)
   Access 
(62 open)
   MySQL 
(71 open)
   Oracle 
(10 open)
   SQL Server 
(56 open)
   Other DB 
(18 open)
Documentation / Tech Writing 
(38 open)
Data Entry 
(20 open)
Game Development 
(25 open)
Graphics / Art / Music 
(53 open)
   Graphics 
(62 open)
     3d Animation 
(13 open)
   Art (Misc.) 
(24 open)
   Music 
(6 open)
   3d Modeling 
(8 open)
Language Specific 
(108 open)
   ASP 
(69 open)
   C# 
(39 open)
   C++ / C 
(124 open)
   Cold Fusion 
(7 open)
   Delphi 
(34 open)
   Java 
(58 open)
   Perl 
(34 open)
   PHP 
(91 open)
   XML/XSL 
(24 open)
   Visual Basic 
(143 open)
   Visual Basic .Net 
(77 open)
   Other 
(61 open)
Misc 
(51 open)
   CAD 
(2 open)
MultiMedia 
(42 open)
Network 
(42 open)
   Network Design 
(10 open)
   Network Implementation 
(15 open)
Platforms 
(66 open)
   Windows 
(149 open)
     MS Exchange 
(4 open)
     MS Office 
(15 open)
     Other 
(7 open)
   Darwin 
(1 open)
   Internet Browser 
(46 open)
   Linux 
(44 open)
   UNIX 
(22 open)
   Hand Held/PDA Programming 
(13 open)
Requirements 
(12 open)
Security 
(37 open)
Testing / Quality Assurance 
(20 open)
Web 
(165 open)
   Page Design 
(88 open)
   Flash 
(59 open)
   Web Services 
(79 open)
   Web (Other) 
(95 open)
Training 
(12 open)
   Computer Based 
(16 open)
 
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

Update Query in Access
Bid Request Id: 28842
Bookmark in my 'To Do' list
Posted by: GTE (6 ratings)
(Software buyer rating 10)
Non-action Ratio: Very Good - 11.11%
Posted: Sep 26, 2002
5:53:47 PM EDT
Bidding Closes: Sep 28, 2002
5:59:37 PM EDT
Viewed (by coders): 341 times
Deadline: 9/29/2002
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: Database
Enter chat room for this bid request
(0 active users at May 14, 2003 2:55:54 PM EDT)

Description:
I am in need of an update query that will look in one column within a table and if that column does NOT contain a valid year I want to be able to choose betwen a first choice, second choice or third choice a year to be placed there. I need this as soon as possible and am will give bonuses based on turnaround and the actually performance of the query.

Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Complete ownership and distribution copyrights to all work purchased.



Platform:
windows nt/xp

Must be 100% finished and received by buyer on:
Sep 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.

Special Conditions / Other:
It would be ideal to have this query within 12 hours. But, no later than 09/27/02 at 9a.m. I will reward generously via bonus for the immediate turnaround.


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  
rryerson
(3 ratings)
in Akron, Ohio
United States
Bid id: 324,817
 
N/A Sep 27, 2002
1:22:05 AM EDT
 10
(Excellent)
   
Hello,

My name is Richard Ryerson. I am a Senior Developer with over 7 years experience developing custom solutions.

I have to tell you what you are asking is really unfeasable for several reasons. First of all, update queries are atomic, meaning that if something adversely, such as a cancel, happens after 1000 records have been updated (within page size) the whole thing is rolled back. Secondly, unless the table only contains a MINIMUM amount for invalid years, that this method would be right. (Imagine being prompted 10,000 times if the query find 10,000 records with invalid dates) Third, how are you planning to determine the correct year? In an update query that prompts you, you will not be able to see any of the data pertaining to that particular record. (Absolutely NOT possible)

On a more promising note, here are a few things for you to ponder.

1. If there is a way, anyway at all, that we can determine the correct date from the record, we can use that to update the data. No user intervention besides a confirmation involved.

2. If not, I can deliver you a custom application that will present you the incorrect data and allow you to make the changes in a list / grid style. (I would use VB 6 probably or create an Access form it fit well)

3. How is the data formatted? Is this year field an integer, a 2 or 4 digit text, part of a larger sized text field or is it inserted in a memo field?

In closing, if you can answer me these questions, I am prepare to make a bid of $25.00 for the update query (considering good database design and we can hash out a method to determine the correct date) or I will bid $75.00 for a custom app / Access form for the grid / list style update 'method.'

Best regards,

Richard Ryerson
 
 
 
 
  See 4 private reply(ies)
to/from rryerson.
 




Quick Search
 

 Advanced Search
Newest Open Work
Latest News

 
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 

Rent A Coder Top Coders.


Anuj Gakhar
Rated a 9.98 on 92 jobs 
Securenext
Rated a 9.98 on 97 jobs 
Codman
Rated a 9.97 on 141 jobs 
Buddies
Rated a 9.82 on 76 jobs 
Andrei Remenchuk
Rated a 10 on 12 jobs 
Michael Sharp
Rated a 9.98 on 171 jobs 
RNA
Rated a 9.93 on 36 jobs 
teleCODERS
Rated a 9.93 on 67 jobs 
hernest
Rated a 10 on 109 jobs 
markesh
Rated a 10 on 21 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers
 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 


Affiliate Sites



Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright © 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.