From: Anukul Singhal <anukul.singhal@...>
Date: 2008-05-09T00:55:33+09:00
Subject: Re: Writing a SQL Query in Active Record?

Phillip Gawlowski wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Anukul Singhal wrote:
> | Hi,
> |
> | I am using the following code snippet for connecting to SQL Server
> | through Active Record:
> |
> | require 'rubygems'
> | require 'active_record'
> |
> | ActiveRecord::Base.establish_connection(
> | :adapter => "sqlserver",
> | :host => "xxx.xxx.xxx.xxx,8080"
> | :username => "username"
> | :password => "password"
> | :database => "xyz_1008"
> | )
> |
> | Now, I want to execute a query in this sql server after getting
> | successfully connected but am not aware how to do so. Can anyone give an
> | example as to how we write the query say ("Select * from Name") after
> | establishing the above connection successfully?
> 
> ar.rubyonrails.com
> 
> Look for #find, or #find_by_sql.
> 
> - --
> Phillip Gawlowski
> Twitter: twitter.com/cynicalryan
> Blog: http://justarubyist.blogspot.com
> 
> You write with ease to show your breeding,
> But easy writing 's curst hard reading.
> ~ -- Richard Brinsley Sheridan (1751-1816)
> ~ -- Clio's Protest, Life of Sheridan (Moore), Vol. i, p. 155
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.8 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iEYEARECAAYFAkgjHOcACgkQbtAgaoJTgL9k8QCdHTVwPREoYlByjns1t1Sr9NOY
> eYYAmgJ5A9zOn9ZrX8KgAUXwSz6oLORz
> =KK/C
> -----END PGP SIGNATURE-----

Hi,

Thanks for the reply.

I am not using rails. Want to run the query only using Active Record on 
Ruby (Scite Editor)

Can you give any prototype as to how I can proceed writing a simple 
"SELECT" query after establishing the connection with the sql server db?

Thanks,
Anukul
-- 
Posted via http://www.ruby-forum.com/.