On Tue, Aug 09, 2005 at 01:27:55PM -0400, Chris Hoover wrote: > When I connect to a 7.3.4 database, the query returns 0 rows and a > sqlca.sqlcode of 0 > > However, when I connect to an 8.0.3 database, the query returns 0 rows > and a sqlca.sqlcode of 100.
You don't mention it but it sounds like you're using ECPG. Can you post a simple but complete example that works differently in 7.3.4 and 8.0.3? I just did some tests with 7.3.10 and 8.0.3 and both returned a sqlca.sqlcode of 100 for a query that returned no rows. Either something changed between 7.3.4 and 7.3.10 or my test didn't duplicate what you're doing. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend From [EMAIL PROTECTED] Tue Aug 09 11:46:42 2005 Return-path: <[EMAIL PROTECTED]> Envelope-to: [email protected] Delivery-date: Tue, 09 Aug 2005 11:46:42 -0700 Received: from exprod5mx109.psmtp.com ([64.18.0.61] helo=psmtp.com) by gen6 with smtp (Exim 4.50) id 1E2Z7a-0005ru-SO for [email protected]; Tue, 09 Aug 2005 11:46:42 -0700 Received: from source ([63.251.223.186]) by exprod5mx109.postini.com ([64.18.4.10]) with SMTP; Tue, 09 Aug 2005 13:46:42 CDT Received: (qmail 30055 invoked by uid 514); 9 Aug 2005 18:46:42 -0000 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm Precedence: bulk List-Post: <mailto:[email protected]> List-Help: <mailto:[EMAIL PROTECTED]> List-Unsubscribe: <mailto:[EMAIL PROTECTED]> List-Subscribe: <mailto:[EMAIL PROTECTED]> List-Id: <cvs-p5ee.perl.org> Delivered-To: mailing list [email protected] Received: (qmail 30046 invoked from network); 9 Aug 2005 18:46:42 -0000 Received: from x1a.develooper.com (HELO x1.develooper.com) (216.52.237.111) by lists.develooper.com with SMTP; 9 Aug 2005 18:46:42 -0000 Received: (qmail 9638 invoked by uid 225); 9 Aug 2005 18:46:41 -0000 Delivered-To: [EMAIL PROTECTED] Received: (qmail 9632 invoked by alias); 9 Aug 2005 18:46:41 -0000 X-Spam-Status: No, hits=-5.9 required=8.0 tests=ALL_TRUSTED,BAYES_00 X-Spam-Check-By: la.mx.develooper.com Received-SPF: pass (x1.develooper.com: domain of [EMAIL PROTECTED] designates 63.251.223.176 as permitted sender) Received: from la.mx.develooper.com (HELO x1.develooper.com) (63.251.223.176) by la.mx.develooper.com (qpsmtpd/0.28) with SMTP; Tue, 09 Aug 2005 11:46:38 -0700 Received: (qmail 9524 invoked by uid 421); 9 Aug 2005 18:46:22 -0000 Date: 9 Aug 2005 18:46:22 -0000 Message-ID: <[EMAIL PROTECTED]> From: Stephen Adkins <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: cvs commit: p5ee/App-Repository/lib/App/SessionObject RepositoryObjectDomain.pm X-pstn-levels: (S:99.90000/99.90000 R:95.9108 P:95.9108 M:97.0232 C:98.7678 ) X-pstn-settings: 1 (0.1500:0.1500) gt3 gt2 gt1 r p m c X-pstn-addresses: from <[EMAIL PROTECTED]> [294/10] cvsuser 05/08/09 11:46:22 Modified: App-Repository/lib/App/SessionObject RepositoryObjectDomain.pm Log: change containment separator from . to - Revision Changes Path 1.4 +3 -3 p5ee/App-Repository/lib/App/SessionObject/RepositoryObjectDomain.pm Index: RepositoryObjectDomain.pm =================================================================== RCS file: /cvs/public/p5ee/App-Repository/lib/App/SessionObject/RepositoryObjectDomain.pm,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- RepositoryObjectDomain.pm 28 Mar 2005 20:44:25 -0000 1.3 +++ RepositoryObjectDomain.pm 9 Aug 2005 18:46:22 -0000 1.4 @@ -60,7 +60,7 @@ my $context = $self->{context}; my ($object_set_name, $object_set); foreach my $table (@tables) { - $object_set_name = $self->{object_set}{$table}{name} || "$self->{name}.$table"; + $object_set_name = $self->{object_set}{$table}{name} || "$self->{name}-$table"; $object_set = $context->session_object($object_set_name); $object_set->_clear_cache(); } @@ -81,7 +81,7 @@ my $context = $self->{context}; my $params = $self->{params} || {}; - my $object_set_name = $self->{object_set}{$table}{name} || "$self->{name}.$table"; + my $object_set_name = $self->{object_set}{$table}{name} || "$self->{name}-$table"; my $args = $self->{object_set}{$table}{args} || {}; if (!$args->{class}) { $args->{class} = "App::SessionObject::RepositoryObjectSet";
