It turns out it was just me working too many hours too many days in a row (I guess). Its working now. It was suprising as I would think (I'm brand new to cf) that cf would just pass the entire string to the db (an not analyze the submission). [Which is why Mr. Comer's response baffles me.....cf just submits the query....at that point, its up to the db] This started because the cf wizard in flex 3 just went out to lunch when I used the word partition. I'll re-tackle that tomorrow.
Sometimes I get obsessive and just cant stop when I should go get some sleep! Sorry for wasting y'alls time, but thanks for the response. brad -----Original Message----- From: James Holmes [mailto:[email protected]] Sent: Thursday, January 15, 2009 7:25 PM To: sql Subject: Re: Oracles "Partition" keyword 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:3175 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
