Solved

how to handle ajax response

Posted on 2008-06-17
6
230 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Move inline javascript functions to external .js file in asp.net 12 57
Get Text of Select using class name ***JavaScript Only*** 3 32
JQuery & Classic ASP 10 40
Split on ASP 8 51
In Part 1 (http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/A_7849-Hex-Maze.html) we covered the hexagonal maze basics -- how the cells are represented in a JavaScript array and how the maze is displayed.  In this part, we'…
This article will give core knowledge of JavaScript and will head in to your first JavaScript program. I am Durvesh Naik and I am here to deal with this series of JavaScript. I will teach you JavaScript in part wise , as its quite boring to read big…
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…

739 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