I did not want to blame you, just wanted to help you.
I didn't think you were blaming. 0-] We definitely appreciate any
and all help you can offer!
As I am using Mysql and Oracle in my projects, please let me know, if you have
that ready. I can help you testing, if you want.
I will let you know when I have it ready. Since my company doesn't
do any web development, it's not something that's been high on my
priority list to do. I will see what I can work up though.
Yes, the stored value in the rivet_cache database table was "0000-00-00
00:00:00" without a complain about an illegal syntax, as far as I know.
For Oracle you will need a "to_date('$now', 'YYYY-MM-DD HH24:MI:SS')", to be
independent from the session, in Mysql you could use a "DATE_FORMAT('$now',
'%Y-%m-%d %T')", to make it independent of the session (in the sql
statement).
Arnulf
Hrmm... I really hate date fields in SQL. I usually go with an
integer field and store [clock seconds]. It's more of a pain in the ass
to me to let the SQL server try and do the work when I can just as
easily do it myself with little-to-no loss of performance. We'll have
to decide on the best way to handle this.
Thanks again for the help!
Damon
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
