I am programming a site and when i log in i get this message...

Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near ')'.

C:\INETPUB\WWWPA\STUDENTS\../shared/infoCenter/center_inbox.asp, line 15

90% of the page comes up however, this section is suppose to be a discussion board and it does not appear.

Here is the code for that section (the last line of this code is line 15)

'Build Recordset and Connection
    SET THISONE = server.CreateObject ("ADODB.Connection")
    THISONE.Open Application("THISONE_ConnectionString")
    SET RS1 = server.createobject("ADODB.Recordset")
    SQLString = "SELECT tblBoardInbox.BIReplies, tblBoardInbox.BIID, tblBoardInbox.BTID, tblBoardThreads.BTSubject, tblBoardThreads.BTDateTime, tblBoardThreads.BCID " & _
      "FROM tblBoardInbox INNER JOIN tblBoardThreads ON tblBoardInbox.BTID = tblBoardThreads.BTID " & _
      "WHERE (tblBoardInbox.UID = " & vUserID & ")" & _
       vSQLString 'from students and faculty
    RS1.Open SQLString,THISONE,adOpenKeyset,adLockReadOnly,adCm dText


Please help

The issue is in your SQL String, it is invalid because you are not concatnating strings correctly. If you fix that, your error will go away. =]

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

Thank you for the response. However, all i did was copy and paste this .asp file from an older website (which works) to my new website.

The code is identical in both projects. Is there anything directly that i could try?

I put a Response.Write("vSQLString") Response.End to see what the output is. Would that help to know that information?

Thanks again for your willingness to help!

Do Response.Write(vSQLString) to see the literal value of your SQL string. That will help you find the problem, yes.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

When i do the Response.Write(vSQLString) i get this on the webpage...

;SELECT * FROM vw_classes_student WHERE (UID = ) AND (Status = 'Current') ORDER BY CourseTitle, ClassID

Could there be a syntax problem in a table/view in the database? If so based on the code given so far would you know which one i should start looking at or what i should be looking for? I think i have looked at this for so long i have blinded myself from the problem.

Thanks

You don't see anything odd about this SQL Query?? You are not supplying a value for the first parameter of your where statment. (UID= )

Also this doesn't make sesne:
SQLString = "SELECT tblBoardInbox.BIReplies, tblBoardInbox.BIID, tblBoardInbox.BTID, tblBoardThreads.BTSubject, tblBoardThreads.BTDateTime, tblBoardThreads.BCID " & _
      "FROM tblBoardInbox INNER JOIN tblBoardThreads ON tblBoardInbox.BTID = tblBoardThreads.BTID " & _
      "WHERE (tblBoardInbox.UID = " & vUserID & ")" & _
       vSQLString

You said that the result of Response.Write(vSQLString) yeilded:
;SELECT * FROM vw_classes_student WHERE (UID = ) AND (Status = 'Current') ORDER BY CourseTitle, ClassID

so the code above is going to evaluate to something like:
SQLString = "SELECT tblBoardInbox.BIReplies, tblBoardInbox.BIID, tblBoardInbox.BTID, tblBoardThreads.BTSubject, tblBoardThreads.BTDateTime, tblBoardThreads.BCID " & _
      "FROM tblBoardInbox INNER JOIN tblBoardThreads ON tblBoardInbox.BTID = tblBoardThreads.BTID " & _
      "WHERE (tblBoardInbox.UID = " & vUserID & ") ;SELECT * FROM vw_classes_student WHERE (UID = ) AND (Status = 'Current') ORDER BY CourseTitle"

This makes no sense?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========