davidmoten / davidmoten/rxjava2-jdbc
Same NamedParameters used multiple times
- Dominant language
- Java
- Stars
- 394
- Forks
- 41
- Avg merge
- 2m
- Merged PRs (30d)
- 1
Description
MySQL
```
String query = "SELECT * FROM table
WHERE ST_CONTAINS(GEOMFROMTEXT('POLYGON((:neLon :neLat, :neLon :swLat, :swLon :swLat, :swLon :neLat,:neLon :neLat))'), point)"
return database
.select(query)
.parameter("swLon", swLon)
.parameter("swLat", swLat)
.parameter("neLon", neLon)
.parameter("neLat", neLat)
.get(new Mapper())
```
This won't work but when I hardcode the lat's and lng's it works fine. Are we not allowed to use named parameters in multiple places and assign value only once?
Thank you very much for all your help!
Kind Regards,
Vini
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.