Get Action

Action


Server Side Javascript for GET method

SQL = transaction.getParameter("SQL"); if(SQL==null) { list = transaction.getParameter("listConnections"); if(list!=null) { db = js.getApi("/OpenForum/JarManager/JDBC"); connections = db.getConnections(); data = list+"= new Array();\n" for(loop=0;loop<connections.length;loop++) { data += list+"["+list+".length] = '"+connections[loop]+"';\n"; } transaction.sendPage(data); return; } else { transaction.setResult(transaction.SHOW_PAGE); } } else { dbName = transaction.getParameter("db"); type = transaction.getParameter("type"); if(type==null) { type = "query" } db = js.getApi("/OpenForum/JarManager/JDBC"); if(type=="query") { try{ result = db.query(dbName,SQL); } catch(e) { transaction.sendPage(e); } data = ""; columns = Number(result.getAttributeValueByName("columns")); xColumns = result.getElementByName("columns"); for(column=0;column<columns;column++) { data+="|__"+xColumns.getElementByIndex(column).getValue()+"__"; } data+="\n"; rows = result.getElementsByName("row"); for(row=0;row<rows.size();row++) { for(column=0;column<columns;column++) { data+="|"+rows.elementAt(row).getElementByIndex(column).getValue(); } data+="\n"; } } else { data = db.execute(dbName,SQL); } page = wiki.renderWikiData( "Result",data ); transaction.sendPage(page); }