its sql, not coldfusion, so < is used instead of lt. And $30 is a string. you want to compare less than a number, like 30
so AND salesprice < 30 On 9/27/07, Betsy McDonald <[EMAIL PROTECTED]> wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3072 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
