Novice: Date Binding Problem

2002-08-12 Thread Max Hugen
I've struck a problem in binding a date to a DBI prepared statement, to send to Oracle8i. I declared a variable: $dbtimestamp="TO_DATE('$db_ts', 'DD-MM- HH24:MI:SS')" ; The string $db_ts is from a function which outputs the system time, in exactly the same format as that declared in the

Re: DBI->connect_cached not playing with Apache::DBI

2002-08-12 Thread Michael G Schwern
On Mon, Aug 12, 2002 at 07:56:57AM +0100, Tim Bunce wrote: > They (slightly) have different semantics so I'd be reluctant to > transparently substitute one for another. Fair nuff. > But how about a new method: > > DBI->connect_method("connect"); > DBI->connect_method("Apache::DBI::connect"

mysql restore command

2002-08-12 Thread Vanna Chhun
Dear all i have a problem that i want to restore after using mysqldump command to operate back up process in my MySQL server, i actually don't know what command to restore that it goes with mysqldump backup. your help is my encouragement thank in advance vanna ---

Re: Interesting DBI/alarm()/Solaris problem? !?

2002-08-12 Thread David M. Lloyd
On Mon, 12 Aug 2002, Joe Slagel wrote: > Hi All, > > We're seeing some very odd behavior with using alarm() around the > DBI->connect() call only on Solaris platforms. It appears that even > though we clear the alarm after a successful connection, for some reason > the alarm signal is still getti

Interesting DBI/alarm()/Solaris problem? !?

2002-08-12 Thread Joe Slagel
Hi All, We're seeing some very odd behavior with using alarm() around the DBI->connect() call only on Solaris platforms. It appears that even though we clear the alarm after a successful connection, for some reason the alarm signal is still getting sent and we receive a very nice "Alarm Clock" m

Re: Threading and DBI in perl 5.8.0

2002-08-12 Thread Scott Alexander
Thanks for the response Tim. Commenting out this line appears to have fixed the first problem. It no longer dies when it clones the process. > DBIS->logfp = parent_dbis ? fp_dup(parent_dbis->logfp,'>',0) : > PerlIO_stderr(); If you would still like to see the stack trace, I can uncomment th

search.cpan.org - worth a look

2002-08-12 Thread Tim Bunce
On Mon, Aug 12, 2002 at 09:54:02AM +0100, Graham Barr wrote: > For those who dont know, search-beta became search over the weekend. Excellent. And for those who haven't played with search.cpan.org for a while... do yourselves a favor and take a look. It's excellent. Tim. p.s. And then thank Gr

Re: FreeBSD only issue with fetchall_arrayref?

2002-08-12 Thread Eric Frazier
Hi, I just tried this at home on my other FreeBSD 4.5 machine, and there are no problems! I tried upgrading DBI 1.30 and then upgrading mySQL to 4.02 like I have at work, I can't seem to break it on my home machine. I guess it is possible that I could be using an old module without knowing it? Th

Re: request for DBD::Changes change (and possible bug)

2002-08-12 Thread Graham Barr
For those who dont know, search-beta became search over the weekend. Graham. On Mon, Aug 12, 2002 at 07:41:47AM +0100, Tim Bunce wrote: > FYI, the drop-down list on this page > > http://search-beta.cpan.org/author/JURL/DBD-ODBC/ > > shows the dates of all the releases. > > Tim. > > >