From 48a82fb1b5dc6df0533f688731b1207d190c5489 Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Tue, 19 Nov 2013 00:20:36 +0000 Subject: Fixed adhocquery to return columns in proper order --- weblog-model.lua | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'weblog-model.lua') diff --git a/weblog-model.lua b/weblog-model.lua index 2a771b0..eca067a 100644 --- a/weblog-model.lua +++ b/weblog-model.lua @@ -1357,6 +1357,10 @@ function mymodule.adhocquery(self, query) query.value.query.errtxt = err or "Select failed" query.errtxt = "Query failed" else + query.value.names = cfe({ type="list", value={}, label="Column names" }) + query.value.names.value = cur:getcolnames() + query.value.types = cfe({ type="list", value={}, label="Column types" }) + query.value.types.value = cur:getcoltypes() query.value.result = cfe({ type="list", value={}, label="Select result" }) local result = query.value.result.value local row = cur:fetch ({}, "a") -- cgit v1.2.3