Valentina website and mantis down? -- live now as I see

[Bart Pietercil]

Since your subject is already pointing to Mantis ;-) please submit to Mantis the query that did not work and produced an end of file.
It looks like using a function with HAVING  goes bezerk when the query where the having clause is found is a sub- or subsub-query
At least Valentina should throw a more descriptive error.

tia,


Bart Pietercil
CTO Cognosis NV



On 20 Jun 2010, at 14:32, william humphrey wrote:

> Tried this:
> 
> UPDATE data_address SET d_address_LineNumber = 2 WHERE
> d_address_LineNumber IN (select d_address_LineNumber from
> (select d_address_LineNumber, d_address_clients_ref, count
> (d_address_clients_ref) as SomeName
> from data_address
> group by d_address_LineNumber,d_address_clients_ref
> having SomeName > 1)
> ))
> 
> got Kernel error: 0X7100, line 7:2 unexpected token: )
> 
> So did this:
> 
> 
> UPDATE data_address SET d_address_LineNumber = 2 WHERE
> d_address_LineNumber IN (select d_address_LineNumber from
> (select d_address_LineNumber, d_address_clients_ref, count
> (d_address_clients_ref) as SomeName
> from data_address
> group by d_address_LineNumber,d_address_clients_ref
> having SomeName > 1)
> )
> 
> and viola!  It worked!
> 
> Thanks a whole bunch.
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina