> can one create a verity collection on information stored in a
> database? (SQL Server)
Yes, using CFINDEX's TYPE="CUSTOM" attribute & value:
<cfquery name="qStuff" datasource="myds">
SELECT Item_ID,
Item_Name,
Item_Description
FROM Item
</cfquery>
<cfindex action="UPDATE"
collection="mycollection"
key="Item_ID"
type="CUSTOM"
title="Item_Name"
query="qStuff"
body="Item_Name,Item_Desc">
In fact, you can index multiple queries into a single collection, as well as
documents, with a tiny bit of extra work.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists