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.
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.