Rails - Jul 2008 - syntax error, unexpected ')'

Hi,

I tried the sample program for AJAX from the following site.

http://www.theregister.co.uk/2007/01/15/ajax_rails_tutorial/

I created a table called catalogs and set the values.

I tried to load the data while entering the title of the book in the
text field,
I am getting the error messages

====SyntaxError in CatalogController#get_article_list
D:/ruby/Projects/catalog/app/models/catalog.rb:14: syntax error,
unexpected '')''
====
I tried to identify the cause of the error.
I colundn''t

This is the controller
======================class CatalogController < ApplicationController

def index
end

def get_article_list
 @section=request.raw_post

  @catalogList="<ol>"

Catalog.find_by_sql( "SELECT * from catalogs WHERE title
''"+@section+"''" ).each do|catalog|
@catalogList+="<li><a
href=\""+catalog.url+"\">" +catalog.title+
"</a></li>"

   end

  @catalogList+="</ol>"


render :text => @catalogList

    end
end
==============================================================================
This is model
=============require ''rubygems''
require ''active_record''

class Catalog < ActiveRecord::Base
set_table_name "catalogs"
end

ActiveRecord::Base.establish_connection(
  :adapter  => "mysql",
  :host     => "localhost",
:database => "mydatabase",
  :username => "root",
  :password =>
)
==============================================================================
Please help me to figure out the reason for the error and give your
valuable suggestions.

Thanks in advance.
Ravi
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Thorsten Mueller wrote:
> this line
> 
> ActiveRecord::Base.establish_connection(
>   :adapter  => "mysql",
>   :host     => "localhost",
> :database => "mydatabase",
>   :username => "root",
>   :password =>
> )
> 
> should have some value for the :password thing.
> either use
> :password => nil
> or
> :password => ""
Hi,
After I changed the above modification in the model,
I am getting the following error.

Access denied for user ''root''@''localhost''
(using password: NO)


This is my database.yml content

development:
  adapter: mysql
  encoding: utf8
  database: mydatabase
  username: root
  password: password
  host: localhost

The password also set as ''password'' for the database,
eventhough i gave the password I couldn''t get the out put.
what changes shoule be made.

Thanks in advance,
Ravi
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

srinivas reddy wrote:
> Hi,
> Just check this..
> ActiveRecord::Base.establish_connection(
>   :adapter => "mysql",
>   :host => "localhost",
>  :database => "mydatabase",
>   :username => "root",
>   :password => "";
>  )
> 
> I hope this will work.
Hi,
I tried with the above changes...
still I am having the problem...

herewith I attached the application codes
I am using.

Please any one help me out this..


Thanks in Advance,
Ravi

Attachments:
http://www.ruby-forum.com/attachment/2432/catalog.zip

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---