Syntax error, unexpected ')'

Hi,

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

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="

    "

    Catalog.find_by_sql( “SELECT * from catalogs WHERE title =
    '”[email protected]+"’" ).each do|catalog|
    @catalogList+="

  1. <a href=""+catalog.url+"">" +catalog.title+
  2. end

    @catalogList+="

"

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

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 => “”

Thorsten M. 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

Hi,
Just check this…
ActiveRecord::Base.establish_connection(
:adapter => “mysql”,
:host => “localhost”,
:database => “mydatabase”,
:username => “root”,
:password => “”;
)

I hope this will work.

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

On Jul 22, 5:44 am, Ravikumar P. <rails-mailing-l…@andreas-
s.net> wrote:

I hope this will work.

Hi,
I tried with the above changes…
still I am having the problem…

Get rid of that semicolon. Putting the mysql connection stuff in the
model class is a bit odd.

Fred

On Jul 21, 1:05 pm, Ravikumar P. <rails-mailing-l…@andreas-
s.net> wrote:

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

You’re not using database.yml because for some reason you’re
establishing the connection by hand in catalog.rb. If you’re going to
go that route then the call to establish_connection must contain valid
credentials (check them in another mysql client first)

Fred

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs