anatoliatile

by dandiebolt

HTML

USERID: <input type="text" name="userid" id="userid"><br/>
PASSWD: <input type="text" name="passwd" id="passwd"><br/>
SEARCH: <input type="text" name="search" id="search"><br/>

<button onclick="DoIt()">DoIt()</button>

<hr/>
<div id="here"></div>

<hr/>

<h1>XML Response</h1>
<textarea id="xml" cols="70" rows="50"></textarea>

JavaScript

function DoIt() {
    var userid = $("#userid").val();
    //alert("userid=" + userid);

    var passwd= $("#passwd").val();
    //alert("passwd=" + passwd);

    var search= $("#search").val();
    //alert("search=" + search);
    
    var query = "";
    query += "use 'https://www.quickbase.com/db/bgcwm2m3z?a=dbpage&pagename=anatoliatile.xml' as anatoliatile; "
    query += "select * from anatoliatile ";
    query += "where ";
    query += "userid='" + userid + "' "; 
    query += "and passwd='" + passwd + "' "; 
    query += "and item='" + search + "' ";
    
    //alert("query="+query);
    //prompt("query=",query);
    
    var yql = "";
    yql += "http://query.yahooapis.com/v1/public/yql?q=";
    yql += encodeURIComponent(query);
    yql += "&format=xml";
    yql += "&callback=?";
    //alert("yql="+yql);
    //prompt("yql=",yql);
    $.getJSON(yql, function(data) {
        //alert("data.results[0]="+data.results[0]);
        console.dir(data);
        var contents = $("<div/>").html(data.results[0]).text();
        $("#here").html(contents);
        $("#xml").val(data.results[0]);
    });
}