Wondering if anyone can help me out. I am trying to group my
output that I am gettting from a verity search. I have a six digit
unique number that gets passed through a form, example 100030. Then
this number searches a verity collection of files to find any file
starting with that number. All files being searched are named like
this 100030_200601.pdf, 100030_200602.pdf, 100030_200603,pdf etc.
Signifying the unique person "100030", the year "_2006" and the
The "200602" part would signify the year 2006 and the month
of February. My problem is I am trying to seperate and group this
output by year and date according to what the verity search finds.
I thought I was on the right track with this code but it's not
displaying what I want, it just spits out a bunch of repeat months
and years and scatters the file under the correct ones:
Try creating a separate query for each month base on cfsearch
criteria, then group the querys in one output.
Also characters like "_" (underscore) has given me fit
before, try cleaning up the sting using ListLast
Example: <cfset ID = ListLast(URL, "_")>