Testing Result of raw sql query

Rails
1

I need to be able to catch when my postgresql database returns no rows
in a raw sql query.
In this case it would be an error indicating that the long and lat are
outside of the
shape file.

s = Boundary.find_by_sql(“SELECT name, country, stateabb FROM
boundaries WHERE distance( the_geom,‘POINT(#{@lon} #{@lat})’) = 0”)

testing with s.nil! does not seem to solve the problem

Any ideas?

Here are two queries one without a record and one with

SELECT name, country, stateabb FROM boundaries WHERE

distance( the_geom,‘POINT(-89.0 0.0)’) = 0;
name | country | stateabb
------±--------±---------
(0 rows)

SELECT name, country, stateabb FROM boundaries WHERE

distance( the_geom,‘POINT(-89.0 43.0)’) = 0;
name | country | stateabb
-----------±--------±---------
Wisconsin | USA | US-WI
(1 row)

2

On May 3, 2007, at 7:43 PM, Pete wrote:

testing with s.nil! does not seem to solve the problem

s.empty? ?

-faisal

3

I would recommend to trace log/development.log to check the actual SQL
statement being executed by Rails.