[MSJRunner]

Hi all, I'm brand new to this forum, and I'm trying to do homework for my ASP class. We're using ASP VB script and I'm trying to make the most basic Master/Detail Add/Edit/Delete page. This is the error I am getting...

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'BID='.

/users/hessel/pub/ASP/Midterm/BooksEditProc.asp, line 15

Here is my code:

Code:

<%
 
set Conn=server.createobject("ADODB.Connection")
connString="Data Source=" & Server.Mappath("Books.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"
Conn.Open connString
 
Dim sql, rs
'Set up connection to the DSN, which will talk to the database
 
sql="select * from Books1 where BID=" & request.form("BID")
set rs=server.createobject("adodb.recordset")
rs.cursortype=3
rs.locktype=3
rs.Open sql, Conn
rs("Name")=request.form("Name")
rs("Author")=request.form("Author")
rs("Publisher")=request.form("Publisher")
rs("YearOfPublication")=request.form("YearOfPublic ation")
rs("Color")=request.form("Color")
rs("Genre")=request.form("Genre") 
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect("booksmaster_2.asp")
%>

Could someone PLEASE help me, I'm sure it's so simple, but I have no idea what's wrong with my code. Thank you so much.

[bizzar528]

Syntax error (missing operator) in query expression 'BID='.

The answer is in the error.

Syntax error (means you didn't write your query properly),
missing operator (what are you trying to compare BID to?, ='' is not valid =NULL is),
in query express 'BID=' (this query is wrong).

Your query needs work.

And you posted in the wrong section.

[UnrealEd]

What's the datatype of the BID field? If it's a string, you have to wrap the data in quotes inside the sql statement

[webdevelopmenthouse]

the query seems perfect to me;

sql="select * from Books1 where BID=" & request.form("BID")

make sure that you are getting the value from submitted form;

check the value of this;

request.form("BID")

you can check its value like this;

response.write(request.form("BID"))
response.end

if it will print nothing, it means you need to check the form you are submitting, there should be a field name there BID and it should have some value to post..

and according to the sql query you wrote.. i am assuming that value of request.form("BID") will be a number.. and in database BID is a numeric field..

kind regards,

Nadir Ali Shah