Difference between revisions of "Site:Developer stuff/Adding links to TOC"
From Feast upon the Word (http://feastupontheword.org). Copyright, Feast upon the Word.
(adding content) |
m (switching codes) |
||
| Line 8: | Line 8: | ||
3. ran the following code | 3. ran the following code | ||
| − | < | + | <pre><nowiki> |
UPDATE thestandardworks.cur b | UPDATE thestandardworks.cur b | ||
INNER JOIN test.Adding_TOC_Links a | INNER JOIN test.Adding_TOC_Links a | ||
| Line 18: | Line 18: | ||
inverse_timestamp=79938979954848 | inverse_timestamp=79938979954848 | ||
where b.cur_id<>65260 | where b.cur_id<>65260 | ||
| − | </ | + | </nowiki></pre> |
Revision as of 03:06, 20 October 2006
Here are the steps used to add the links at the top that take one to the table of contents lists. E.g. here's what is at the top of Gen 1:1-5: The Old Testament > Genesis > Chapter 1
1. created file in excel. Here's the link.
2. uploaded file to test db.
3. ran the following code
UPDATE thestandardworks.cur b INNER JOIN test.Adding_TOC_Links a ON a.cur_id=b.cur_id SET b.cur_text = concat(text_to_add,' ',b.cur_text), cur_timestamp= 20061020045151, cur_touched=20061020045151, inverse_timestamp=79938979954848 where b.cur_id<>65260
