Show Bid Request Displaying float data from SQL Server on web with ASP Bid Request Id: 5784 Bookmark in my 'To Do' list Posted by: Mark Dennis (16 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 27.59% Buyer Security Verifications: Good Approved on: Nov 30, 2001 2:45:53 PM EDT Bidding Closes: Dec 2, 2001 2:46:44 PM EDT Viewed (by coders): 402 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Database, ASP Enter chat room for this bid request (0 active users at Jul 12, 2003 5:40:15 AM EDT) Description: I am trying to display a float data type field in SQL Server named "fkV" on a webpage using ASP. My code returns this error: "Microsoft OLE DB Provider for SQL Server error '80040e14' Incorrect syntax near the keyword 'Select' " Here is my ASP code: DIM mySQLmk, objRSmk mySQLmk = "SELECT * FROM tblBsh_Cross_Reference WHERE fkV = " & strkV2 & ";" Set objRSmk = Server.CreateObject("ADODB.Recordset") objRSmk.Open mySQLmk, objConnSQL I've used this same code to display number fields from MS Access with no problem, but I am stuck with SQL Server. Can someone help resolve this? I believe this is a simple matter, so I put in a low bid. Let me know if I am wrong. 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. 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! Fecri Irsat (1 ratings) in Mississauga, Ontario Canada Bid id: 62,401   $4 (USD) Nov 30, 2001 3:02:13 PM EDT  10 (Excellent)     Yes, it is a small matter. Please accept my bid because I am the first bidder, well if you do, I will be glad to tell you the problem. Best Regards.