create new index numbers for TC topics

06/06/07

Permalink 04:26:00 pm, by sarneil, 101 words, 611 views   English (CA)
Categories: Activity log; Mins. worked: 90

create new index numbers for TC topics

went through list of topics provided by Leona, assigned new index numbers based on alphabetical order of full text entries and excluding those topics which she instructed should not be included, and adding one new topic "Gold". Emailed her for confirmation before actually making any changes in db. Assuming she's ok, then I'll need to renumber all the current values (and there may be more than one in the topic field of any given record) to a temp value and then renumber those temp values to the final values (which in the case of those topics being eliminated will be null

Pingbacks:

No Pingbacks for this post yet...

Times Colonist Transcript Database

The goal of this project is to take a collection of transcripts of new stories from early editions of the Times Colonist newspaper which are currently in text files containing special codes for various bits of information, normalize the records, put them into an SQL database and then write a querying front-end.

Reports

Categories

May 2013
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

XML Feeds