Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Named parameters docs should include an example of a cast #1496

Closed
simonw opened this issue Oct 22, 2021 · 1 comment
Closed

Named parameters docs should include an example of a cast #1496

simonw opened this issue Oct 22, 2021 · 1 comment
Labels
documentation

Comments

@simonw
Copy link
Owner

simonw commented Oct 22, 2021

https://docs.datasette.io/en/stable/sql_queries.html#named-parameters

It's not obvious that the values from parameters are always SQLite strings, which means that you can't do e.g. integer comparisons on them without casting them first. The documentation here should include an example of this.
@simonw simonw closed this as completed in 15a9d4a Oct 22, 2021
@simonw
Copy link
Owner Author

simonw commented Oct 22, 2021

https://docs.datasette.io/en/latest/sql_queries.html#named-parameters

simonw added a commit that referenced this issue Oct 24, 2021
@simonw
Docs on named parameters with cast as real/integer, closes #1496
52a88d0
simonw added a commit that referenced this issue Oct 24, 2021
@simonw
Release 0.59.1
e6e4437 
Refs #1482, #1496
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
documentation
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@simonw