include/idquery.rb in baza-0.0.16 vs include/idquery.rb in baza-0.0.17
- old
+ new
@@ -85,16 +85,10 @@
if ids.empty?
destroy
return nil
end
- ids_sql = Knj::ArrayExt.join(
- :arr => ids,
- :callback => proc{|val| @args[:db].esc(val)},
- :sep => ",",
- :surr => "'"
- )
-
+ ids_sql = ids.map { |id| "'#{@args[:db].esc(id)}'" }.join(',')
query_str = "SELECT * FROM #{table_esc} WHERE #{table_esc}.#{col_esc} IN (#{ids_sql})"
print "Query: #{query_str}\n" if @debug
return @args[:db].q(query_str)
end
\ No newline at end of file