First off, I hope your price value is not saved as a character string.. Secondly you're using a CF function (lt) in your SQL query...
Try this.. if your Salesprice is a number column.. .... WHERE Sold=no and Salesprice < 30 The "<" should work in your SQL query 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3070 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
