normansolutions

SELECT TOP (100) PERCENT
  REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(EvName, ',', ' '), '&', 'and'), '/', '-'), '', ''), '', ' '), '', ''), '"', ''''), '  ',
	' ') AS subject,
	LEFT(CONVERT(varchar, CONVERT(date, CalDate)), 10) AS [start date],
	CONVERT(time, ISNULL(EvTime, CalDate)) AS [start Time],
	LEFT(CONVERT(varchar, CONVERT(date, CalDateEnd)), 10) AS [end date],
	CONVERT(time, ISNULL(EvTimeEnd, CalDateEnd)) AS [end Time],
	(CASE
		WHEN CONVERT(time, EvTime) IS NULL THEN 'True' ELSE 'False'
	END) AS [all day event],

normansolutions

<databases>
  <!-- Schoolbase Calendar -->  
  <database name="Schoolbase Calendar" friendlyName="Schoolbase Calendar">
    <connectionString>Server=YOUR_SQL_SERVER;Database=YOUR_SCHOOLBASE_DATABASE;User ID=YOUR_DB_USERID;Password=YOUR_DB_PASSWORD;Trusted_Connection=False;</connectionString>
    
    <!-- get categories list.  Inputs NONE.  Outputs: name -->
    <getCategoriesQuery>
      <![CDATA[  	   
			  SELECT distinct(eventtype) AS [name] from Events Ev inner join EventType Et on (ev.evtypeident = et.evtypeident)
		  ]]>

normansolutions

EXEC SearchAllTables '%%'

CREATE PROC SearchAllTables
(
  @SearchStr nvarchar(100)
)
AS
BEGIN

CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

normansolutions

<style>
    #map_canvas {
        max-width: 95%;
        height: 350px;
        border: 1px solid black;        
        border-radius: 5px;
        box-shadow: 7px 7px 5px #888;
    }
</style>

normansolutions

<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>

normansolutions

var map;

function initialize() {
    var mapOptions = {
        zoom: 2,
        center: new google.maps.LatLng(2.8, -187.3),
        mapTypeId: google.maps.MapTypeId.TERRAIN
    };

    map = new google.maps.Map(document.getElementById('map_canvas'),

normansolutions

window.eqfeed_callback = function (results) {
        var strHtml = '<ul>';
        for (var i = 0; i < results.features.length; i++) {
            var earthquake = results.features[i];
            var coords = earthquake.geometry.coordinates;
            var latLng = new google.maps.LatLng(coords[1], coords[0]);
            var marker = new google.maps.Marker({
                position: latLng,
                map: map,
                icon: getCircle(earthquake.properties.mag)

normansolutions

function getCircle(magnitude) {
      return {
          path: google.maps.SymbolPath.CIRCLE,
          fillColor: 'red',
          fillOpacity: .2,
          scale: Math.pow(2, magnitude) / Math.PI,
          strokeColor: 'white',
          strokeWeight: .5
      };
  }

normansolutions

#map_canvas {
        max-width: 95%;
        height: 350px;
        border: 1px solid black;
        border-radius: 5px;
        box-shadow: 7px 7px 5px #888;
  }

normansolutions

<h1>Earthquake Map <em>(the past 24 hours)</em></h1>
  <div id="map_canvas"></div>
<h2><u>Most recent events</u></h2>
  <div id="earthQuake"></div>