Instructions (based off the directions found here http://www.google.com/support/forum/p/sites/thread?tid=7d31c9ceaa70faec&hl=en).
<![CDATA[and
]]></Content>(the XML below already has some FTL Builder code between these lines - that code can be deleted).
<Module>
<ModulePrefs
title="Fusion Tables"
title_url="http://www.google.com/fusiontables"
description="Fusion Tables"
width="520"
height="450">
</ModulePrefs>
<Content type="html"><![CDATA[
<!DOCTYPE html>
<html>
<head>
<style>
#map_canvas { width: 500px; height: 400px; }
</style>
<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
<script type="text/javascript">
var map;
var layer;
var tableid = 222171;
function initialize() {
map = new google.maps.Map(document.getElementById('map_canvas'), {
center: new google.maps.LatLng(37.26968150969718, -122.200927734375),
zoom: 8,
mapTypeId: google.maps.MapTypeId.ROADMAP
});
layer = new google.maps.FusionTablesLayer(tableid);
layer.setQuery("SELECT 'Location' FROM " + tableid);
layer.setMap(map);
}
function changeMap() {
var searchString = document.getElementById('searchString').value.replace("'", "\\'");
layer.setQuery("SELECT 'Location' FROM " + tableid + " WHERE 'Name' CONTAINS IGNORING CASE '" + searchString + "'");
}
</script>
</head>
<body onload="initialize();">
<div id="map_canvas"></div>
<div style="margin-top: 10px;">
<label>Name </label>
<input type="text" id="searchString">
<input type="button" onclick="changeMap();" value="Search">
<div>
</body>
</html>
]]></Content>
</Module>
Special thanks to Michelle Minkoff for her great FAQ page!