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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 ------------------------------------------------------------------------------ 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.
