diff options
author | Zach LeBar <zach@zachlebar.com> | 2012-08-18 20:02:36 +0000 |
---|---|---|
committer | Zach LeBar <zach@zachlebar.com> | 2012-08-18 20:02:36 +0000 |
commit | bb6fd68db726c6b4d1a12e82a741d4248b0c70de (patch) | |
tree | 10797e2010478358ff146afdb237cbc9266459bc /kamailio-searchdatabase-html.lsp | |
download | acf-kamailio-bb6fd68db726c6b4d1a12e82a741d4248b0c70de.tar.bz2 acf-kamailio-bb6fd68db726c6b4d1a12e82a741d4248b0c70de.tar.xz |
Further tweaks to support PostgreSQL 'schemas' and a hack to allow DISTributary Phone System Tool: 'ASHP' to submit NULL values into integer columns. The ability to add NULL values should be implemented in the near future.
Diffstat (limited to 'kamailio-searchdatabase-html.lsp')
-rw-r--r-- | kamailio-searchdatabase-html.lsp | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/kamailio-searchdatabase-html.lsp b/kamailio-searchdatabase-html.lsp new file mode 100644 index 0000000..87f0a9d --- /dev/null +++ b/kamailio-searchdatabase-html.lsp @@ -0,0 +1,28 @@ +<% local form, viewlibrary, page_info = ... +require("viewfunctions") +%> + +<% if form.value.result then + local func = haserl.loadfile(page_info.viewfile:gsub("searchdatabase", "viewtable")) + local table, column = string.match(form.value.id.value, "^([^.]*)%.(.*)") + form.value.table = cfe({ value=table }) + form.value.fields = cfe({ value={} }) + for i,o in ipairs(form.value.id.option) do + local t,c = string.match(o, "^([^.]*)%.(.*)") + if t == table then + form.value.fields.value[#form.value.fields.value + 1] = c + end + end + form.value.entries = form.value.result + func(form, viewlibrary, page_info, session) + form.value.entries = nil + form.value.table = nil + form.value.fields = nil +end %> + +<H1><%= html.html_escape(form.label) %></H1> +<% + form.value.result = nil + form.option = "Search" + displayform(form, nil, nil, page_info, 2) +%> |