Error in code ?

[James]

i keep gettin this error can some1 tell me what im doimg wrong please


Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'B_ID ='.

/Sredirect.asp, line 16



heres the code from /Sredirect.asp, line 16

10.set spRedirect = Server.CreateObject("ADODB.Command")
11. spRedirect.ActiveConnection = MM_conn_STRING
12. spRedirect.CommandText = "UPDATE SMALLBANNERS SET B_CLICKED_TOTAL =
B_CLICKED_TOTAL + 1, B_CLICKED_DATE = Date() WHERE B_ID = " +
Replace(spRedirect__varID, "'", "''") + " "
13. spRedirect.CommandType = 1
14. spRedirect.CommandTimeout = 0
15. spRedirect.Prepared = true
16. spRedirect.Execute()
%>

thanks in advance ;-)

[Tim Payne]

That error usually means that the variable isn't being passed to the page,
check that the variable from the querystring is being passed to the page
correctly.......

Cheers,

Tim.