Hello All, 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 When the form posts, it uses where month = #form.month# AND year =
#form.year# instead of plugging in the month and year value. The problem
occurs in the where statement. I have tried Evaluate(), using single quotes,
double quotes etc. Does anyone have any ideas??? Thanks!!!!