Aaaah. Just noticed the "Yes" in the query. Have you tried cf_sql_bit (cfqueryparam) with a value of 1 instead of the "Yes"?
On Thu, Sep 11, 2008 at 10:09 PM, Aaron Rouse wrote: > Yeah, the function is an Access function, just has the same name as CF. I > thought maybe the Yes/No column was throwing it off initially and tried a > cfqueryparam on that one but it helped none. I did not play with the date > though and will see if maybe that is the root of it. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:312401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
