davidmoten / davidmoten/rxjava2-jdbc

Same NamedParameters used multiple times

Open
#19 2 comments 0 reactions 0 assignees View on GitHub
question
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.