Is reporter_db a table or schema name? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/
2009/1/16 Brad Bueche <[email protected]>: > I need to query a very large oracle database of network event traffic. I cant > really do any sort of efficient query unless I can specifiy partition: > > SELECT * > FROM reporter_db PARTITION (P200901) > > CF doesnt seem to recognize the "PARTITION (P200901)" > > Is there some special syntax I have to use to get it to recognize this? > > thanks > brad > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3174 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
