LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ThomasT

Hi Guys.

I have this DBQuery that collects some data based on customer phone numbers.
Now I want to do this using the actual source files as input and use a DBExecute and do a sqlSelect instead.
I have followed instructions but I get the "SQL command not ended properly" no matter what I do.

Can anyone tell me what I am doing wrong?
I am attaching the graph(a bit simplified).

DBQuery vs DBExecute.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gmullin

Looks like you're using a library "DB Nodes" that you didn't attach.

Presuming you're using the Filter node to build up your where clause, you could make the entire query there like this:

emit "select * from my_table where Numb in (" + ZZ.str() + ")" as query

And then in DB Execute use: sqlSelect(1,query)

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ThomasT

Thanks Gerry.

I got it to work :-)

Thomas