• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem creating a PreparedStatement

 
Mary Taylor
Ranch Hand
Posts: 327
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The forum description said we could "even brush up on some sql " here so I'm hoping you don't mind this question.

I'm just getting a vague message that there is something wrong with the syntax:


The value of paperTitle in the debug window is "BeKind.doc".

Is the problem the period within the String? If so, what must I change?

Thanks so much.
 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sir...

what do you save name of your data/attachment?..
what kind of document could be saved in your application?



As far as i know, your preparedStamenet isn't wrong..
 
Mary Taylor
Ranch Hand
Posts: 327
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, the statement does work at the command line. It only appears to be a problem in the servlet in the PreparedStatement.

I am not sure at this time what types of documents I will store; but at least some will be Microsoft Word documents being
stored in a BLOB in MySql. I can store the document just fine; I am now trying to select the row in the table with the title of
the document.

Thank you for any suggestions.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic