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
LVL 8
newbie27Asked:
Who is Participating?
 
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
 
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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
ZvonkoSystems architectCommented:
Are you talking about this page:
http://213.253.134.6/artism/admin/list_export.asp

0
 
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
 
newbie27Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.