Show Bid Request
ASP Database Search Result Problem
Bid Request Id: 8621
|
|
|
|
Posted by: |
donaldt (7 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Below Average - 50.00%
|
|
Posted: |
Feb 9, 2002
2:54:08 AM EDT
|
|
Bidding Closes: |
Feb 23, 2002
3:01:08 AM EDT
|
|
Viewed (by coders): |
825 times
|
|
Deadline: |
2/11/2002
TIME EXPIRED
|
|
|
|
|
Description:
I am performing a search on a single table database from an asp page.
The SQL as below from is from the recordset, on returning the results it will leave out any record(s) that have a null value.
The SQL is as follows:
SELECT Title, FirstName, surname, CompanyName, BusinessType, JobTitle, Department, Address_1, Address_2, Address_3, Address_4, country, Postcode, WorkTel, Workfax, MobileTel, Email, EuropeanCommittee, NationalNetworkRep, EuroDefiContact, NationaNetworkManagement, WebAddress
FROM tbl_Members
WHERE Surname LIKE 'txtsurname%' AND country LIKE 'txtcountry%' AND CompanyName LIKE 'txtcompany%' AND Address_4 LIKE 'txttown%'
ORDER BY Surname
I have attached the search and results page, plus database.
The database is access 2000 and Ultradev 4 is used for the web stuff.
I need someone to correct the coding where as needed.
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:
The database is access 2000 and Ultradev 4 is used for the web stuff.
Must be 100% finished and received by buyer on:
Feb 11, 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:
Need the work completing urgently
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
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!
|
$100 (USD)
|
Feb 9, 2002
5:51:20 AM EDT
|
9.93
(Excellent)
|
|
|
HI!
If you can please send the Database, i will correct the SQL query where required.
I am restating your requirement below, as i understand it.
Your requirement is to - Display on 'find_a_member_search_results.asp' page,
the members details which match the search parameters 'member surname' or 'company name' or 'town' or 'country', or any combination of the four parameters entered in the 'find_a_member.htm'.
Suppose if a searcher enters any three parameters out of four the result will be filtered on an 'and' cluase of all the three like 'Param1 and Param2 and Param3'. Same logic applies for the two and four parameter combination.
Have I understood your requirement clearly - as stated above?
If so andif you Close the BID immediately and send the Database you will get the project done ASAP, by a reliable well managed programmer.
Please feel free to ask me any questions you might have.
Looking forward to work with you on this project.
Thanks,
Sreeny. |
|
|
|
|
|
|
N/A
|
Feb 9, 2002
6:39:43 AM EDT
|
9.93
(Excellent)
|
|
|
Dear Donaldt,
There is no Database attached to your bid request as stated by you in your BID Request. If you are interested in my BID, which was put a little while back, please close it and send the Database.
Thanks,
Sreeny. |
|
|
|
|
|
|
N/A
|
Feb 9, 2002
11:03:17 AM EDT
|
9.93
(Excellent)
|
|
|
HI! donaldt,
I see there are quite a few BIDS already posted. If i remember correctly you posted a similar request within the past day or two. So there would have been mumber of BIDS there too.
Must be a tough job to decide which coder to chose. huh!
Chances are that you may have received quite a few BIDS in the lower range of $4 to 20 (or even free advice).You will waste your time with such BIDS and ultimately you may not get the desired result.
In comparision my BID of $100 may look ridiculously high, but i have done similar Complex ASP Jobs and believe me it is not very easy to get the desired results with mutiple search parameters.
If i have understood your requirement as mentioned in my original BID request of $100, we will have to use very complex query. In fact it is not just one query but there have to be several nested quries to get the desired effect.
I i am wrong in understanding your requirement and the query is not as complex as i am thinking it to be, then i beg to stand corrected and will bring down my BID amount accordingly.
Plaese be careful who you chose for this project and give it only to that person who you think has understood the project the way you want it understood.
You will save lot of time and money even if you award it to somebody who has quoted high, but perfectly knows what is required to be done. That way the work will be in professional hands and you will have less worries.
Looking forward to hear from you in the matter, if you consider it worthwhile doing so.
Thanks,
Sreeny. |
|
|
|
|
|
|
