NUMBERING

[TBJ]

I have recently created a search interface and using Verity. I have indexed
several directories on the server, HOWEVER, there were certain directories that
I didnt want to be searched. I couldn't figure out how to do that, so I decided
to include a cfif statement on the results page which states if the url does
not contain the name of the directory, then show results:

<cfif URL DOES NOT CONTAIN "newsletter">
#currentRow#. Document: <a
href="#XOSResults.URL#">#GetFileFromPath(Key)#</A>
<br>
<!--- title for files --->
Document Title (if any): #Title#
<br>
<!--- summary--->
Summary: #Summary#<br>
<!--- score --->
Score: #Score#<br><br>
</cfif>

The only problem is the numbering gets messed up because some of the rows are
not being displayed because the directory path contains the newsletter
directory and therefore I might get :
1.fkdfjkdf
3. fldjfd
4. ldjflkd
8. ldjfldj

Is there anyway at all for me to force the numbering? Help! It seems like it
should be simple but i've tried many different things with cfset and nothing
works.

[philh]

You'll have to roll your own counter. Since you're spinning through a result
set and ignoring some rows, you can't depend on the CURRENTROW variable for a
numbered list. Try this: <cfset mycounter = 0> <cfoutput query='XOSResults'>
<cfif URL DOES NOT CONTAIN 'newsletter'> <cfset mycounter = mycounter+1>
#mycounter#. Document: <a href='#XOSResults.URL#'>#GetFileFromPath(Key)#</A>
<br> <!--- title for files ---> Document Title (if any): #Title# <br> <!---
summary---> Summary: #Summary#<br> <!--- score ---> Score: #Score#<br><br>
</cfif> </cfoutput> HTH,

[TBJ]

Thanks Phil, it worked like a charm. Now my other small issue is that the
RecordCount variable I am using to display the number of documents returned is
in correct. Is there a way to take the last counter variable number and
incorporate it as the total number of documents returned to the page?

Thanks so much.

[philh]

I suppose you could do a Query of Queries and select the recordcount for
records that match your criteria. So, Get the Verity result; Query it for
the criteria ('URL NOT LIKE '%newsletter%'') (I'm not sure of QofQ's
capabilities here :-| ); store the recordcount of that query to your total
variable (or just display). If this doesn't work you'll have to spin through
the Verity recordset twice: once to get your record count and once to display
the pertinent results. HTH,