Try this:
<cfquery name="catalog" datasource="datasource">
SELECT VintageID, DateListed, SalePrice, Sold
FROM Vintage
WHERE Sold = '#no#'
AND Salesprice < '30'
ORDER BY DateListed DESC
</cfquery>
Presuming no is a CF variable. And 30 is a number.
-----Original Message-----
From: Betsy McDonald [mailto:[EMAIL PROTECTED]
Sent: Friday, 28 September 2007 12:05 PM
To: CF-Newbie
Subject: use of "less than" in cfquery
Can someone help with this coding problem? I'm trying to make a "cheap
sales"
page for my store catalog. Have been trying lots of versions of "less than"
(lt)
without success. Por favor, what am I doing wrong?
Here's one sample:
<cfquery name="catalog" datasource="datasource">
SELECT VintageID, DateListed, SalePrice, Sold
FROM Vintage
WHERE Sold=no AND Salesprice lt "$30"
ORDER BY DateListed DESC
</cfquery>
Betsy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3071
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
