|
What SQL are you using? MS-SQL? MySQL? PostgreSQL?
Really, you only need one call in the WHERE statement, so it should not fail becuase there is no IP. The WHERE clause doesn't even need to be unique, as it will just make those updates to all lines where the clause is true.
Honestly I don't udnerstand exactly what you want to do. What I understand is:
lan_node_def.lan_node_seq is a unique key (assumption)? And there is an IP address associated with it, but it's ALWAYS the same address? Perhaps I'm wrong, that's just how it sounded. Also, is micros the db name or a table name? It seems that micros is the db, lan_node_def and dev_def are tables and everything else is a column?
At any rate, with some more info, I believe I can help you.
__________________
The prospect of achieving a peace agreement with the extremist group of MILF is almost impossible...
-- Emmanuel Pinol, Governor of Cotobato
My Homepage
|