Cancel
Block
Black
Refund
Enquiry
Complaint

**這個是在做選取時的HTML格式**，後面顯示的表格有分一個有服務跟沒服務，所以一個是"haveServive"NoaveServive"。 function getSelectedData(){ var objArr = document.getElementsByName("checkRequest"); var temp=""; for( var i=0;i< objArr.length;i++){ if(objArr[i].checked){ if(temp==""){ temp= "'" + objArr[i].value + "'"; }else{ temp= temp + ",'" + objArr[i].value + "'"; } } } selectService(temp); selectNoService(temp); } ***這上方是所跑的迴圈** function selectService(temp){ alert(temp); var url = "GetDataWithService.cfm?"; var http_request = false; if (window.XMLHttpRequest) { // Mozilla, Safari,... http_request = new XMLHttpRequest(); //http_request.overrideMimeType('text/xml'); } else if (window.ActiveXObject) { // IE try { // 新版的 IE http_request = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { // 舊版的 IE http_request = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) {} } } if (!http_request) { alert('Giving up :( Cannot create an XMLHTTP instance'); return false; } http_request.onreadystatechange = function(){alertContents1(http_request);}; http_request.open('GET', url+"Reason="+temp+"&"+new Date().getTime(), true); http_request.send(null); function alertContents1(http_request) { if (http_request.readyState == 4) { if (http_request.status == 200) { var result = trimAll(http_request.responseText).Trim(); var temp = result.split(";"); //html = "" + SubReasonName + "
"; }else{ html = html + "" + SubReasonName + "
"; } } //html+= "" document.getElementById("haveServive").innerHTML = html; } else { alert(http_request.statusText); alert('There was a problem with the request.'); } } } } ***我這裏設定把有服務跟沒服務分別導向不同的URL去跑SQL，我只貼一個給您看，另一個大同小異*** select CS_SubReasonId,CS_ReasonId,SubReasonName,Active from Smsapplications.dbo.CS_SubReason with (NOLOCK) WHERE Active=1 and Subtype =1 and #URL.Reason# in(58,59,60,61,62,63) and CS_ReasonID in('#URL.Reason#') ||#SelectReason.CS_SubReasonId#||#SelectReason.SubReasonName#; **這一段是跑SQL的指令**

KwCheng's blog