diff options
Diffstat (limited to '')
| -rw-r--r-- | docs/source/cookbook.rst | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/docs/source/cookbook.rst b/docs/source/cookbook.rst index 3eb0ffd..9523235 100644 --- a/docs/source/cookbook.rst +++ b/docs/source/cookbook.rst @@ -1,4 +1,3 @@ - .. _Cookbook: Cookbook @@ -69,9 +68,9 @@ Count client IPs in web access logs To count the occurrences of an IP in web access logs and order the results from highest to lowest: - .. code-block:: custsqlite +.. code-block:: custsqlite - ;SELECT c_ip, count(*) as hits FROM access_log GROUP BY c_ip ORDER BY hits DESC + ;SELECT c_ip, count(*) as hits FROM access_log GROUP BY c_ip ORDER BY hits DESC Show only lines where a numeric field is in a range @@ -81,9 +80,9 @@ The :ref:`:filter-expr<filter_expr>` command can be used to filter web access logs to only show lines where the number of bytes transferred to the client is between 10,000 and 40,000 bytes like so: - .. code-block:: custsqlite +.. code-block:: custsqlite - :filter-expr :sc_bytes BETWEEN 10000 AND 40000 + :filter-expr :sc_bytes BETWEEN 10000 AND 40000 Generating a Report |