Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes how do I compare a string to a cloummn value to see if it's already in the table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how do I compare a string to a cloummn value to see if it Watch "how do I compare a string to a cloummn value to see if it New topic
Author

how do I compare a string to a cloummn value to see if it's already in the table

carlos flamenco
Greenhorn

Joined: Feb 28, 2001
Posts: 7
Hello,
I'm inserting xml files into a database as clobs and the filename just as a string, a number of files will be inserted and these are updated from log.How can i check if i've alreaduy inserted that particular file?
Thanks
Peter den Haan
author
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
"select 1 from uploaded_files where filename = '" + myfilename + "'"?
- Peter
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how do I compare a string to a cloummn value to see if it's already in the table