Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sql = 'SELECT ctr.id, ctr.code as country_code, ctr.name as country_name, c.id, c.country_id,
- c.code as city_code, c.name as city_name, a.code as airport_code, a.name as airport_name, a.city_id
- FROM countries AS ctr INNER JOIN cities AS c INNER JOIN airports AS a
- WHERE ctr.id = c.country_id AND a.city_id = c.id AND (ctr.name = ? OR ctr.code = ? OR c.name = ? OR c.code = ? OR a.code = ? OR a.name = ?)'
- sql = ActiveRecord::Base.send(:sanitize_sql_array, [sql, name.upcase, name, name.upcase, name, name.upcase, name])
- result_hash = ActiveRecord::Base.connection.execute(sql)
- ## Old sql query (same error)
- sql = 'SELECT ctr.id, ctr.code as country_code, ctr.name as country_name, c.id, c.country_id,
- c.code as city_code, c.name as city_name, a.code as airport_code, a.name as airport_name, a.city_id
- FROM countries AS ctr INNER JOIN cities AS c INNER JOIN airports AS a
- ON ctr.id = c.country_id AND a.city_id = c.id
- WHERE ctr.name = ? OR ctr.code = ? OR c.name = ? OR c.code = ? OR a.code = ? OR a.name = ?'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement