summaryrefslogtreecommitdiffstats
path: root/weblog-model.lua
diff options
context:
space:
mode:
authorTed Trask <ttrask01@yahoo.com>2013-11-19 00:20:36 +0000
committerTed Trask <ttrask01@yahoo.com>2013-11-19 00:20:36 +0000
commit48a82fb1b5dc6df0533f688731b1207d190c5489 (patch)
tree0dd65ab075d8b5a2d2e29ffa34b97f6427a7a8e4 /weblog-model.lua
parentcc7cd9d7049dcaa7809733df1b81f6fbdbfb69ea (diff)
downloadacf-weblog-48a82fb1b5dc6df0533f688731b1207d190c5489.tar.bz2
acf-weblog-48a82fb1b5dc6df0533f688731b1207d190c5489.tar.xz
Fixed adhocquery to return columns in proper order
Diffstat (limited to 'weblog-model.lua')
-rw-r--r--weblog-model.lua4
1 files changed, 4 insertions, 0 deletions
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")