Documentation Source Text

Check-in [910e5ab927]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Improved show/hide on the docs.html page.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | mobile-friendly
Files: files | file ages | folders
SHA1: 910e5ab927a250df26c26e0cb70089ea58109910
User & Date: drh 2016-09-01 16:32:43.749
Context
2016-09-01
18:13
Display improvements for the list-of-documents documents. (check-in: 0ff35a28c6 user: drh tags: mobile-friendly)
16:32
Improved show/hide on the docs.html page. (check-in: 910e5ab927 user: drh tags: mobile-friendly)
15:15
Simplify the JSON documentation for better display on mobile. (check-in: 08908c99e5 user: drh tags: mobile-friendly)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/doclist.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<title>Alphabetical List Of SQLite Documents</title>
<h1 align=center>Alphabetical List Of SQLite Documents</h1>
<tcl>hd_keywords {*doclist}</tcl>

<table align=right border=1 cellpadding=10>
<tr><td>See Also:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[permuted index | Permuted Title Index]
<li>[keyword index | Website Keyword Index]
</ul>
</table>

<ol>
<tcl>
hd_keywords {alphabetical listing of SQLite documents}
db eval {
  SELECT filename, pagetitle
    FROM page




|
|






|







1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<title>Alphabetical List Of SQLite Documents</title>
<h1 align=center>Alphabetical List Of SQLite Documents</h1>
<tcl>hd_keywords {*doclist}</tcl>

<var class="rightsidebar border2px">
See Also:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[permuted index | Permuted Title Index]
<li>[keyword index | Website Keyword Index]
</ul>
</var>

<ol>
<tcl>
hd_keywords {alphabetical listing of SQLite documents}
db eval {
  SELECT filename, pagetitle
    FROM page
Changes to pages/docs.in.
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<title>SQLite Documentation</title>

<h1 align="center">Document Categories</h1>













<script>
function toggle_docs(n){
  var w = document.getElementById("doclist_ul"+n);
  var a = document.getElementById("doclist_a"+n);
  if( w.style.display=="none" ){
    w.style.display = "block";
    a.innerHTML = "-";
  }else{
    w.style.display = "none";
    a.innerHTML = "+";
  }
}
</script>
<style>
.onoff {
  text-decoration:none;
  border: 2px solid black;
  border-radius: 8px;
  font-weight: bold;
  padding-left: 5px;
  padding-right: 5px;
  line-height: 150%;
}
</style>
<ol>
<tcl>
hd_keywords {categorical listing of SQLite documents} {documents by category}
set prevHead {}
set lDoc {}
set cnt 0
proc doc {name url desc} {
  global lDoc
  lappend lDoc $name $url
}
proc heading {text tag {caption {}}} {
  end_heading
  set ::prevHead $text
}
proc end_heading {} {
  global lDoc cnt prevHead
  if {$prevHead==""} return
  incr cnt
  hd_putsnl "<li><b>$prevHead</b>"
  hd_puts "<a id='doclist_a$cnt' href='javascript:void(0)'"
  hd_puts " class='onoff' onclick='toggle_docs($cnt)'>+</a>"
  hd_putsnl "<ul id='doclist_ul$cnt' style='display:none;'>"
  foreach {name url} $lDoc {
    hd_putsnl "<li><a href='$url'>$name</a>"
  }
  hd_putsnl </ul>
  set lDoc {}
}
source [file join $::DOC pages docsdata.tcl]
end_heading
</tcl>
</ol>


|
>
>
>
>
>
>
>
>
>
>
>
>
>

|
|
|
|
|
|
|
|
|



<
<
|
<
<
<
<
<
<
<
<
<

















<
|
|
|









|
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

48
49
50
51
52
53
54
55
56
57
58
59
60
<title>SQLite Documentation</title>

<h1 align="center">Documents By Category</h1>
<style>
ul.showhide {
  margin-left: 0;
  padding-left: 0;
  list-style-type: none;
}
.showhide ul {display: none;}
.showhide > li > a {
  text-decoration: none;
  color: black;
  cursor: pointer;
}
</style>
<script>
function showhide(n){
  var ul = document.getElementById("sh_sub_"+n)
  var mk = document.getElementById("sh_mark_"+n)
  if( ul.style.display!="block" ){
    ul.style.display = "block";
    mk.innerHTML = "&#x25bc;";
  } else {
    ul.style.display = "none";
    mk.innerHTML = "&#x25b6;";
  }
}
</script>


<ul class="showhide">









<tcl>
hd_keywords {categorical listing of SQLite documents} {documents by category}
set prevHead {}
set lDoc {}
set cnt 0
proc doc {name url desc} {
  global lDoc
  lappend lDoc $name $url
}
proc heading {text tag {caption {}}} {
  end_heading
  set ::prevHead $text
}
proc end_heading {} {
  global lDoc cnt prevHead
  if {$prevHead==""} return
  incr cnt

  hd_puts "<li><a onclick='showhide($cnt)'><span id='sh_mark_$cnt'>"
  hd_puts "&#x25b6;</span> $prevHead</a>\n"
  hd_putsnl "<ul id='sh_sub_$cnt'>"
  foreach {name url} $lDoc {
    hd_putsnl "<li><a href='$url'>$name</a>"
  }
  hd_putsnl </ul>
  set lDoc {}
}
source [file join $::DOC pages docsdata.tcl]
end_heading
</tcl>
</ul>
Changes to pages/keyword_index.in.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<title>Website Keyword Index</title>
<h1 align=center>Website Keyword Index</h1>

<table align=right border=1 cellpadding=10>
<tr><td>Other Documentation Indices:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[doclist | Alphabetical List Of Documents]
<li>[permuted index | Permuted Document Title Index]
</ul>
</table>

<ul>
<tcl>
hd_keywords {keyword index}
db eval {
  UPDATE keyword SET indexKw=0
   WHERE kw GLOB '*s' AND indexKw



|
|






|







1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<title>Website Keyword Index</title>
<h1 align=center>Website Keyword Index</h1>

<var class="rightsidebar border2px">
Other Documentation Indexes:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[doclist | Alphabetical List Of Documents]
<li>[permuted index | Permuted Document Title Index]
</ul>
</var>

<ul>
<tcl>
hd_keywords {keyword index}
db eval {
  UPDATE keyword SET indexKw=0
   WHERE kw GLOB '*s' AND indexKw
Changes to pages/sitemap.in.
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<title>SQLite Site Map</title>

<h2>Popular Pages:</h2>

<table border=0 width="100%">
<tr><td valign=top><ul>
<li> <a href="index.html">Home</a> </li>
<li> <a href="features.html">Features</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>
<li> <a href="famous.html">Well-known Users</a> </li>
<li> <a href="quickstart.html">Getting Started</a> </li>
<li> <a href="whentouse.html">When To Use SQLite</a> </li>
<li> <a href="different.html">Distinctive Features</a> </li>
<li> <a href="doclist.html">Alphabetical list of docs</a> </li>
<li> <a href="books.html">Books About SQLite</a> </li>
<li> <a href="keyword_index.html">Website Keyword Index</a> </li>
</ul><td valign=top><ul>
<li> <a href="copyright.html">Copyright</a>
<li> <a href="lang.html">SQL Syntax</a>
<ul>
<li> <a href="pragma.html#toc">Pragmas</a>
<li> <a href="lang_corefunc.html">SQL functions</a>
<li> <a href="lang_datefunc.html">Date &amp; time functions</a>
<li> <a href="lang_aggfunc.html">Aggregate functions</a>
</ul>
<li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>
<ul>
<li> <a href="cintro.html">Introduction</a>
<li> <a href="c3ref/funclist.html">List of C-language APIs</a>
</ul>
</li>
<li> <a href="tclsqlite.html">The TCL Interface Spec</a>
</ul><td valign=top><ul>
<li> <a href="support.html#mailinglists">Mailing Lists</a> </li>
<li> <a href="news.html">News</a> </li>
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>
<li> <a href="download.html#cvs">Version control</a>
  <ul>
  <li> <a href="http://www.sqlite.org/src">Source code timeline</a> </li>
  <li> <a href="http://www.sqlite.org/docsrc">Documentation timeline</a> </li>
  </ul>
</ul>
</table>

<tcl>hd_fragment pindex {permuted index}</tcl>
<h2>Permuted Index:  
<small><a href="http://en.wikipedia.org/wiki/Key_Word_in_Context">(what is
this?)</a></small></h2>

<table align=right border=1 cellpadding=10>
<tr><td>Other Documentation Indices:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[doclist | Alphabetical List Of Documents]
<li>[keyword index | Website Keyword Index]
</ul>
</table>

<ul>
<tcl>
db eval {
  DROP TABLE IF EXISTS px;
  CREATE TEMP TABLE px(title COLLATE nocase,link);
}


<

<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
|
|
<
<

|
|






|







1
2

3








































4
5


6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<title>SQLite Site Map</title>











































<tcl>hd_keywords {permuted index}</tcl>
<h2>Permuted Index:</h2>



<var class="rightsidebar border2px">
Other Documentation Indices:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[doclist | Alphabetical List Of Documents]
<li>[keyword index | Website Keyword Index]
</ul>
</var>

<ul>
<tcl>
db eval {
  DROP TABLE IF EXISTS px;
  CREATE TEMP TABLE px(title COLLATE nocase,link);
}