Posterous Templating I
HTML
<script src="https://www.quickbase.com/db/befe2yy7d?a=dbpage&pagename=jquery.tmpl.min.js"></script>
<script id="template" type="text/x-jquery-tmpl">
<tr>
<td>${$data["Listing"]}</td>
<td>${$data["Address"]}</td>
<td>${$data["City"]}</td>
<td>${$data["State"]}</td>
<td>${$data["Zip"]}</td>
</tr>
</script>
<h2>Current Properties</h2>
<table id="Listings">
<tr>
<th>Listing</th>
<th>Address</th>
<th>City</th>
<th>State</th>
<th>Zip</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/bgctx6926";
url += "?act=API_GenResultsTable";
url += "&qid=23";
url += "&jsa=1";
var data1=[];
var data2={};
$.getScript(url,function(){
data1=$.map(qdb_data, function(item1,index1){
data2={};
$.each(item1, function(index2,item2){
data2[qdb_heading[index2]]=item2;
});
return data2;
});
$("#template").tmpl(data1).appendTo("#listing");
});