I use these two functions...
<cffunction name="catalogExists" access="public"
returntype="boolean" output="false"
hint="Checks to see if a catalog exists by
attemtping to perform a search.">
<cfreturn CatalogStats().recordcount GT 0>
</cffunction>
<cffunction name="catalogStats" access="public" returntype="query"
output="false"
hint="Returns all the catalog statistics">
<cfset var q = "">
<cflock name="#variables.instance.searchHash#"
type="readonly" timeout="20">
<cfcollection action="list" name="q">
</cflock>
<cfquery name="q" dbtype="query">
SELECT *
FROM q
WHERE name = <cfqueryparam
value="#variables.instance.catalog#" cfsqltype="cf_sql_varchar"
maxlength="100">
</cfquery>
<cfreturn q>
</cffunction>
Paul
> -----Original Message-----
> From: Robert Nurse [mailto:[email protected]]
> Sent: Thursday, May 20, 2010 2:09 PM
> To: cf-talk
> Subject: Checking Existence of Verity Collections
>
>
> Hi All,
>
> Is there a way to programmatically determine if a Verity collection
> exists?
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333840
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
