Subject | something like GROUP_CONCAT ? |
---|---|
Author | peter_nn0 |
Post date | 2006-05-15T10:29:09Z |
Hi,
I'm still a FB newbie, wonder if in FB (1.5.2.x) there is something
similar in functionality to mySQL's GROUP_CONCAT ?
What I want is to create a string with delimited values from the
result of a query. For example if I have a table with two Integer
columns like this:
----
orderID workerID
100 8
101 15
100 10
----
,I want to retrieve all workerID's that match given orderID as a
string.
Here the result for orderID 100 should be a string "8,10" or "10,8" -
the order doesn't matter.
Can this be done in a simple way without loops, casting etc.?
Thanks
I'm still a FB newbie, wonder if in FB (1.5.2.x) there is something
similar in functionality to mySQL's GROUP_CONCAT ?
What I want is to create a string with delimited values from the
result of a query. For example if I have a table with two Integer
columns like this:
----
orderID workerID
100 8
101 15
100 10
----
,I want to retrieve all workerID's that match given orderID as a
string.
Here the result for orderID 100 should be a string "8,10" or "10,8" -
the order doesn't matter.
Can this be done in a simple way without loops, casting etc.?
Thanks