Hi Mark,
Try turning on your CF debugging in the admin with the database activity enabled, so that you can see what the generated
query statement looks like. This should help you to isolate the problem.
There is a session variable called '[table]criteria', where [table] is normally the name of the table you are working
with. This value is used to filter queries for lists, and may be getting overwritten. Try placing a <cfdump> with this
value, followed by a <cfabort> at the top of your list page to see what the value is *before* the list gets processed.
Jeff
Mark Fuqua wrote:
Good Sunday afternoon,
Is there a problem with using a search form which submits to a list form,
which has a whereClauseExtension? My search form is filtering on a date
range and the list's where clause extension is filtering on userId.
It is not causing an error message, it just does not work. If I enter a
date range, it returns no value, if I press "display all" it displays all.
So the filter is not working. Is this normal and expected?
I have such a situation and it does not seem to be working. Chances are it
is something I am doing wrong, just wanted to be sure before spending
several more hours trying to figure it out.
Thanks,
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
**********************************************************************
