function queryEvents() { // get current dropdown values var dateRangeDD = document.getElementById("dateRange"); var dateRange = dateRangeDD.options[dateRangeDD.selectedIndex].text; var dateRangeVal = dateRangeDD.options[dateRangeDD.selectedIndex].value; alert ("dateRange = " + dateRange + ", dateRangeVal = " + dateRangeVal); var typeDD = document.getElementById("eventType"); var eventType = typeDD.options[typeDD.selectedIndex].text; var eventTypeVal = typeDD.options[typeDD.selectedIndex].value; alert ("eventType = " + eventType + ", eventTypeVal = " + eventTypeVal); var dateRangeSQL; switch (dateRange) { case "sqlAll": dateRangeSQL = sqlAll; break; case "sqlWeeks2": dateRangeSQL = sqlWeeks2; break; case "sqlWeeks4": dateRangeSQL = sqlWeeks4; break; case "sqlMonths3": dateRangeSQL = sqlMonths3; break; case "sqlMonths6": dateRangeSQL = sqlMonths6; break; } alert ("dateRangeSQL = " + dateRangeSQL); // get where clause for event type var eventTypeSQL; switch (eventType) { case "All": eventTypeSQL = "Type = '*'"; case "Conference": eventTypeSQL = "Type = 'Conference'"; break; case "Lecture": dateRangeSQL = "Type = 'Lecture'"; break; case "Workshop": dateRangeSQL = "Type = 'Workshop'"; break; } // built full SQL where clause for query var whereSQL = dateRangeSQL + " AND " + eventTypeSQL; // execute query executeQueryTask(whereSQL); }
<form name="campsite_search" method="get"> <select name="state" id="dateRange"> <option value="sqlAll">All events</option> <option value="sqlWeeks2">2 Weeks</option> <option value="sqlWeeks4">4 Weeks</option> <option value="sqlMonths3">3 Months</option> <option value="sqlMonths6">6 Months</option> </select> <select name="radius" id="eventType"> <option value="All">All events</option> <option value="Conference">Conference</option> <option value="Lecture">Lecture</option> <option value="Workshop">Workshop</option> </select> <input type="BUTTON" OnClick="queryEvents()" class="input" value="Continue" />
<input type="BUTTON" OnClick="queryEvents(); return false;" class="input" value="Continue" />
<div name="campsite_search"> <select name="state" id="dateRange" data-dojo-type="dijit.form.Select"> <option value="sqlAll">All events</option> <option value="sqlWeeks2">2 Weeks</option> <option value="sqlWeeks4">4 Weeks</option> <option value="sqlMonths3">3 Months</option> <option value="sqlMonths6">6 Months</option> </select> <select name="radius" id="eventType" data-dojo-type="dijit.form.Select"> <option value="All">All events</option> <option value="Conference">Conference</option> <option value="Lecture">Lecture</option> <option value="Workshop">Workshop</option> </select> <button data-dojo-type="dijit.form.Button" OnClick="queryEvents" type="button">Continue</button> </div>
function queryEvents() { // get current dropdown values var dateRangeDD = dijit.byId("dateRange"), typeDD = dijit.byId("eventType"); var dateRange = dataRangeDD.get("Value"), eventType = typeDD.get("Value"); var dateRangeSQL, eventTypeSQL; //get where clause for event type switch (dateRange) { case "sqlAll": dateRangeSQL = sqlAll; break; case "sqlWeeks2": dateRangeSQL = sqlWeeks2; break; case "sqlWeeks4": dateRangeSQL = sqlWeeks4; break; case "sqlMonths3": dateRangeSQL = sqlMonths3; break; case "sqlMonths6": dateRangeSQL = sqlMonths6; break; } // get where clause for event type switch (eventType) { case "All": eventTypeSQL = "Type = '*'"; case "Conference": eventTypeSQL = "Type = 'Conference'"; break; case "Lecture": dateRangeSQL = "Type = 'Lecture'"; break; case "Workshop": dateRangeSQL = "Type = 'Workshop'"; break; } // built full SQL where clause for query var whereSQL = dateRangeSQL + " AND " + eventTypeSQL; // execute query executeQueryTask(whereSQL); }