This topic needs a title

rubyonrails-talk
1

Hi all,

with following fields

apigroup_name=production ------> (single table)

loginid=43

email=test@test.com

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= (‘#{apigroup_name}’)”)





By the above query i can retrieve all fields from db,



What i want to do now is to
apigroup_name=["production","marketing"] ------> (multiple table)

loginid=43

email=test@test.com

want to retrieve all the fields from db,

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

2 



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