Hi, so have a look at these two queries below. The first one states, that the article with id 16 has TWO guid's. One for sitefroup 1 and one for sg. 4
The second one says, that the article with id 96 also has two guid's. Both for sg. 8. This is what i mean when i say, that id and realm (together) have to be unique. Otherwise an article with id=xyz can have more than one guid (one for each sitegroup if you identify an object by the triple). cheers Gernot SELECT * FROM repligard WHERE realm = 'article' AND id = '16' |id|changed |updated |realm |guid |action|sitegroup |16|20030520173754|00000000000000|article|a423829274681e960efb65d987420f9b|delete|1 |16|20030520173754|20040330093407|article|47f8242124444af9eaedfe95cc2e616d|delete|4 ============================================================================================ SELECT * FROM repligard WHERE realm = 'article' AND id = '96' |id|changed |updated |realm |guid |action|sitegroup |96|20031205173116|20000101010101|article|1998fba2946ca029dee0fac9bb549694|update|8 |96|20031205173116|20040216180627|article|9daa660ffade41c30e54b83d074ced58|update|8 -- NEU : GMX Internet.FreeDSL Ab sofort DSL-Tarif ohne Grundgeb�hr: http://www.gmx.net/info --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
