Streamlit Range without a Slider

Using Streamlit
1

Is there a way to select a range of values say between 100 and 1000 in streamlit and get a SQL like statement of BETWEEN 100 and 1000?

2

Sure, just use fstring.

Eg. Sqlstr = f"SELECT * FROM Products
WHERE Price BETWEEN {x} AND {y}"

x & y = widget variables

Cheers

3

Hi @Shawn_Pereira ,
And this widgets will be say number input or text input? I am trying to create interactive SQL Query Dashboard.

4

This has to be a number input, as you want to use it with BETWEEN

OR

if it is a text input, you will have to change / convert it to a number before you can use it.

Cheers

5

Okay @Shawn_Pereira . Thanks for the answer.

6

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.