Hi Damon,
Am Freitag, 12. August 2005 14:45 schrieb Damon Courtney:
> >diff dio_Mysql.tcl*
> >26c26
> >< if {[catch {package require mysqltcl}] \
> >---
> >
> >> if {[catch {package require Mysqltcl}] \
> >
> >51c51
> >< if {![lempty $host]} { lappend command -host $host }
> >---
> >
> >> if {![lempty $host]} { lappend command $host }
>
> I had actually fixed this and never committed it. The problem is
> that though we wrote the Mysql interface for DIO, no one ever did more
> than cursory testing of the whole thing. We're all Postgres guys here. 0-]
>
I did not want to blame you, just wanted to help you.
> >Trying the SESSION package with the Mysql database there were problems
> >creating the session tables, the field names package, key and data are
> >reserved words for Mysql, so I appended a '_' to the field names and
> > modified the source accordingly.
> >
> >There were also problems using now as timestamp value, I have introduced a
> >private variable now and fill that with a formatted string from Tcl clock
> >format command . If you intend to integrate Oracle, you have to provide
> >database specific code, because the date and time format is session
> > specific there! Maybe it would be a good idea, to provide a getNow
> > function in the DIO database specific code. The md5 code in my version
> > needs a -hex option (see changelog of that package)
>
> I plan to add Oracle support soon, but since I actually HAVE an
> Oracle database I can test against, we should be able to put something
> pretty solid together.
>
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.
> What problems did you have using 'now' as a timestamp variable?
> Mysql didn't like that?
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
>
> Damon
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
