11.4.11

Simple Search Form in Ruby - SQL error no such column name

So I ran into a problem that took me a ridiculously long time to figure out... In fact I didn't really figure it out myself... It took listening to my tutor read the code back to me, before the penny dropped what the problem was.   For ages I was getting the following error
SQLite3::SQLException: no such column: name: SELECT "events".* FROM "events" WHERE (name LIKE '%f%')

I checked the tutorial we'd been given, I checked all the examples I could find on the web and nothing helped I kept getting the same error.  Despite having this method in the model


def self.search(search_query)
    if search_query
      find(:all, :conditions => ['name LIKE ?', "%#{search_query}%"])
    else
      find(:all)
    end
  end


and this controller talking to it


def index
    @events = Event.search(params[:search_query])

    #respond_to do |format|
      #format.html # index.html.erb
      #format.xml  { render :xml => @events }
    #end
  end

However I really should have read the error message clearer as the clue was in the message.  It kept telling me that there was no such column name. and it was right. there was not such column name, my column was called title.  So I changed that one little word and everything is dandy again. Learnt a very valuable lesson though - Read the error messages carefully.

7.4.11

Validating Vimeo's embed against Strict!

I ran into a problem with the embed code that vimeo gives with their videos.  And although it validates against transitional I really wanted to validated it against strict.... so I came across this great site www.designlessbetter.com which gives a really simple alternative code to use.
Instead of using this ..

<object width="400" height="302">
 <param name="allowfullscreen" value="true" />
 <param name="allowscriptaccess" value="always" />
 <param name="movie" value="uri" />
 <embed src="uri" type="application/x-shockwave-flash"
allowfullscreen="true" allowscriptaccess="always" 
width="400" height="302"></embed>
</object>
You use this
<object width="400" height="302" type="application/x-shockwave-flash" data="uri">
 <param name="allowfullscreen" value="true" />
 <param name="allowscriptaccess" value="always" />
 <param name="movie" value="uri" />
</object>
He gives a really good explanation of the offending tag <embed>, 
breaks it down and comes up with a strict validating alternative.  Very grateful!

4.4.11

Difference between forums and blogs

For this blog project we have to comment and illicit responses - a fairly difficult task even for seasoned hacks.  So I thought I had a great workaround - the project is really about understanding Web 2.0 technologies and to my mind the same technologies are used to create forums as are blogs.  So posting some questions and getting responses on a forum would be a legitimate post : response and therefore fulfull the requirements of this assignment.  Wrong!!! A forum I am  informed is not a blog.  The differences being that a forum is made up of numerous contributors and the blog is just a single blog owner that facilitates comments from others.  But what about Blogs that have multiple authors?  Oh they still have editorial control over the content.  But what about forum that have moderators?  Do they not exercise editorial control over the forum?  Jeremiah Owyang at his blog gives a pretty good description of the differences.

 http://www.web-strategist.com/blog/2008/01/28/understanding-the-difference-between-forums-blogs-and-social-networks/

26.3.11

Destroy - Ruby Blog

I've followed all the instructions from http://guides.rubyonrails.org/getting_started.html and I've a blog set up, that has a form, allows a user to create a post, comment, edit, add tags, has some security to protect who can post,and edit, delete etc.  Only problem is that when I click delete post, I get the expected message "are you sure?" with the option to continue or to cancel.  However when I click cancel it goes ahead and deletes the comment anyway.  So I'm trying to find out how I can fix this. 

13.3.11

Scrum Mindmap

12.3.11

Ruby Rails and our Chapter Two assignment

I've got everything to work..... Rails is up and running, the server seems to be behaving himself, I've created two web pages that link to each other, and on one of the web pages I've embedded some ruby that does some nifty stuff like tell us what time it is now, list all the documents in a directory, do some simple calculations, tell us what time it will be from an hour from now, and it also adds some simple strings to-gether.  So happy days!  But along the way I've strayed a little from the instructions in the book.

11.3.11

Installing Rails..it was all going so well until...

I watched Wesley install a new Rails app and thought, Wow that doesn't look so hard.  I set about setting up my own application and it seemed to be going swimmingly despite a small sqlite3.dll missing glitch.  I soon rectified that by downloading the missing dll and putting it in the bin directory of my Ruby 192 application.