Response title
This is preview!
- Screen name: greg.marc.silverman
greg.marc.silverman's Profile
2 Posts
2 Responses
0
Followers
Activity Trend
Last 30 days
- Last 30 days
- Date Interval
From Date : To Date :
Loading Chart...
Show:
- Expanded view
- List view
Private Message
- Dear collective wisdom,I have the following code to reset select menu controls:// reset menu controls; TODO - need to loop through all categories$('#btn-reset').live('click', function() {var myselect = $("select#useOfColor");myselect[0].selectedIndex = 0;myselect.selectmenu("refresh");myselect = $("select#plantVariety");myselect[0].selectedIndex = 0;myselect.selectmenu("refresh");myselect = $("select#design");myselect[0].selectedIndex = 0;myselect.selectmenu("refresh");myselect = $("select#maintenance");myselect[0].selectedIndex = 0;myselect.selectmenu("refresh");myselect = $("select#environmentalStewardship");myselect[0].selectedIndex = 0;myselect.selectmenu("refresh");});However, this list will only grow. Is there a more elegant method for making sure that all desired select menus in my web page will get cleared without having to add each specific one to this code?Danke Schoen!Greg--
- I have similar functions in my app that work just swimmingly. The thing that sets this apart is that I am passing a variable to the function to use as parameter in the WHERE clause of a SELECT.The function is as follows:function LoadSite(id) {if (!window.openDatabase) {alert('Databases are not supported in this browser.');return;}var selectStatement = 'SELECT * FROM site WHERE id = ?';console.log('Select me:' + selectStatement);console.log('Session id:' + id);// this next section will select all the content from the site table as// queried by the passed variabledb.transaction(function(transaction) { // ****!!!!****transaction.executeSql(selectStatement, [id], function(transaction,result) {if (result != null && result.rows != null) {for ( var i = 0; i < result.rows.length; i++) {// load row into objectvar row = result.rows.item(i);var location = row.id + ' ' + row.site_id + ' ' +row.address + ' ' + row.city + ' ' + row.state + ' ' + row.zip;$('#lbWhere').append(location);console.log(location);}}}, errorHandler);}, errorHandler, nullHandler);return;};The issue is that I am getting an "Uncaught TypeError: Cannot call method 'transaction' of undefined..." (at the line with the ****!!!!**** above, where I have the closure db.transaction(function(transaction)) when the application fires in the console output. I assume that something is wrong with my SELECT statement, but for the life of me, I cannot figure it out. All documentation on use of parameters in SQLite queries are for everything but SELECT, but I figured I could use the syntax of a DELETE with a WHERE clause just as easily.Any ideas as to why this is choking?Thanks very much in advance!Greg--
- «Prev
- Next »
Moderate user : greg.marc.silverman