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 = [url removed, login to view]("[url removed, login to view]") [url removed, login to view] 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.
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.