probs with ASP and SQL

[[TvR] -=CyRuS=-]

Lo all,
any of u know Active Server Pages, I got a small problem.

I am querying a database based upon values retrieved from a form. The problem part of the code is shown below where I am trying to pass a variable to the SQL, the errors show the code and show the variable is being passed yet I receive this (helpful :homer: ) error message.

This is the problem bit of code

sqlChoice15=sqlChoice15 & " AND ((CarRentalCompanies.Area2)='"&VarArea&"'));"

( i have checked this by creating a simple select statement with only this condidtion )

And this is the error message i am getting

Technical Information (for support personnel)

Error Type:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services


Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression '((CarRentalCompanies.Area2)='Sutton_Coldfield'))'.
/BEGASP/htdoutput2.asp, line 248

Where 'Sutton_Coldfield' is the value passed showing that this is kinda workin :)

Thanx in advance to all that read/reply

Marcus aka [TvR]-=CyRuS=- :pimp:

[mr_grumpy_man]

Try asking in the Webby & HTML forum - ask for Spawno, the mans some kind of ASP god :)

[[TvR] -=CyRuS=-]

Cheers mate, but i sussed it anyway.
twas a stupid error from to much vigourus cuttin 'n' pastin to save time...... :)