dbh:query(string.format("SELECT uuid FROM fifo_intercept ORDER BY time_id DESC LIMIT 1"), function(row)
fifo_uuid = row.uuid;
end);

Found it myself :)

On Mon, Apr 6, 2015 at 9:56 PM, Paul Atreides <paul.atreides83@googlemail.com> wrote:

Hi,

I am sorry I don't get it :/
How do I pull of a single value from this query:

"SELECT uuid FROM fifo_intercept ORDER BY time_id DESC LIMIT 1"

How can I save the result into the variable fifo_uuid with dbh:query?