Embed FTL Builder Code into Google Sites page

Instructions (based off the directions found here http://www.google.com/support/forum/p/sites/thread?tid=7d31c9ceaa70faec&hl=en).

  1. Copy the XML below and paste it in Notepad or some other text editor.
  2. Copy and paste your FTL Builder code between
    (the XML below already has some FTL Builder code between these lines - that code can be deleted).
  3. Save the file
  4. Click on the "More Actions" button at the top right of your Google Site, then click on "Manage Site"
  5. On left nav bar, click on "Attachments"
  6. Click "Upload" and upload the XML file
  7. On the uploaded file, right click on "download," and click on "Copy Link Address" or whatever gets the file location
  8. Go to the page you want to add the file and click "Edit Page"
  9. Find the spot you want the file, then click "Insert" at the upper left, and all the way at the bottom click "More Gadgets"
  10. Click "Add Gadget by URL" and paste the URL of your XML file you uploaded in step #7
title="Fusion Tables"
description="Fusion Tables"
<Content type="html"><![CDATA[
<!DOCTYPE html>
  #map_canvas { width: 500px; height: 400px; }

<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);

function changeMap() {
  var searchString = document.getElementById('searchString').value.replace("'", "\\'");
  layer.setQuery("SELECT 'Location' FROM " + tableid + " WHERE 'Name' CONTAINS IGNORING CASE '" + searchString + "'");

<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">


Special thanks to Michelle Minkoff for her great FAQ page!