RE: Order by statement stopped working but not in all cases

2006-01-23 Thread Hardy Merrill
Sorry for the OT response but I couldn't let this go. Anna K's fame has faded?? She still has a few fans :) Ron, if you have any influence at the Australian Open, next year try to get them to sign a tv contract with ABC, NBC, or CBS - instead of ESPN2 which I don't get. Thanks. Hardy Merrill

RE: Order by statement stopped working but not in all cases

2006-01-23 Thread Ron Savage
On Mon, 23 Jan 2006 07:52:05 -0500, Hardy Merrill wrote: Hi Hardy Anna K's fame has faded?? She still has a few fans :) Interest in her physical side of her database remains strong. -- Cheers Ron Savage, [EMAIL PROTECTED] on 24/01/2006 http://savage.net.au/index.html Let the record show:

RE: Order by statement stopped working but not in all cases

2006-01-20 Thread Andy Hassall
Fong, Anna wrote: We have a bunch of applications that use DBI and DBD-Oracle and they've been running for quite some time now (months and years, depending on which app). Then within the last few days, one particular query within the bunch of apps stopped returning results. When I took

RE: Order by statement stopped working but not in all cases

2006-01-20 Thread Fong, Anna
to the Oracle system software -Original Message- From: Andy Hassall [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 12:39 PM To: Fong, Anna; dbi-users@perl.org Subject: RE: Order by statement stopped working but not in all cases Do you have error handling on the statement

RE: Order by statement stopped working but not in all cases

2006-01-20 Thread Ron Savage
On Fri, 20 Jan 2006 13:11:16 -0800, Fong, Anna wrote: Go Anna! [1] - three days ago the query in the web app worked as expected - no changes have been made to the affected web apps in 6 months or more - no changes have been made to the DBI and DBD-Oracle - no changes have been made to the

RE: Order by statement stopped working but not in all cases

2006-01-20 Thread Fong, Anna
20, 2006 3:22 PM To: List - DBI users Subject: RE: Order by statement stopped working but not in all cases But /something/ must have changed, right? What needs to change is your presumably false belief that nothing's changed :-)! And, yes, I mean that in the nicest possible way. -- Cheers

RE: Order by statement stopped working but not in all cases

2006-01-20 Thread Ron Savage
On Fri, 20 Jan 2006 15:57:26 -0800, Fong, Anna wrote: Hi Anna I could not find the underlying reason why this query no longer worked as expected, but have modified each of the affected applications to work around the issue. I'll keep my fingers crossed... Which is clearly a PITA. Good