What is your query ?

Guys, could you provide full information, like:
1. detailed use case
2. thrown exception if any.
3. test case or sample db if needed or possible.

Otherwise we spend time on discovering details instead of problem solving
:-) .


On Thu, Mar 6, 2014 at 1:10 PM, Shishya <[email protected]> wrote:

> Hi,
>
> Is union there in v1.7rc2SS. I m getting this error
>
>  No function for name union, available names are :
> [asdate,ifnull,both,last,count ,distinct ,substring,
> avg,right,dijkstra,encode,append,coalesce,eval,ine,label,format,asdatetime,include,difference,asdecimal,decode,sysdate,intersect,inv,
> outv,multivalue,charat,set,sum,convert,bothv,SWITCH,date,shortestpath,document,distance,if,gremlin,length,map,left,bothe,min,GY2,max,list,exclude,tojson,in,SEARCH1,replace,
> unionall ,oute,first,out]
>
>
>
> On Thursday, July 26, 2012 5:43:22 PM UTC+5:30, Lvc@ wrote:
>
>> Hi,
>> you're right: a replace() is missing. Just created in SVN r6249. I've not
>> tested yet behind a function like UNION:
>>
>> SELECT union(format("&lt;td&gt;%s&lt;&#47;td&lt;td&gt;%s&lt;&#47;td",
>> Name, Surname)).replace(",", " ") AS Tabella FROM Studente
>>
>> Can you try it?
>>
>> Lvc@
>>
>> On 26 July 2012 13:48, Fabrizio <[email protected]> wrote:
>>
>>>
>>> I need to have
>>> 1) more fields of each row into a single field,
>>> 2) then a single field to collect all rows.
>>>
>>> For example
>>>
>>> | Name | Surname |                    |     Field  1 |
>>> |               Field  2                   |
>>> | AAA    |    BBB   |                    | AAA BBB |                |AAA
>>> BBB CCC DDD EEE FFF|
>>> | CCC    |    DDD   |     ---->  1)    | CCC DDD |  ----> 2)
>>> | EEE    |    FFF    |                    | EEE FFF |
>>>
>>> In my query I get this but with commas (AAA BBB, CCC DDD, EEE FFF).
>>>
>>> Fabrizio
>>>
>>> --
>>>
>>>
>>>
>>>
>>
>>  --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "OrientDB" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Best regards,
Andrey Lomakin.

Orient Technologies
the Company behind OrientDB

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to