I needed to update a column with the date and time whenever a record changed in my database. So here is the recipe for the trigger in MySQL 5.0.
DELIMITER $$
CREATE /*[DEFINER = { user | CURRENT_USER }]*/ TRIGGER `my_database`.`UpdatedOn` BEFORE UPDATE ON `my_database`.`my_table` FOR EACH ROW BEGINset NEW.update_on = now(); END$$
DELIMITER ;
UPDATE_ON column in MySQL with trigger
Comment on UPDATE_ON column in MySQL with trigger
Auto File transfer/copying with SCP
Here is a
Here is a script (below) you can use to copy dump files between machines using scp from an
automated script. Please see attached. The script usage is as
follows:
./auto_scp.sh
local_file user@host:remote_folder
user_password
or
./auto_scp.sh
user@host:remote_file local_folder
user_password
Example:
./auto_scp.sh dump.dmp oracle@hostname:/U01/oracle
<oracle password>
and here is the script————————————————–
#!/usr/bin/expect -f
# connect via scpspawn scp “[lindex $argv 0]” “[lindex $argv 1]” #############################################expect {-re “.*es.*o.*” {exp_send “yes\r”exp_continue}-re…
Comment on Auto File transfer/copying with SCP
Exporting and Importing in Oracle: A Quick Start
I do this about twice per year and every time I have to look back at my notes to remember how. Maybe you are in the same boat. So, to save us both some trouble I’m going to blog my notes on the subject here.
exp schemaname/password@instance FILE=d:\mydump.dmp [follow instructions]
Give the file a name after FILE,…
1 Comment on Exporting and Importing in Oracle: A Quick Start
EPA Supports WATERS Geospatial data through OGC WMS/WFS Services
EPA appears to be using ESRI’s ArcIMS 9.2 OGC connectors to publish OGC WMS/WFS services of their WATERS data.
See below for threads
that mention the limitations and issues with working with these semi-standard
services from ESRI.
http://mailman-viper.python-hosting.com/pipermail/users/2006-July/000103.html
http://openlayers.org/pipermail/users/2007-May/001571.html
http://www.mail-archive.com/users@openlayers.org/msg04240.html
- Little thread that I started a while ago to check on support for pure ESRI
services.
Comment on EPA Supports WATERS Geospatial data through OGC WMS/WFS Services
When you need a sexy terrain relief map
If you’ve ever needed to make nice looking relief maps like I do now, have a look at these sites.http://www.reliefshading.com/ and http://www.shadedrelief.com/
I want to make something along the lines of Google’s terrain map, but with a client’s higher-resolution DEM data. I don’t if ESRI’s Spatial Analyst is going to get me quite where I want…
Comment on When you need a sexy terrain relief map
Good review of Mapnik for generating online maps
In my opinion you can’t beat UMN Mapserver or Mapnik for making gorgeous online maps. Mapserver has installed and run for me flawlessly every time I’ve tried it — without days of arguing with it. Mapnik has taken me nearly a week to get running sometimes. But, just like you wouldn’t want to shovel snow…
Comment on Good review of Mapnik for generating online maps
History of Rasters in PostGIS and a glimpse into the mechanics of an Open Source Project
I love this post thread so much I’m going to stick it into my blog. First because if you read into it and follow the links you can see the history of raster support in PostGIS (or reasons for lack thereof) for the PostGIS newbie readers. You can also see Paul’s encouragement and explanation of…
Comment on History of Rasters in PostGIS and a glimpse into the mechanics of an Open Source Project
GWT Charting Kit
Here is a nice GWT-based charting kit. It looks like it might be a reasonable replacement for a lot of we normally use JfreeChart for.
http://code.google.com/p/gchart/
Open Source County – Impressive Geospatial Portal
I keep having to fish around for this URL so I’m just going to blog into this online note space that I maintain. One stop shopping.
http://maps.co.mecklenburg.nc.us/gp/
This is the Mecklenburg County GIS data portal to both environmental and cadastral-type information. I ran across it some time ago as an avid reader of Tobin Bradley’s excellent blog…
Comment on Open Source County - Impressive Geospatial Portal
Putting your own content into a website with Google Maps
So I’m doing a little research tonight on some requirements for a client:
1. Embed a map in the client’s home page (non-database driven ASP.Net which is essentially HTML) that depicts the county’s watersheds and some number of additional layers2. Let users click each watershed polygon to trigger an event that leads to them learning more about…
Comment on Putting your own content into a website with Google Maps