Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
carlos flamenco
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"select 1 from uploaded_files where filename = '" + myfilename + "'"?
- Peter
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic