class CreateMailrTables < ActiveRecord::Migration

  def self.up

    create_table :users do |t|

  City Load (2.637009)   SELECT *, (ACOS(COS(-0.399680398706701)*COS(-0.754564012697105)*COS(RADIANS(cities.lat))*COS(RADIANS(cities.lng))+
 COS(-0.399680398706701)*SIN(-0.754564012697105)*COS(RADIANS(cities.lat))*SIN(RADIANS(cities.lng))+
 SIN(-0.399680398706701)*SIN(RADIANS(cities.lat)))*3963.19)
 AS distance FROM cities WHERE (cities.lat>-30.1284926426796 AND cities.lat<-15.6715073573204 AND cities.lng>-51.0728873255754 AND cities.lng<-35.3937792744246 AND (ACOS(COS(-0.399680398706701)*COS(-0.754564012697105)*COS(RADIANS(cities.lat))*COS(RADIANS(cities.lng))+
 COS(-0.399680398706701)*SIN(-0.754564012697105)*COS(RADIANS(cities.lat))*SIN(RADIANS(cities.lng))+

                $$(.ajaxme).each(function(element){
                   element.addEvent('click', function(el) {
                        new Event(el).stop();
                        var url = el.getProperty('href')
                        var target = $(el.getProperty('rel'))

# <h1>Find an Expert</h1>
# <div id="category_select">
# <%= label('business_category','Main Category')%><br>
# <%= collection_select(:business, :category_id, @cats, :id, :title, {:prompt => 'Select a parent category...'}) %><br><br>
#

window.addEvent('domready', function(){            

   $('business_category_id').addEvent('change', function(){
        var action = "/find/show_subcategories"     
        var target = $('select2')

function getcount(){

       $$('map area').each(function(el){
         new Tip(el, el.alt);
         var count = el.readAttribute('alt')

Event.observe(window, 'load', function() {
       $$('map area').each(function(el){
         var count = el.getProperty('alt')
       Event.observe(el, 'mouseover', function(){
         $('countbox').empty().innerHTML(count)

this ungodly mess returns:

city,city_ascii,lat,lng,country_id,region_id 

It's a one-off query, I need to generate csv file for 2.5 million records so I can import into the db with foreign keys.

class AssetsController < ApplicationController

layout proc{ |c| c.request.xhr? ? false : "assets" }  

# ^ loose layout if page is requested using Ajax. 

class Buyer < ActiveRecord::Base
  has_many :leads
  has_many :zips, :through => :leads

class Zip < ActiveRecord::Base

  def events
    now = Time.now
    nextweek = 1.week.from_now
    secondweek = 2.weeks.from_now
    nextmonth = 4.weeks.from_now

def send_question
  gnupg = GnuPG.new :recipient=>"email@hotel.com"
  gnupg.load_public_key File.read("/path/to/public/key.asc")

adds ajax to all forms on a page within a div with 'jaxy' class name.

Form class name is the update target.

window.addEvent('domready', function(){

helper:

  def tab(this)
    if this == @tab
      "hot"

error: "element.getProperty('action')" is not a function....

window.addEvent('domready', function(){
        var destroy = $$('#homeSpecs form');
        destroy.each(function(element){