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.

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

Documentation: More variable examples #257

Open
mlibbey opened this issue Dec 11, 2022 · 0 comments
Open

Documentation: More variable examples #257

mlibbey opened this issue Dec 11, 2022 · 0 comments

Comments

@mlibbey
Copy link

mlibbey commented Dec 11, 2022

I've been trying to figure out how to use a variable when quoting is needed for instance, if the query has something like
where date >= ('2022-12-01')
and I set a variable start to be 2022-12-01
and tried things like
where date >= ($start)
where date >= ('$start')
where date >= ("$start")
where date >= ('$start')
where date >= ('$start')

Eventually realized that the variable should have the quoting inside it: start '2022-12-01'

Guess my suggestion would be on
https://tabix.io/doc/Tips/#variables
to say
If you want your variable to be inside quotes in the query, please include the quotes in the variable. For instance,
setting the start variable to '2022-12-01' and using it in the query like
where date >= ($start)
will result in where date >= ('2022-12-01') being sent to the server.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant