From e4129fdebf270ab4a586af93947278817ed89349 Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Mon, 3 Nov 2014 15:04:17 +0000 Subject: Add support for NULL and DEFAULT values in viewtable, create/update/delete tableentry --- lib/db-viewtable-html.lsp | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'lib/db-viewtable-html.lsp') diff --git a/lib/db-viewtable-html.lsp b/lib/db-viewtable-html.lsp index bd4f051..9b60720 100644 --- a/lib/db-viewtable-html.lsp +++ b/lib/db-viewtable-html.lsp @@ -106,7 +106,13 @@ allowupdate = allowupdate and viewlibrary.check_permission("updatetableentry") <% end %> <% for i,f in ipairs(form.value.fields.value) do %> - <%= html.html_escape(tableentry[f]) %> + + <% if not tableentry[f] then %> + NULL + <% else %> + <%= html.html_escape(tableentry[f]) %> + <% end %> + <% end %> <% end %> -- cgit v1.2.3