I am trying to lock down the queries on the site I am working on with
cfqueryparam and while the basics are pretty straight forward, I am not quite
sure how to handle a query like this.
SELECT TOP 3 News.newsTitle, News.newsBriefDesc, News.newsID,
NewsBySection.precedence, News.startDate, News.endDate, News.newsFullBody
FROM News
LEFT OUTER JOIN NewsBySection ON News.newsID =
NewsBySection.newsID
WHERE ((NewsBySection.sectionID = '13') AND
(News.startDate <= '#daterequestAdd#') AND (News.archive = 0)) AND
((News.endDate >= '#daterequestAdd#') AND (NewsBySection.sectionID = '13') AND
(News.archive = 0) )
ORDER BY NewsBySection.precedence
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310019
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
