Revision 768
Added by bojilova over 23 years ago
| src/edu/ucsb/nceas/metacat/DBQuery.java | ||
|---|---|---|
| 235 | 235 |
boolean tableHasRows = rs.next(); |
| 236 | 236 |
while (tableHasRows) |
| 237 | 237 |
{
|
| 238 |
docid = rs.getString(1); |
|
| 238 |
docid = rs.getString(1).trim();
|
|
| 239 | 239 |
if ( !hasPermission(dbconn2, user, group, docid) ) {
|
| 240 | 240 |
// Advance to the next record in the cursor |
| 241 | 241 |
tableHasRows = rs.next(); |
| ... | ... | |
| 295 | 295 |
"DBQuery.findDocuments: " + e.getMessage()); |
| 296 | 296 |
} |
| 297 | 297 |
|
| 298 |
docid = xmldoc.getDocID(); |
|
| 298 |
docid = xmldoc.getDocID().trim();
|
|
| 299 | 299 |
docname = xmldoc.getDocname(); |
| 300 | 300 |
doctype = xmldoc.getDoctype(); |
| 301 | 301 |
createDate = xmldoc.getCreateDate(); |
| ... | ... | |
| 379 | 379 |
tableHasRows = rs.next(); |
| 380 | 380 |
while(tableHasRows) |
| 381 | 381 |
{
|
| 382 |
docid = rs.getString(1); |
|
| 382 |
docid = rs.getString(1).trim();
|
|
| 383 | 383 |
if ( !hasPermission(dbconn2, user, group, docid) ) {
|
| 384 | 384 |
// Advance to the next record in the cursor |
| 385 | 385 |
tableHasRows = rs.next(); |
Also available in: Unified diff
MS SQL Server stores trailing spaces in varchar fields which shouldn't be
thus added docid.trim() in the Java code