<cfqueryparam> tag?
I've got a query something like this.
SELECT *
FROM aTable
WHERE DateField = (SELECT Max(DateField) FROM aTable WHERE DateField <
<cfqueryParam value="#url.date#"...>)
I'm trying to select the previous record in aTable by date to the value in
url.date, which corresponds to another record in aTable..
This does not throw an error, but it also does not return any records when
there is one that should be returned. I notice in the debug window that the
SQL statement is truncated at the first left angle bracket (<). I suspect
it is being treated as an open tag character, but I'm not sure what to do
about it if it is. < does not work in a SQL statement.
Thanks.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
