Many thanks Pascal for that. It still returns multiple records. I used the group by tag which stops this from happenning, so I don't see multiple records of the same log. Its all good. However, I'm displaying the recordcount in the search result and it doesn't give you the correct picture of the no of records returned and the actual display.
<tr>
<cfoutput><td class="title">#searchresults.recordcount# logs found.</cfoutput>
</tr>
<cfoutput group="logID" query="searchresults">
blah blah blah
</cfoutput>
see what I'm saying?
[
Todays Threads]
[
This Message]
[
Subscription]
[
Fast Unsubscribe]
[
User Settings]
![]()
