Displaying 1 result from an estimated 1 matches for "sql_and".
Did you mean:
sland
2006 Aug 07
2
Dynamically created queries
...ould have done it in PHP
event = Event.new(params[:event])
strQuery = ""
unless event.event_name.blank
strQuery = "UPPER(event_name) LIKE UPPER(" +
event.event_name.to_s + ") "
end
unless event.artist.blank
strQuery += sql_and(strQuery)
strQuery += "UPPER(artist) LIKE UPPER(" + event.artist.to_s + ")
"
end
unless event.city.blank
strQuery += sql_and(strQuery)
strQuery += "UPPER(city) LIKE UPPER(" + event.city.to_s + ") "
end
strQue...