On Wed, 2003-08-27 at 03:17, James Gifford wrote: > Hi Hi to you too :P > I've chosen to use the print field in the article table to store the id > of the location topic of the article and the extra1 field to hold the > secondary topic for that article. It just occurred to me that if I have > topic ids in these fields, then if the site is replicated, it won't work > if the topic ids of the topics change in the new replication version. > But then topic ids are stored in the topic field of the article table. > Does repligard go through an change all the ids of everthing based on > GUIDs including changing the topic ids in the articles table and the > object ids in the blobs table? Does it follow that if I want to relate > articles to more than one topic, a better way would be to store the > GUIDs of the related topics in the extra fields of the articles table?
Both yes and no. You probably want to use parameters for this. Check out the manual for more information. Btw, what about the articles topicfield? What is the difference between the location topic and the topic the article is stored under? tarjei > Thanks > James > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
