Anybody know if this is a known bug in CF ?
This query
<CFQUERY DBTYPE="QUERY" NAME="Q_Dump">
SELECT * FROM Q_Table
WHERE FrWMin <= #Weight#
AND ((FrWMax > #Weight#) OR (FrWMax = ''))
</CFQUERY>
produces a single row with value of 15.0 in the FrZWPrice field
but this query
<CFQUERY DBTYPE="QUERY" NAME="Q_Price">
SELECT Max(FrZWPrice) AS Price FROM Q_Table
WHERE FrWMin <= #Weight#
AND ((FrWMax > #Weight#) OR (FrWMax = ''))
</CFQUERY>
ignores the where clause and simply returns the maximum FrZWPrice, which in
this instance is 55.0
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/
CAUTION: The information contained in this email message is confidential
and may be legally privileged. If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited. If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.
Views expressed in this communication may not be those of Innovative Media Ltd.
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
