# HG changeset patch
# User catherine@dellzilla
# Date 1237383865 14400
# Node ID e4869b369e12f94b2e76892c0bd85506de82dc5b
# Parent  7aa24643e3581537510e4aa21d56d819cae7f5be
json now works with numbers, etc

diff -r 7aa24643e358 -r e4869b369e12 sqlpython/output_templates.py
--- a/sqlpython/output_templates.py	Wed Mar 18 09:28:21 2009 -0400
+++ b/sqlpython/output_templates.py	Wed Mar 18 09:44:25 2009 -0400
@@ -24,8 +24,10 @@
 }"""),  
 
 '\\j': genshi.template.NewTextTemplate("""
-{"${tblname}_resultset": [
-${',\\n'.join('        {%s}' % ', '.join('"%s": %s' % (colname,'"%s"' % itm) for (colname, itm) in zip(colnames, row)) for row in rows)}
+{"${tblname}": [
+${',\\n'.join('        {%s}' % ', '.join('"%s": %s' % (colname,
+        ((isinstance(itm,int) or isinstance(itm,float)) and '%s' or '"%s"') % str(itm)
+    ) for (colname, itm) in zip(colnames, row)) for row in rows)}
     ]
 }"""),