Sorry that I'm asking a lot of questions today…:(
I have created a query using the queryNew() function, then I'm querying that query like so:
<CFQUERY NAME="q3" DBTYPE="query">
SELECT *
FROM q2
WHERE PRT = '#YHSPRT#' AND YR = '#thisyear#'
</CFQUERY>
But I don't get any record when there should be 1 when I dump the query above.
I can dump the record when I hardcode PRT and the YR value.
Does anyone have a clue why?
Ron
