diff options
Diffstat (limited to 'weblog-adhocquery-html.lsp')
| -rw-r--r-- | weblog-adhocquery-html.lsp | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/weblog-adhocquery-html.lsp b/weblog-adhocquery-html.lsp index 2923005..fde57d5 100644 --- a/weblog-adhocquery-html.lsp +++ b/weblog-adhocquery-html.lsp @@ -1,5 +1,5 @@ <% local form, viewlibrary, page_info = ... -require("viewfunctions") +require("htmlviewfunctions") %> <style type="text/css"> @@ -45,7 +45,7 @@ require("viewfunctions") <% end %> <H1><%= html.html_escape(form.label) %></H1> -<% displayformstart(form, page_info) %> +<% htmlviewfunctions.displayformstart(form, page_info) %> This form accepts a Postgresql SELECT statement and displays the results. Examples: <ul> <li>This statement will return the total bytes transferred by each user for the pre-purge weblog history<pre>SELECT clientuserid, sum(bytes) AS total FROM pubweblog GROUP BY clientuserid ORDER BY total DESC</pre> @@ -53,8 +53,8 @@ This form accepts a Postgresql SELECT statement and displays the results. Exampl <li>This statement will return the number of requests and blocks by hour over the course of the entire usage history<pre>SELECT extract(hour from date) AS hour, sum(numrequest) AS numrequest, sum(numblock) AS numblock FROM usagestat GROUP BY extract(hour from date) ORDER BY hour</pre> </ul> The available database tables and descriptions are listed below. -<% displayformitem(form.value.query, "query") %> -<% displayformend(form) %> +<% htmlviewfunctions.displayformitem(form.value.query, "query") %> +<% htmlviewfunctions.displayformend(form) %> <H2>Available Database Tables</H2> <H3>pubweblog and pubweblog_history</H3> |