Active Record looks interest. I'll need to look into that. Thanks!

In other news, this question made it to the top of Google's search
results. . . and I just noticed that I mis-spelled "code". :|

On Wed, May 20, 2009 at 2:55 PM, Phlip <phlip2005 / gmail.com> wrote:
> rilindo foster wrote:
>>
>> Is there a correct style of putting in SQL statements in Ruby? My SQL
>> statements tend to go around 200-400 columns, which looks *very* ugly.
>
> A> use ActiveRecord, or one of the other SQL generators
>
> B> this:
>
>   > WHERE is_premier = 1
> AND charge_at > NOW()
>
> Notice that all SQL keywords are in UPCASE, just for emphasis, and there's a
> vertical gutter in the 6th relative column. The SQL books advocate that
> gutter, I think.
>
> Also, if you have 200-400 column strings, you need to get more DRY. That
> leads back to ActiveRecord...
>
>



-- 
Rilindo Foster
AOL Instant Messenger: rilindo
Google Talk: rilindo / gmail.com
Web Site: http://www.monzell.com
Primary: rilindo / me.com
Secondary: rilindo / gmail.com
"Rich bachelors should be heavily taxed. It is not fair that some men
should be happier than others. -- Oscar Wilde