Hi, i have a question, I need compare the id value of table with a number variable, is this possible? how do it?
COMPARE ID VALUE
Jan 29 2019 02:27 PM
[[DELETE * FROM tabla WHERE id=]] .. value
[[ and ]] are just a type of quote around the SQL query string.
.. is the string concatenation operator
assuming value is a number and your SQL id field is a number, that will work. If id is a string, you would need some additional quotes like this:
[[DELETE * FROM tabla WHERE id="]] .. value .. [["]]