> 
> clientapp= ActiveRecord::Base.connection.execute("SELECT 
> `sdm_users`.`loginid`,`sdm_users`.id,`sdm_users`.`email`,`api_groups`.`name`,`api_groups`.`is_autokey_generate`,`api_groups`.`id`
>  FROM `sdm_users`,`api_groups` WHERE `sdm_users`.`loginid` ='#{loginid}' && 
> `sdm_users`.`status` = true && `api_groups`.`name` IN ('#{apigroup_name}')")
> 
> it is not working can anybody help me
Your in clause needs to look like in ('value1', 'value2')
But why use such a low level api when you could use something much nicer?

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

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

Reply via email to