asp flash, database dating sites!

Please bid carefully this project is to help an ongoing project dating site with flash video recording and viewing! You must have perfect knowledge in aspx and sql server 2000 databases and manipulation and know flash video recording storing and playing! This can lead to future work but right now all I need is to help get over a few errors my programmer is having and help the data show up based on predetermined search criterias ALL BIDDERS NOT REVIEWING THE BID WILL BE DELETED! The site is [[login to view URL]][1] we have a few other sites and the format is similar..The errors we are having are based on weights given to each profile to show up in a certain format when searching by non members /searching by members, the results should be displayed based on criterias example search [login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],U.Ad_Title,U.Ad_Body,[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],M.Pic_Male,M.Pic_Female,M.Pic_Couple,M.Pic_Weight from Users U inner join Location L on [login to view URL] = [login to view URL] and [login to view URL] = 11001 -- Additional Zip Code condition to cover 350 miles and Country = '1' inner join Media M on [login to view URL] = [login to view URL] AND [login to view URL] = 0 and (M.Pic_Female = 1 or M.Pic_Couple = 1) order by [login to view URL] desc,M.Pic_Weight This is for Searching Zip Code 11001 and Couple or Female There are errors when searching our dtabase of a few hundred thousand profiles! This is a one time project can lead to weekly consulting administration! YOU MUST BE AVAILABLE AT LEAST A FEW HOURS A DAY TO CHAT ONLINE AND REVIEW AND UPDATE! I would like to see codework done and, history with coding not webdesign creation! There is many custom scripts and programs running that you will have to familiarize yourself with, mostly flash mixed with asp .net ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform windows server sql, macromedia flash