Solved

how to handle ajax response

Posted on 2008-06-17
6
227 Views
Last Modified: 2010-05-18
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
Comment
Question by:newbie27
  • 3
  • 2
6 Comments
 
LVL 63

Assisted Solution

by:Zvonko
Zvonko earned 150 total points
ID: 21803151
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
 
LVL 8

Author Comment

by:newbie27
ID: 21803280
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
 
LVL 63

Expert Comment

by:Zvonko
ID: 21803391
Are you talking about this page:
http://213.253.134.6/artism/admin/list_export.asp

0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 8

Author Comment

by:newbie27
ID: 21803426
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
 
LVL 82

Accepted Solution

by:
hielo earned 350 total points
ID: 21811902
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
 
LVL 8

Author Closing Comment

by:newbie27
ID: 31467954
thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
JavaScript can be used in a browser to change parts of a webpage dynamically. It begins with the following pattern: If condition W is true, do thing X to target Y after event Z. Below are some tips and tricks to help you get started with JavaScript …
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now