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

[william humphrey]

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.