I am doing fresh imports links from text delimited files. Because these do not have an ID issued by GLinks, I can only allocate one category. (GLinks thinks multiple copies of same link with different category IDs are individual links)
I now want to place some of these links in additional categories. There are approx 500 links in each import file. Is there an easy command to use to do this through SQL Monitor? Something like:
and also have the LinksID copied from the record where Type LIKE 'XX' was found.
Thanks in advance
I now want to place some of these links in additional categories. There are approx 500 links in each import file. Is there an easy command to use to do this through SQL Monitor? Something like:
UPDATE prefix_CatLinks ADD CategoryID = 'n' WHERE Type LIKE 'XX'
and also have the LinksID copied from the record where Type LIKE 'XX' was found.
Thanks in advance