search for: strquery

...if someone could please enlighten me on the rails way, or if there is a better way to do this. rgds, - matt. ----------------------------------------------------------- This is roughly how I''ve mangle rails as I would 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(" + eve...

Hi Everybody Is there a way in which one can use the RPostgreSQL package to take a sample from a table in Postgres database without having to read the whole table into R regards Christiaan [[alternative HTML version deleted]]