Difference between revisions of "Site:Developer stuff/Adding links to TOC"
From Feast upon the Word (http://feastupontheword.org). Copyright, Feast upon the Word.
m (switching codes) |
(fixing link) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
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]]: | 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]] > [[Genesis 1|Chapter 1]] | [[The Old Testament]] > [[Genesis]] > [[Genesis 1|Chapter 1]] | ||
| − | 1. created file | + | 1. created file using excel. Here's the [[Media:Upload.zip|CSV]] result. |
2. uploaded file to test db. | 2. uploaded file to test db. | ||
| Line 9: | Line 10: | ||
<pre><nowiki> | <pre><nowiki> | ||
| − | UPDATE | + | UPDATE feastupontheword.cur b |
INNER JOIN test.Adding_TOC_Links a | INNER JOIN test.Adding_TOC_Links a | ||
ON a.cur_id=b.cur_id | ON a.cur_id=b.cur_id | ||
| Line 17: | Line 18: | ||
cur_touched=20061020045151, | cur_touched=20061020045151, | ||
inverse_timestamp=79938979954848 | inverse_timestamp=79938979954848 | ||
| − | |||
</nowiki></pre> | </nowiki></pre> | ||
Latest revision as of 03:16, 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 using excel. Here's the CSV result.
2. uploaded file to test db.
3. ran the following code
UPDATE feastupontheword.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
