I want to execute a query using the query database smart service, which looks li

moritzw over 11 years ago

I want to execute a query using the query database smart service, which looks like this: delete from table_name where id in (123,345,etc.). The Id is of type integer. If I try to use an array variable it throws an error. Any ideas on how I could achieve this other than using MNI? Thanks!...

Discussion posts and replies are publicly visible

Parents

0 livior over 11 years ago

I used a different query for this:

SELECT `id`, `field` FROM `table`
WHERE INSTR(ac!idList_txt, concat('|', CAST(id AS CHAR), '|')) > 0

with idList_txt set to "|"&joinarray(idList_int, "|")&"|"

as it misbehaved using the suggested query, especially for a single ID in the list idList_int.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 livior over 11 years ago

I used a different query for this:

SELECT `id`, `field` FROM `table`
WHERE INSTR(ac!idList_txt, concat('|', CAST(id AS CHAR), '|')) > 0

with idList_txt set to "|"&joinarray(idList_int, "|")&"|"

as it misbehaved using the suggested query, especially for a single ID in the list idList_int.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data