Dynamic SQL Query

[DettCom]

Hello All, My life long persuit of true dynamic queries continues, and as
usual, I hit another snag. I am try to create a dynamic search page where the
admin would create the fields or dropdowns for the user to select. For this
example, we'll say a dropdown for month (01, 02, 03, etc.) and year (2001,
2002, 2003, etc.). now on the next page I want the admin to be able to enter
information into four separate textarea boxes. They are QUERY OR SPOC, WHERE
STATEMENT, GROUP BY STATEMENT and ORDER BY STATEMENT. This is what I would
like for them to be able to enter: QUERY OR SPOC: Select var1, var2, FROM
TABLE222 WHERE STATEMENT: where month = #form.month# AND year = #form.year#
GROUP BY: VAR1, VAR2 The problem occurs in the where statement. I have tried
Evaluate(), using single quotes, double quotes etc. Does anyone have any
ideas??? Thanks!!!!

[DettCom]

I forgot to mention that when the form posts, it uses where month = #form.month# AND year = #form.year# instead of plugging in the month and year value.

Thanks