Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | :-) (CVS 85) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 8b1c151b7b2243672a0bf0ac8377e82c |
| User & Date: | drh 2000-06-08 19:43:40 |
Context
|
2000-06-08
| ||
| 21:53 | :-) (CVS 86) check-in: 049abcb3 user: drh tags: trunk | |
| 19:43 | :-) (CVS 85) check-in: 8b1c151b user: drh tags: trunk | |
| 19:38 | :-) (CVS 84) check-in: 57dce04a user: drh tags: trunk | |
Changes
Changes to www/sqlite.tcl.
1 2 3 4 5 6 7 8 9 10 11 ... 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 ... 192 193 194 195 196 197 198 199 200 201 202 203 204 205 ... 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 |
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: sqlite.tcl,v 1.7 2000/06/08 19:38:36 drh Exp $}
puts {<html>
<head>
<title>sqlite: A program of interacting with SQLite databases</title>
</head>
<body bgcolor=white>
<h1 align=center>
................................................................................
<h2>Changing Output Formats</h2>
<p>The sqlite program is able to show the results of a query
in four different formats: "line", "column", "list", and "html".
You can use the ".mode" dot command to switch between these three output
formats.</p>
puts {
<p>The default output mode is "list". In
list mode, each record of a query result is written on one line of
output and each field within that record is separated by a specific
separator string. The default separator is a pipe symbol ("|").
List mode is especially useful when you are going to send the output
of a query to another program (such as AWK) for additional processing.</p>}
................................................................................
sqlite> (((.separator ", ")))
sqlite> (((select * from tbl1;)))
hello, 10
goodbye, 20
sqlite>
}
<p>In "line" mode, each field in a record of the database
is shown on a line by itself. Each line consists of the field
name, an equal sign and the field data. Successive records are
separated by a blank line. Here is an example of line mode
output:</p>}
Code {
................................................................................
goodbye 20
sqlite>
}
puts {
<p>The last output mode is "html". In this mode, sqlite writes
the results of the query as an XHTML table. The beginning
<TABLE&;gt and the ending </TABLE> are not written, but
all of the intervening <TR>s, <TH>s, and <TD>s
are. The html output mode is envisioned as being useful for
CGI.</p>
}
puts {
<h2>Writing results to a file</h2>
|
| < > | |
1 2 3 4 5 6 7 8 9 10 11 ... 163 164 165 166 167 168 169 170 171 172 173 174 175 176 ... 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 ... 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 |
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: sqlite.tcl,v 1.8 2000/06/08 19:43:40 drh Exp $}
puts {<html>
<head>
<title>sqlite: A program of interacting with SQLite databases</title>
</head>
<body bgcolor=white>
<h1 align=center>
................................................................................
<h2>Changing Output Formats</h2>
<p>The sqlite program is able to show the results of a query
in four different formats: "line", "column", "list", and "html".
You can use the ".mode" dot command to switch between these three output
formats.</p>
<p>The default output mode is "list". In
list mode, each record of a query result is written on one line of
output and each field within that record is separated by a specific
separator string. The default separator is a pipe symbol ("|").
List mode is especially useful when you are going to send the output
of a query to another program (such as AWK) for additional processing.</p>}
................................................................................
sqlite> (((.separator ", ")))
sqlite> (((select * from tbl1;)))
hello, 10
goodbye, 20
sqlite>
}
puts {
<p>In "line" mode, each field in a record of the database
is shown on a line by itself. Each line consists of the field
name, an equal sign and the field data. Successive records are
separated by a blank line. Here is an example of line mode
output:</p>}
Code {
................................................................................
goodbye 20
sqlite>
}
puts {
<p>The last output mode is "html". In this mode, sqlite writes
the results of the query as an XHTML table. The beginning
<TABLE> and the ending </TABLE> are not written, but
all of the intervening <TR>s, <TH>s, and <TD>s
are. The html output mode is envisioned as being useful for
CGI.</p>
}
puts {
<h2>Writing results to a file</h2>
|