• Post Reply Bookmark Topic Watch Topic
  • New Topic

JSPs and SQL, displaying results error

 
Bob Backlund
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I'm not sure if this wants to be under the JSP forum or SQL, but I'll have a go.

I've writtena small program which uses JSP front end and SQL database at teh back, simply allowing people to enter some details into a DB and display the results to page (pretty standarrd stuff).

But I seem to be having a strange anomaly occur. Ever so often, on what seems to be a random row and colum from the DB, the output JSP doesn't show a result (e.g. all the "date entered" values from 1-20 are displayed apart from 3, 15 and 18 which are left blank!), In the WAS log I get a
"No such column COLUMNNAME" error, but as I say, the next row will display the value.

Has anyone else ever had this mysterious disappearing values, and does anyone know how to get them back?

Cheers
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!