A true database query

[DettCom]

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. It will Does anyone have any ideas??? Thanks!!!!

[blewis]

In general, Evaluate() will not work for this sort of thing. It's ugly, but
usually all you can do is write out the code to a file (dynamically using
CFFILE) and then CFINCLUDE it back into the processing document to make it
execute.

Bryan

[eastinq]

Can you post some code?

[DettCom]

That worked!!! Thanks.