This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Value in database automatically changing to NULL  RSS feed

 
Jagannathan Sundararajan
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

Im getting a problem in my tool. I am updating the "last accessed date" in Page1 on my app & when i check in the database this value is reflecting in database too.

But when i click on the Next Page option which takes me to Page2 & after coming back to Page1 from Page2, Page1 shows me NULL value for the last accessed date in both the application & database.

I am using Struts 1.0 framework & an Oracle 11g database.

I am seriously surprised to see this.

Any suggestions would help me greatly.

Thank you in advance.
 
William Brogden
Author and all-around good cowpoke
Rancher
Posts: 13078
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How does "page 2" update the database?

Bill
 
Carles Gasques
Ranch Hand
Posts: 199
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

What are you doing in your code?

Executing an insert without parameters (insert into T(last) values sysdate) or a parametrized query (insert into T(last) values ?).
If you use a parametrized query from where you get the time value?


Cheers,

Jagannathan Sundararajan wrote:Hi All,

Im getting a problem in my tool. I am updating the "last accessed date" in Page1 on my app & when i check in the database this value is reflecting in database too.

But when i click on the Next Page option which takes me to Page2 & after coming back to Page1 from Page2, Page1 shows me NULL value for the last accessed date in both the application & database.

I am using Struts 1.0 framework & an Oracle 11g database.

I am seriously surprised to see this.

Any suggestions would help me greatly.

Thank you in advance.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!