Using values from lUA in SQL lookup

[Trond Hoyem]

Hi

I am trying to make a script that sets the constant light control to manual mode if one is pressing a button (the function is not working properly in the PIR).

What I need to do is locate the room number and the address for the manual control. As I do not want to greate one script for each room in the buliding I am lookin for a shortcut. So far I am able to find addresses in the DB dependent on different criterias. Now my problem is that I need to get one value from the sending group address, I.E the room number, and then locate the appropriate address for setting the controller to manual mode.

so far I have this;

Code:

room = string.sub(grp.find(event.dst).name, 1, 4) --Identify the room


log(room) -- this returns the correct room number.
nyGA = db:getall('SELECT name FROM objects WHERE name LIKE "%..room..%" AND name LIKE "%set auto%"')
log(nyGA) -- this returns nil as no address contains the text 'room'

The problem is that the variable called room does not work in my SQL query. How can I insert the room number in the query?

Every group address for manual control is tagged with the same tag, and this should then all run in one script, if that is not to demanding on the processor....