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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3069
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
