Show Bid Request Dynamic SQL query builder Bid Request Id: 339 Bookmark in my 'To Do' list Posted by: Joel Konecny (1 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 33.33% Buyer Security Verifications: Excellent Approved on: Jun 8, 2001 2:09:21 AM EDT Bidding Closes: Jun 22, 2001 2:09:21 AM EDT Viewed (by coders): 1037 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Unknown Bidding Type: Open Auction Categories: Database, ASP Enter chat room for this bid request (0 active users at Sep 23, 2003 3:13:31 PM EDT) Description: What I have built is an add on for something I already have built. I design an ASP code generator and I need someone to build an add on for me. I will convert the code to fit my own so I only need the desired functionality. I need to be able to pass in the name of a table in a given database and then allow my end users to build an visual sql query from that table. Query only has to be dynamic enough for one table, but must be flexible enough to allow a person who has NO sql experience to query the database table. The only fields that the end user should be selecting is what fields they want to see from a given table, any where statments and any order by functions (asc /desc) that sort of stuff... It has to be completely dynamic. All I want to do is pass in the name of the database / the name of the table I want from that database and then i want it to let me build a visual query from that. If anyone has any questions please post them. The source code of the project I am working on can be found in the ASP category of planet-source-code. (it is this months contest leader)... ASP Code Generator. Or for more info you can come to my website at www.intratelligent.com. Deliverables: I need to view and test the asp code to make sure it works and is dynamic enough for my liking. Special Conditions / Other: Must be suplied within one week from bid acceptance. 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! Roger Willcocks (11 ratings) in Auckland, North Island New Zealand Bid id: 2,887   $150 (USD) Jun 8, 2001 4:33:15 AM EDT  10 (Excellent)     No problem, you want an ASP page that will take a table name (as a constant?) and list the fields in it, the user can tick the fields to display (no particular order), select a sort order if required, and enter a single where clause (>< <> = NOT LIKE) for each field. Allow an additional Wher field where they can enter any more complicated parts of the where clause. When submitted, the page generates a table with the data in it, I would suggest limiting it to the first, say 1000 records, or do you want paging for it?