Show Bid Request SQL LEFT JOIN / ASP Display Problem Bid Request Id: 10750 Bookmark in my 'To Do' list Posted by: Mark Dennis (16 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 27.59% Posted: Mar 13, 2002 10:18:07 AM EDT Bidding Closes: Mar 15, 2002 10:33:57 AM EDT Viewed (by coders): 146 times Deadline: 3/14/2002 TIME EXPIRED Phase: Cancelled 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 Jul 8, 2003 9:25:21 PM EDT) Description: I am having trouble displaying data with ASP that I retrieved with a SQL LEFT JOIN statement. To view the error visit: http://www.lappinsulator.com/bushings/revcrossreference.asp Display Problem #1 Enter Catalog # 89181-70 and search. Instead of listing the LAPP Catalog # 7 times each with a different Competitor Cross Reference, I want to display the LAPP Catalog Number only 1 time and group the different Competitor Cross Reference numbers together. Display Problem #2 Select Type: PRC, kV Class: 15 and search. This search should display many different LAPP Catalog Numbers and list the respective Competitor Cross Reference numbers together for each. I have attached my ASP page with full source code. This is a priority project that I hope to complete today. Please do not respond if you cannot help within the next 12-24 hours. Deliverables: Complete working code for both display options. Complete copyrights to all work purchased. Platform: Outside hosting companies server, I believe they have WIN 2k Server Must be 100% finished and received by buyer on: Mar 14, 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. 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   No bidding allowed, because this bid request was cancelled. Cancelled Date: 5/10/2003 9:26:05 PM Cancelled Reason: Cancelled by automated program due to time expiration