Revision 770
Added by bojilova over 23 years ago
src/edu/ucsb/nceas/metacat/AccessionNumber.java | ||
---|---|---|
199 | 199 |
PreparedStatement pstmt; |
200 | 200 |
pstmt = conn.prepareStatement( |
201 | 201 |
"SELECT 'x' FROM xml_documents " + |
202 |
"WHERE docid LIKE ? " +
|
|
202 |
"WHERE docid = ? " +
|
|
203 | 203 |
"UNION " + |
204 | 204 |
"SELECT 'x' FROM xml_revisions " + |
205 |
"WHERE docid LIKE ?");
|
|
205 |
"WHERE docid = ?");
|
|
206 | 206 |
pstmt.setString(1,accNumber); |
207 | 207 |
pstmt.setString(2,accNumber); |
208 | 208 |
pstmt.execute(); |
... | ... | |
227 | 227 |
PreparedStatement pstmt; |
228 | 228 |
pstmt = conn.prepareStatement( |
229 | 229 |
"SELECT 'x' FROM xml_documents " + |
230 |
"WHERE docid LIKE ?");
|
|
230 |
"WHERE docid = ?");
|
|
231 | 231 |
pstmt.setString(1, accNumber); |
232 | 232 |
pstmt.execute(); |
233 | 233 |
ResultSet rs = pstmt.getResultSet(); |
Also available in: Unified diff
changed like with =