Text widget with numbers

General
1

I am using this code and entering digits or characters prints correctly
text = widgets.Text()
display(text)
def handle_submit(sender) :
print(text.value)
text.on_submit(handle_submit)
If I replace the print command with an sql command and use this function as variable and entering characters or digits in this prompt I always get a similar
The numeric literal “0x7f5685785560” is not valid
is there a way to force this input field to be handled as characters/digits
thanks for all update
best regards, Guy

2

It sounds like the problem is probably in how you are constructing your sql. The text.value is always a string.

3

I did some additional tests and in the sql I have to explicitely/cast the result from the widget result
similar to char(widget_result) and this corrected my problem…
best regards, Guy