Hi Mark, Did you try using the cfdump suggestion I made in your post of 8/7 on this topic?
I haven't had a chance to try a search form with a date range yet, but I will build one tomorrow and see if I get the same behavior.
Jeff Mark Fuqua wrote:
Hey there, I am having some troubles with date ranges on PLUM search forms and also with trying to get multiple filters on a whereClauseExtension of the <cf_displayList>. When I use search by date range on a search form, the list posts with no records and the message that "you didn't enter and search criteria". When I use the whereClauseExtension of a <cf_displayList>, and I try and use AND, it doesn't seem to work. For Example: whereClauseExtension="messageSentTo = #session.UserId# AND messageStatus = 'new'" Chances are good that these problems are of my own making, however, I am just wondering whether anyone else has had such problems. Searching for solutions is almost becoming fun. I am just trying to make sure solutions exist. Thanks all, Mark Fuqua ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
