multiple simultaneous DBI connections?

2003-03-13 Thread Tom Norwood
is created, and to disconnect() using garbage disposal. Although the object initially would only have one instance per script, I can't help feeling it is a bad idea. Any thoughts welcome, and greatly appreciated, Tom Norwood. This email has been scanned for viruses by NetBenefit using Sophos anti

RE: multiple simultaneous DBI connections?

2003-03-13 Thread Tom Norwood
before the object's methods try to initiate calls to the MySQL server. Also a similar point goes for disconnect()-ing from the server, my object would 'know' that a connection is available if it exists! So no additional coding would be required within my object's methods. Tom Norwood

RE: multiple simultaneous DIB connections?

2003-03-13 Thread Tom Norwood
Although my initial implementation would only deal with one instance of my object. There WOULD be simultaneous connections if two or more instances of my object existed at the same time. Tom Norwood. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 13 March 2003 16:23

Another 'Too many connections' question...

2002-08-21 Thread Tom Norwood
A couple of weeks ago I came across this error which effectively closed down our site. Two things: (1) I am using Perl DBI to interface mySQL is there any way to effectively capture such errors and provide an alternate web page? I guess there has to be, but I experimented with the 'PrintError'

Date Comparison Problem...

2002-07-27 Thread Tom Norwood
Just when I thought I was getting the hang of this mysql stuff, the simplest of tasks is causing me to think about pulling my hair out. My table: NEWS { newsID (INT(3), AUTO-INCREMENT), newsTitle (VARCHAR (50)), newsText (BLOB), newsDate (DATE) } I just want to filter

ADD: Date Comparison Problem...

2002-07-27 Thread Tom Norwood
Very interesting addition to message... Forgot to mention what the problem-query produces: Nothing. Cheers, Tom. -Original Message- From: Tom Norwood [mailto:[EMAIL PROTECTED]] Sent: 27 July 2002 19:39 To: mysql-list Subject: Date Comparison Problem... Just when I thought I