Displaying float data from SQL Server on web with ASP

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.

## 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.

Skills: ASP, Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL

See more: webpage problem, sql server web, sql server open source, open source sql, ms access with php, sql microsoft access, ms access sql, microsoft access sql, sql microsoft, MICROSOFT SQL SERVER, float, data source sql, simple sql program, php sql syntax error, recordset, resolve server, sql select select, sql web form, sql syntax error, sql keyword, sql select, sql problem, simple asp program, sql syntax, ole provider

About the Employer:
( 123 reviews ) Lima, United States

Project ID: #2833053

Awarded to:


See private message.

$1 USD in 14 days
(1 Review)