On Martes, 1 de Junio de 2010 18:49:29 Iñaki Baz Castillo escribió:
> Hi, client has many :locations using 'username' column. Both tables
> are case insensitive for string fields (application requeriment).
>
> Imagine a client with username=TEST and a location entry with
> username=test. When AS retrieves the locations of the user it gives a
> "nil.each"
> error. It occurs becase the SQL query does the job:
>
>   SELECT `location`.* FROM `location` WHERE (`location`.username IN
> ('TEST'))
>
> But later when AS tries to retrieve location information for such
> client it gives the "nil.error" error. I think it occurs because it
> tries to find a Location entry with username=TEST using Ruby string
> match (case sensitive) so it finds nothing (but it expected to find
> something as the SQL query gave an entry).
>
> Perhaps AS should take into account case insensitive columns so later
> it does a case insensiteive search based on such column?
>
> Regards.

Are you talking about ActiveScaffold searching or rails associations?

-- 
Sergio Cambra .:: entreCables S.L. ::.
Mariana Pineda 23, 50.018 Zaragoza
T) 902 021 404 F) 976 52 98 07 E) [email protected]

-- 
You received this message because you are subscribed to the Google Groups 
"ActiveScaffold : Ruby on Rails plugin" 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/activescaffold?hl=en.

Reply via email to