- Academic
- AdaptiveDB
- Admin
- All
- Bailey
- CanMys
- Cascade
- CGtW
- ColDesp
- Depts
- DHSI
- FrancoToile
- HOPOL
- HumsSites
- IMT
- Lansdowne
- LondonMap
- Maint
- Mariage
- MoM
- Moses
- MyNDIR
- Pro-D
- Projects
- Properties
- RenMedics
- ScanCan
- Times-Col
- Transformer
- Vac/Hours
- Vesalius
- viHistory
Times Colonist Transcript Database
T-C transcripts from plain text to sql database
More work on finding nth item in topics list in TC
06/07/07
More work on finding nth item in topics list in TC
article 52989 has topics field 148,91
article 54104 has topics field 92,148
SELECT * FROM articles WHERE 148 IN (articles.topic) returns record 52989
SELECT * FROM articles WHERE 91 IN (articles.topic) returns no records
SELECT * FROM articles WHERE 92 IN (articles.topic) returns record 54104
Still have to figure out a way to find the nth item in that field
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.
Actions
Reports
Categories
- All
- Activity log (48)
- Announcements (1)
- Tasks (8)
| 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