hello getting wierd error from SQL statement
it is
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Characters found after end of
SQL statement.
here is my server side code
<% Dim strSQL, objRS, strTitle, dblPrice, strISBN, strDescription,
curPrice, curDiscPrice
strISBN = request.querystring("ISBN")
'sql statement for individual books
strSQL = "SELECT tblBookDescription.ISBN,
tblBookDescription.strTitle, tblBookDescription.strDescription,
tblBookDescription.strPublisher, tblBookDescription.dblPrice,
tblAuthors.AuthorID " & _
"FROM tblAuthors INNER JOIN (tblBookDescription INNER JOIN
tblAuthorsBooks ON tblBookDescription.ISBN = tblAuthorsBooks.ISBN) ON
tblAuthors.AuthorID = tblAuthorsBooks.AuthorID; " & _
"WHERE (((tblBookDescription.ISBN)='" & strISBN & "')) "
response.write("strSQL = " & strSQL)
Set objRS = Server.CreateObject("ADODB.Recordset")
-----------------------------------------error here
objRS.open strSQL, objConn
-----------------------------------------------------------
'response.write("strSQL = " & strSQL)
curPrice = FormatCurrency(objRS("dblPrice"))
curDiscPrice = FormatCurrency((objRS("dblPrice")*.8))
dblPrice = (objRS("dblPrice"))
%>
any help please, i think it occurs where i concatenate the strISBN into
the SQL statement