Im geting the following error

Microsoft JET Database Engine (0x80040E14)
Extra ) in query expression '(((Oferta.OfertaID =));'



please see the code above concerning that error:

           "WHERE (((Oferta.OfertaID)=" & Request.QueryString ("OfertaID") & "));"

Can anyone explain me where´s the problem?

Regards,

trevo4f

uitr

Not sure if you need the parentheses at all. Do you get an error when you remove them? Maybe try the following:

"WHERE Oferta.OfertaID = " & Request.QueryString("OfertaID") & ";"

The problem is the query string value is coming back empty. This:

"WHERE (((Oferta.OfertaID)=" & Request.QueryString ("OfertaID") & "));"

is equating to:
(((Oferta.OfertaID =));

Which is invalid SQL.

================================================== =========
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 / Author :.
Wrox Books 24 x 7
================================================== =========