Passing a variable to a sql statement 1

[MrE4U]

I am trying to pass a variable to sql statement instead of a value.

This works

set result [db1 eval {SELECT * FROM phone_book WHERE id=1} ]

but this does not

set tst 1
set result [db1 eval {SELECT * FROM phone_book WHERE id=$tst} ]

Does anyone know how to fix this?

Thanks

 

[ddrillich]

Let's try:

set tst 1
set result [db1 eval "SELECT * FROM phone_book WHERE id=$tst" ]

Regards,
Dan