Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

how to handle ajax response

Hello Experts,
I am returning comma separated columns and pipe separated in the Ajax Response.
I have a SELECT tag in the page where user can select which column they want to use in the report,
How can I handle this !
Please advice.
Thanks
Sam
0
newbie27
Asked:
newbie27
  • 3
  • 2
2 Solutions
 
ZvonkoSystems architectCommented:
Like this:

<script>
function yourResponseFunction(){
  var theResponse = http.responseText;
  var theColumnNumber = document.forms[0].yourSelectName.value; // option value has to be column Number,  first column number zero
  var row = theResponse.split("|");
  for(var i=0;i<row.length;i++){
     var column = row[i].split(",");
     alert("Row"+i+"Column"+theColumnNumber+":  "+column[theColumnNumber]);
  }
}

</script>

0
 
newbie27Author Commented:
Hello Zvonko,
Thanks for your comment, I mean if you could please follow this
http://213.253.134.6/artism/admin/list_admin.asp 
user details: lau/lau
chose any 2 items from the page and click on export to actually see the page I am working on
hopefully you may understand what I am trying to do there.
thanks
sam
0
 
ZvonkoSystems architectCommented:
Are you talking about this page:
http://213.253.134.6/artism/admin/list_export.asp

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
newbie27Author Commented:
Yes, on this page I am doing an ajax call to retrieve details for the records submitted from list_admin.

Attached is the Asp script to process the Ajax request
rURL = RemoteServer & "/xmla/xml_results.asp?DBM=" & SiteName & "&SF1=keyword&ST1=" & ISBNLists							
			xTxt = GetXML(rUrl)
			'parts = Split(XMLField(xTxt, "resultfields", False), chr(28)) 
			parts = Split(XMLField( Replace(xTxt,",","&#44;"), "resultfields", False), chr(28))
            For each p in parts
			   strISBNData = strISBNData &  XMLField(p, "fv_co_name", false) & ","
			   strISBNData = strISBNData &  XMLField(p, "fv_co_address", false) & ","
			   strISBNData = strISBNData &  XMLField(p, "fv_co_descrip", false) & ","
			   strISBNData = strISBNData &  XMLField(p, "fv_co_tel_work", false) & ","
			   strISBNData = strISBNData &  XMLField(p, "fv_pe_name", false) & ","
			   strISBNData = strISBNData &  XMLField(p, "fv_pe_position", false) & ","
			   strISBNData = strISBNData &  XMLField(p, "fv_pe_tel_work", false) & ","
			   strISBNData = strISBNData &  XMLField(p, "fv_ref_no", false) & "|"			   
			next   
			response.Write strISBNData		

Open in new window

0
 
hieloCommented:
From your description, you stated that you have a formatted response and a select tag with options. Then your question is "How can I handle this !" What's the problem/goal?

If you are submitting an ajax request you will need a call back function that will receive the response text. You can split that text at the commas and if what you are trying to do is to "rebuild" the <SELECT> then wrap the <select> in some container tag:
<span id="selContainer"><select name="theList">...</select></span>

 and then insert a new html in that span so that it contains the entire <select> (not just the options)

...
 success=function (msg)
  {
    var sel="";
    var data = msg.split("|");
    if( data.length)
    {
    sel = "<select name='theList'>";
    for(var i=0; i < data.length; ++i)
    {
        var t = data[i].split(",")
        sel += '<option value="' + t[0] + '">' + t[1] + '</option>';
   }
    sel+='</select>';
   $("#selContainer").html(sel);
   }
  }
0
 
newbie27Author Commented:
thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now