Please post this in the Google Apps Script forum :D http://www.google.com/support/forum/p/apps-script/
-Vic On Thu, Feb 17, 2011 at 12:47 PM, dickleyjones <[email protected]>wrote: > ----I posted this in the old forums by mistake.---- > > I am using JDBC in some google apps script functions to verify data in a > google spreadsheet with an external mysql database. as you may imagine, > starting a new JDBC connection every time I want to use a function to check > data is slow. > > my solution so far has been to create the connection as a global variable. > this actually works (everything SEEMS much faster) BUT the custom menu items > I added in onOpen disappear. > > is there a better way to do this? > > i must add... > > if I comment out the JDBC global variable before I open the spreadsheet, my > custom menus load up as they should. Then, if I keep the ss open and > reactivate the global variable (remove //), everything works the way I want > it to. Or, at least, it SEEMS like it works the way I want it to. >
