25 Mar 09 Useful MySQL Stuff">Useful MySQL Stuff
Select rows from table A that do not exist in table B
select from A where id not in (select id from B)
25 Feb 09 How to: install php zip on mac osx leopard">How to: install php zip on mac osx leopard
$sudo pecl install zip
that’s all
18 Feb 09 How to: Install Memcached on Ubuntu for Rails">How to: Install Memcached on Ubuntu for Rails
sudo aptitude install memcached
sudo aptitude install libmemcache-dev
sudo gem install RubyInline
sudo gem install memcache-client
in application.rb
Uncomment the protect_from_forgery
in environment.rb
CACHE = MemCache.new ‘localhost:11211′, :namespace => ‘your_app’
config.action_controller.session = {
:session_key => ‘_your_app_session’,
:secret => ‘yoursecrectkey’,
:cache => CACHE,
:expires=>900 }
config.action_controller.session_store = :mem_cache_store
31 Jan 09 Set mysql default charset to utf8">Set mysql default charset to utf8
in the /etc/my.cnf file add
[mysqld]
#
# * Basic Settings
#
# utf8
init-connect=’SET NAMES utf8′
character-set-server=utf8
collation-server=utf8_general_ci
default-collation=utf8_general_ci
25 Dec 08 Attach images in rails">Attach images in rails
View the railscast on using thoughtbot’s paperclip
http://railscasts.com/episodes/134-paperclip
or
attach multiple images to a model using polymorphic paperclip
http://burm.net/2008/10/17/ruby-on-rails-polymorphic-paperclip-plugin-tutorial/
Tags: Rails
15 Dec 08 Learning how to use Shoulda">Learning how to use Shoulda
View the conf video to find out what Shoulda is
http://mwrc2008.confreaks.com/12saleh.html
Shoulda Walkthrough
http://technicalpickles.com/posts/a-walk-through-of-test-driven-development-with-shoulda
Read the thoughtbot tutorials
http://thoughtbot.com/projects/shoulda/tutorial
08 Dec 08 Rails export to excel spreadsheet">Rails export to excel spreadsheet
sudo gem install spreadsheet
more help:
http://codeclimber.blogspot.com/2008/11/reporting-in-excel-with-rails.html
http://spreadsheet.rubyforge.org/
To send and save through browser
Taken from https://rubyforge.org/forum/forum.php?thread_id=29606&forum_id=2920
require ’stringio’
data = StringIO.new ”
book.write data
send_data data.string, :type=>”application/excel”, :disposition=>’attachment’, :filename => ‘MeaningfulName.xls’
04 Dec 08 Send email in rails">Send email in rails
http://railscasts.com/episodes/61
04 Dec 08 Rails sending email Net::SMTPFatalError">Rails sending email Net::SMTPFatalError
From: http://readlist.com/lists/lists.rubyonrails.org/rails/3/15740.html
Configuring local_recipient_maps in main.cf
The local_recipient_maps parameter specifies lookup tables with all
names or addresses of local recipients. A recipient address is local
when its domain matches $mydestination, $inet_interfaces or
$proxy_interfaces. If a local username or address is not listed in
$local_recipient_maps, then the Postfix SMTP server will reject the
address with “User unknown in local recipient table”.
The default setting, shown below, assumes that you use the default
Postfix local(8) delivery agent for local delivery, where recipients
are either UNIX accounts or local aliases:
/etc/postfix/main.cf:
local_recipient_maps = proxy:unix:passwd.byname $alias_maps
To turn off unknown local recipient rejects by the SMTP server, specify:
/etc/postfix/main.cf:
local_recipient_maps =
That is, an empty value. With this setting, the Postfix SMTP server
will not reject mail with “User unknown in local recipient table”.
Tags: Rails
03 Dec 08 Sharepoint 2007 Unknown Error when deleting list columns">Sharepoint 2007 Unknown Error when deleting list columns
Did you customize your application master pages and get this error while trying to delete list columns?
Unable to validate data. at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength)
at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)
Ok that probably means you have a search box in the template which is messing things up, just remove it or hide it, and that will do the trick!
Tags: sharepoint
