Posterous Templating II

by dandiebolt

HTML

<script src="https://www.quickbase.com/db/befe2yy7d?a=dbpage&amp;pagename=jquery.tmpl.min.js"></script>
<script id="template" type="text/x-jquery-tmpl">
    <tr>
        <td>${$data[0]}</td>
        <td>${$data[1]}</td>
        <td>${$data[2]}</td>
        <td>${$data[3]}</td>
        <td>${$data[4]}</td>
        <td>${$data[5]}</td>
    </tr>
</script>

<h2>TPS Cover Sheet Summary Report</h2>
<table id="report">
    <tr>
        <th>Prepared By</th>
        <th>Date</th>
        <th>System</th>
        <th>Platform</th>
        <th>Program Language</th>
        <th>Test Date</th>
    </tr>
</table>

CSS

body {
    font: normal 11px auto "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
    color: #4f6b72;
    background: #E6EAE9;
}

a {
    color: #c75f3e;
}

#mytable {
    width: 700px;
    padding: 0;
    margin: 0;
}

caption {
    padding: 0 0 5px 0;
    width: 700px;     
    font: italic 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
    text-align: right;
}

th {
    font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
    color: #4f6b72;
    border-right: 1px solid #C1DAD7;
    border-bottom: 1px solid #C1DAD7;
    border-top: 1px solid #C1DAD7;
    letter-spacing: 2px;
    text-transform: uppercase;
    text-align: left;
    padding: 6px 6px 6px 12px;
    background: #CAE8EA url(images/bg_header.jpg) no-repeat;
}

th.nobg {
    border-top: 0;
    border-left: 0;
    border-right: 1px solid #C1DAD7;
    background: none;
}

td {
    border-right: 1px solid #C1DAD7;
    border-bottom: 1px solid #C1DAD7;
    background: #fff;
    padding: 6px 6px 6px 12px;
    color: #4f6b72;
}


td.alt {
    background: #F5FAFA;
    color: #797268;
}

th.spec {
    border-left: 1px solid #C1DAD7;
    border-top: 0;
    background: #fff url(images/bullet1.gif) no-repeat;
    font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
}

th.specalt {
    border-left: 1px solid #C1DAD7;
    border-top: 0;
    background: #f5fafa url(images/bullet2.gif) no-repeat;
    font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
    color: #797268;
}

JavaScript

var url = "";
url += "https://www.quickbase.com/db/bgisavjxe";
url += "?act=API_GenResultsTable";
url += "&qid=6";
url += "&jsa=1";

$.getScript(url,function(){
    $("#template").tmpl(qdb_data).appendTo("#report");  
});