Advertisement
Guest User

Untitled

a guest
Jul 24th, 2019
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. proc qry(db: DbConn; lon, lat: float) =
  2. var
  3. arow = db.getRow(sql"""select hwy, fdfo, tdfo, geom from routes order by geom <-> ST_GeomFromText('POINT(? ?)', 4326) limit 1""", lon, lat)
  4. echo arow
  5.  
  6. proc main() =
  7. let db = open("localhost", "grassy", "", "onsys")
  8. db.qry(-97.398444, 33.03654)
  9. db.close()
  10.  
  11.  
  12.  
  13. grassy@localhost:~/www$ ./post
  14. db_postgres.nim(85) dbError
  15. Error: unhandled exception: ERROR: syntax error at or near "' '"
  16. LINE 1: ...der by geom <-> ST_GeomFromText('POINT('-97.398444' '33.0365...
  17. ^
  18. [DbError]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement