syntax error on SQL statement

[laredotornado]

Hi,

I'm using the latest version of Ruby for Fedora Core 6 Linux. I want
to write concise SQL statements, but the following

@subscriber = Subscriber.findfirst, :conditions => "pharmacy_id
= ?", @pharmacy_id)

is giving me the error:

SyntaxError
/usr/local/apache2/htdocs/easyrx/app/controllers/
register_controller.rb:44: syntax error, unexpected ')', expecting
tASSOC
@subscriber = Subscriber.findfirst, :conditions => "pharmacy_id
= ?", @pharmacy_id)


What's the correct way to write the statement?

Thanks, - Dave

 

[Frederick Cheung]

Hi,

I'm using the latest version of Ruby for Fedora Core 6 Linux. I want
to write concise SQL statements, but the following

@subscriber = Subscriber.findfirst, :conditions => "pharmacy_id
= ?", @pharmacy_id)

@subscriber = Subscriber.findfirst, :conditions => ["pharmacy_id
= ?", @pharmacy_id])
Fred
is giving me the error:

SyntaxError
/usr/local/apache2/htdocs/easyrx/app/controllers/
register_controller.rb:44: syntax error, unexpected ')', expecting
tASSOC
@subscriber = Subscriber.findfirst, :conditions => "pharmacy_id
= ?", @pharmacy_id)


What's the correct way to write the statement?

Thanks, - Dave