Thanks for the help all. I'm just using cfa_TypeIndexCreate as that meets all our needs. The documentation doesn't really let you know that the tag checks for already created collections. I was mis-directed by another source.
Oh well, there's two days of my life that I'll never get back. Guy McDowell >From: "Hewitt, Andrew" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Spectra-Talk <[EMAIL PROTECTED]> >Subject: RE: cfa_IsCollection >Date: Wed, 12 Dec 2001 01:22:58 -0500 > >Also, there is the cfa_typeIndexKeyUpdate tag. After the collections >for each property of a type are in place you can use this tag to add an >object to them. It splits out the indexed properties of the object and >places each in the correct collection. > > >Andrew Hewitt >Webworld Studios, Inc. >www.wwstudios.com > > >-----Original Message----- >From: Seth Hodgson [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, December 11, 2001 7:58 PM >To: Spectra-Talk >Subject: Re: cfa_IsCollection > > >Hi Guy, > >If you are wanting to create/update verity collections that correspond >to >properties of content object types - try using ><cfa_objectTypeGetPropertyDefinitions ... >r_stTypePropertyDefinitions="stTypePropDefs"> > >You have the typeID, so run this tag and loop over the returned >r_stTypePropertyDefinitions. You could either run cfa_isCollection calls >using the collection names for each or only the desired properties - by >concatenating the following attributes to get the collection name while >looping over the returned struct: >stTypePropDefs[currElem].PROPERTYDEFINITIONID & >stTypePropDefs[currElem].PROPERTYNAME > >There is also a bIndexed field for each type property that will be 1 if >it >is an indexed property with a collection and 0 if not. You could base >your >collection creation on this bit field being 0. That would save the >cfa_collection call. If it is 1 you can go ahead and repair/optimize the >collection. > >Cheers, >Seth > >----- Original Message ----- >From: "Guy McDowell" <[EMAIL PROTECTED]> >To: "Spectra-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, December 11, 2001 10:41 AM >Subject: cfa_IsCollection > > > > I would like to use the cfa_IsCollection tag to see if a collection >exists > > for any number of properties. > > > > However, I see that the collection's name is a concatenation of > > propertydefinitionid from the table propertydefinitions and the >propertyname > > from the table properties. > > > > So, I presume that I have to do an SQL to find those two values and > > concatenate them together and then pass that into the cfa_IsCollection >tag > > to see if it exists. > > > > If so I have to write an SQL statement that also draw information from >the > > objects table and types table as there is no directly corresponding >fields > > between propertydefinitions and properties tables. > > > > Am I on the right track here or is there an easier way? Please tell me >there > > is an easier way. Please..... :-) > > > > > > The purpose of this is to test to see if the collection already >exists. If > > it does; simply update it. If it doesn't; create it. > > > > > > Truly, > > Guy > > > > > > _________________________________________________________________ > > Get your FREE download of MSN Explorer at >http://explorer.msn.com/intl.asp > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
