User Guide

cfindex 199
datasource="book">
select * from book where bookid='file'
</cfquery>
<cfoutput
query="book">
--#description#-- <br>
</cfoutput>
<cfindex
collection="snippets"
action="delete"
type="file"
query="book"
key="description" >
</cflock>
<!--- ACTION=DELETE, #3 (TYPE=PATH) ---->
<cflock name="verity"
timeout="60">
<cfindex
collection="snippets"
action="delete"
type="path"
key="c:\inetpub\wwwroot\cfdocs\snippets"
extensions=".cfm"
recurse="no">
</cflock>
<!--- ACTION=DELETE, #4 (TYPE=PATH) (key is a query result set column) ---->
<cflock name="verity"
timeout="60">
<cfquery
name="bookquery"
datasource="book">
select * from book where bookid='path1'
</cfquery>
<cfoutput
query="bookquery">
--#url#,#description#-- <br>
</cfoutput>
<cfindex
collection="snippets"
action="delete"
type="path"
query="bookquery"
key="description" >
</cflock>
<!--- ACTION=DELETE, #5 (TYPE=CUSTOM) ---->
<cflock name="verity"
timeout="60">
<cfquery name="book"
datasource="book">
select * from book where bookid='bookid1'
</cfquery>
<cfindex
collection="custom_book"
action="delete"
type="custom"
query="book"
key="bookid" >
</cflock>