Can anyone suggest a SQL script to convert 4.5.0 newsflash to 4.5.1? G'day
I was hoping someone here more versed in SQL than I, can suggest a solution.
One of my clients sites uses the old 4.5.0 newsflash function as a 'quote/joke of the day' facility. He has over 300 quotes painstakingly entered over a period of several months. I'd hate to have to tell him he's got to re-enter them in 4.5.1
Has anyone developed a sql query to read the old mos_newsflash table (assuming I imported it again) and write them to the new mos_content table? Assume a resulting fixed SectionId and CatId of 4 & 1 respectively.
I'm a bit at sea with sql but it doesn't seem like it would be that hard. Any sql gurus out there who can suggest the correct query off-hand?
__________________
Paul Pofandt
Brisbane, Australia P3Data |