[kiy]

I am a first timer with Dreamweaver MX setting up a recordset for an asp page. I have encountered the following error when tyring to start inserting data into the appropriate cell by clicking the "+" by the side of the recordset in the binding panel:

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

Any help will be appreciated!

[Rockn]

Is your operator coming from an input froma form or is it in the SQL statement itself?

[kiy]

I am using the application panel in building my web page and encountered the problem. I am working on a senario of an administration control user log-in page. Somehow it doesn't like the filter field I choosen. I need to to put in an URL parameter.

[Rockn]

Do you have an exapmle page to look at? Is UserID a valid field and is there a 1 in that field? Try hard coding a value that does exist in the UserID field. If that doesn't work then it is the taht you are writing the expression that is in error. Could you post the entire SQL statement?

[kiy]

My problem was gone now for no reason. Thanks for your help though.