Project

General

Profile

« Previous | Next » 

Revision 7305

Added by ben leinfelder over 12 years ago

make sure we only get the publisher text content (not attribute value)

View differences:

src/doi_registration.sql
77 77 
and nodes.nodeid = child.parentnodeid
78 78 
and nodes.parentnodeid = parent.nodeid
79 79 
and nodes.nodename = 'publisher'
80 
and parent.nodename = 'dataset';
80 
and parent.nodename = 'dataset'
81 
and child.nodetype = 'TEXT';
81 82 

  		




  82
  83
  
    
-- update organization using nodes


  		




  83
  84
  
    
update doi_registration doi


  		




  ......




  174
  175
  
    
and nodes.nodeid = child.parentnodeid


  		




  175
  176
  
    
and nodes.parentnodeid = parent.nodeid


  		




  176
  177
  
    
and nodes.nodename = 'publisher'


  		




  177
  
  
    
and parent.nodename = 'dataset';


  		




  
  178
  
    
and parent.nodename = 'dataset'


  		




  
  179
  
    
and child.nodetype = 'TEXT';


  		




  178
  180
  
    

  		




  179
  181
  
    
-- update organization using nodes


  		




  180
  182
  
    
update doi_registration doi


  		












Also available in:  Unified diff