On Tue, Jul 22, 2014 at 1:08 PM, Stephen Hait <stephenh...@gmail.com> wrote: > Does anyone know why the WHERE clauses in the query appear to be ignored > when running the app with CF11 but work correctly with CF10? > > Or does anyone have a suggestion of how to best debug this? I can't seem to > figure out how to view the contents of the 3 arguments used in the WHERE > clauses to see why they might be being ignored or why the result set is not > limited by the filters on CF11. > > Any insight or suggestions appreciated.
I would dump the argument scope to see if the arguments are actually being set. You might also use a variable and build your query are a text string, then dump that string to see what it contains. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm