function createInnerHTML – how to repeat with other form input?

I have the below code; .gs function createInnerHTML() { var ss = SpreadsheetApp.getActive(); var names = ss.getSheetByName(“WELD DATE LOG”); var namesValues = names.getRange(2,13,names.getLastRow()-1).getValues(); var innerHTML = []; for (var i=0;i<namesValues.length;i++){ innerHTML.push({value:”+ namesValues[i][0], text:namesValues[i][0]}); }; return innerHTML; } .html <? var innerHTML= createInnerHTML(); ?> <select name=”JOINT” id=”JOINT” aria-label=”JOINT” aria-required=”true” required=””> <option value=””></option> <? innerHTML.forEach(function(option) { ?>…

Details

after end of resultset exception

I have that problem of after end of resultset even if I’m using just one rs.next(). I started first by importing sql packages, then I created connection and I executed the query .. <%@ page language=”java” contentType=”text/html; charset=ISO-8859-1″ pageEncoding=”ISO-8859-1″%> <%@ page import=”java.sql.DriverManager” %> <%@ page import=”java.sql.ResultSet” %> <%@ page import=”java.sql.SQLException” %> <%@ page import=”java.sql.Statement” %>…

Details