16.09.2019, 13:31
Hi
I am again struggeling with the SQL lookup...
What I need is to create a table with all objects within a certain address range. I am already able to calculate the start and stop ID from the address table, but when I try to look it up with the SQL, I am not as successful.
The code I am using is;
The log gives an empty table.
Any hints as to what I am doing wrong?
I am again struggeling with the SQL lookup...
What I need is to create a table with all objects within a certain address range. I am already able to calculate the start and stop ID from the address table, but when I try to look it up with the SQL, I am not as successful.
The code I am using is;
Code:
adresser = db:getall('SELECT ID FROM objects WHERE ID >= "%' .. startID .. '%" AND ID <= "%' .. stopID .. '%"')
log(adresser)The log gives an empty table.
Any hints as to what I am doing wrong?
There are 10 kinds of people in the world; those who can read binary and those who don't 