Does anyone have categories working with a database search
and can give a good example or insights for the problem below? My
CF8.01 code works fine for Verity searches so far until i add
Categories. Maybe I'm doing something wrong. I followed the docs,
but they did not shed any light on this.
I create the collection called "diadocimageadv" in the
Administrator with Categories set to yes.
I create update and refresh functions for it as follows for
example that seem to run without errors:
Where commonArgs is defined below and qRead is a valid query
result set (again works fine without category and I limit it to 100
records during this test):
var commonArgs = structNew();
commonArgs.category="Condition Report, Data Card";
diasubdoctypename, ...[more fields here]";
I then call the function from a page to refresh the
collection and it runs without errors.
Then I have another function that my cfgrid calls to run the
search that includes (where strdoctype equals 'Condition Report'
for example based on a user choice) and again no errors are thrown,
just null valued data:
Firebug shows the results coming back have nulls where I
expect my data. I define my search criteria based on my SQL Server
2005 query results (the one limited to 100 records) that I just ran
based on the collection that is supposed to be generated.