On Thu, 13 Jan 2005 11:42:56 +1100, M@ Bourke
<[EMAIL PROTECTED]> wrote:
|Ned | data_1 |
John 12
Mark 34
John 76
Instead of copying over John, 12
It will copy over "John 1276"
Does it matter which value of data_1 you give John? If it doesn't, then:-
insert into name_entry (ned_id,value,data_descriptor_id)
select distinct on (ned_id)
ned_id, data_1, 3
from nameentry
where layoutid in (285,286)
and data_1 <> ''
and data_1 is not null ;
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
