I'm pretty used to Coldfusion, but there is one thing I have no idea to do so that is why I am asking for help.
Does anyone know if it is possible to take something out of a database (MySQL) and exectue. Like taking a '<cfif>" tag and still having it execute showing the result and not just <cfif> when viewing the webpage.
if i understand correctly, you may try something like
<cfquery name="myQ" datasource="myDB"> SELECT something FROM somewhere WHERE ClientName Like (%#FORM.ClientName#%) <cfif IsDefined('FORM.date')> AND date = '#FORM.date#' </cfif> .....
After further consideration, I don't think this works.
The output of your query is parsed as a variable, and CF only makes one such parsing-pass.
Only way I think it might work would be to insert the Evaluate function into the datatable, so that CF encounters in while is was evaluating the contents of that variable.
/shrug
In any event, if this is possible, it will require the use of the Evaluate function.
Mark
12-15-2004 @ 1:21 AM
