Project

General

Profile

« Previous | Next » 

Revision 95df0734

Added by Andreas Müller over 4 years ago

ref #1444 fix sql for link import ERMS

View differences:

cdm-pesi/src/main/java/eu/etaxonomy/cdm/io/pesi/erms/ErmsLinkImport.java
59 59
			" SELECT l.* " +
60 60
			        ",'%s' + link_url + '%s' + ISNULL(link_text, '')   valueAll" + //+ ' ,@Note: ' + ISNULL(CAST(note as nvarchar(max)), '')
61 61
			" FROM links l " +
62
			" WHERE ( links.id IN (" + ID_LIST_TOKEN + ") )";
62
			" WHERE ( l.id IN (" + ID_LIST_TOKEN + ") )";
63 63
		strRecordQuery = String.format(strRecordQuery, TOKEN_URL, TOKEN_LINKTEXT);
64 64
		return strRecordQuery;
65 65
	}

Also available in: Unified diff