Not signed in (Sign In)

SkillShare - A place to discuss Web Standards and Web Design topics

Categories

Vanilla 1.1.9 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthorvinithktp
    • CommentTimeNov 4th 2007
     permalink
    Hi im new to ajax
    this is my javascript file

    var xmlHttp

    function showCustomer(str)
    {
    xmlHttp=GetXmlHttpObject();
    if (xmlHttp==null)
    {
    alert ("Your browser does not support AJAX!");
    return;
    }
    var url="auto_ getcustomer.jsp";
    url=url+"?q="+str;
    url=url+"&sid="+Math.random();
    xmlHttp.onreadystatechange=stateChanged;
    xmlHttp.open("GET",url,true);
    xmlHttp.send(null);
    }

    function stateChanged()
    {
    if (xmlHttp.readyState==4)
    {
    document.getElementById("txtHint").innerHTML=xmlHttp.responseText;
    }
    }

    function GetXmlHttpObject()
    {
    var xmlHttp=null;
    try
    {
    // Firefox, Opera 8.0+, Safari
    xmlHttp=new XMLHttpRequest();
    }
    catch (e)
    {
    // Internet Explorer
    try
    {
    xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
    }
    catch (e)
    {
    xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
    }
    }
    return xmlHttp;
    }

    here i can serach from db only by numericals values. For example if i give numerical value like: "123456789" i am getting the result. If i give any characters like "abcd" im not getting the result. can any one tell me wer i need to make the changes in code.
    thanking you
  1.  permalink

    What is the SQL query like? Does it work with "abcd"? If it does, are you calling the showCustomer function with showCustomer(abcd) or showCustomer("abcd")?

Add your comments
    Username Password
  • Format comments as (Help)