Ron,
I
would dump the variables YHSPRT and thisyear to see what they are, then compare
to the dump of q2. Also, does thisyear need to be 'CreateODBCDateTime' formatted
for proper comparison?
Just a
couple things I would try.
Kevin
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ron Mast
Sent: Monday, February 02, 2004 10:30 AM
To: [EMAIL PROTECTED]
Subject: is this a bug?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
