[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
SQL Update Query - set attribute value to that of another attribute  XML
Forum Index » General Discussion
Author Message
defac



Joined: 21/10/2008 08:21:24
Messages: 1
Offline

I'm trying to perform an update on a large number of records involving setting an attribute to the value contained in another attribute - something along the lines of (conceptually):

update xxxxxx set attribute1=attribute2 where attribute1 is null

Is this possible? Any advice would be greatly appreciated.

Thanks!
support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

Current version only supports simple sql statements, no joins.
So you can't do it with sql.

The other option is the LDIF export and import.

 
Forum Index » General Discussion
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.9 © JForum Team