Felix,
So glad to be of help.
Microsoft always seems to put square brackets around column and table
names so you'd see select * from [application].[dbo].[table] in their
database definition language extracts ('DDL')
So it was worth a try.
You have answered that single quotes work for you - so no need to try
the square brackets. (It is a database thing not a ruby thing)
Best of Luck
--Keenan
On Feb 24, 2009, at 3:57 PM, Felix Holmgren wrote:
> Hi Keenan,
>
> Also, the convention is to have underscores rather than camel case.
>
> This helped! Thank you very much. In the other class, where I let AR
> create the SELECT and used a the symbol representation of the field
> name (:firstPeer), AR apparently quoted the name correctly so that
> postgre understood it. Now I understand why AR always puts quotes
> around everything! So, in other words, this was not an AR error at
> all... :)
>
> Just goes to show that you should always rely on AR as much as
> possible.
>
> >What happens if you use the ? Notation?
> >
> >:conditions=["firstPeer = ? or secondPeer = ?",
> >@chatter.I'd,@chatter.id]
>
> Didn't try this, but it seems likely that that would have to be:
>
> :conditions=["'firstPeer' = ? ....
>
> (with extra quotes around firstPeer; can Ruby/Rails handle such
> quotes-inside-quotes by the way; needs to be escaped?)
>
> >Or use ["[firstPeer] = ? or [secondPeer] = ?]", ...
>
> What do these (inner) angular brackets do? Act as quotes?
>
> /F
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Heroku" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en
-~----------~----~----~----~------~----~------~--~---
