Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread demerphq
On Fri, 27 Jan 2023 at 03:48, Steven Haigh wrote: > > > On Fri, Jan 27 2023 at 10:41:02 +0800, demerphq wrote: > > On Fri, 27 Jan 2023, 10:35 Steven Haigh via modperl, > wrote: >> >> On Thu, Jan 26 2023 at 21:07:17 -0500, Perrin Harkins >> wrote: >> >> Maybe you haven't committed some manual

Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread Steven Haigh via modperl
On Fri, Jan 27 2023 at 10:41:02 +0800, demerphq wrote: On Fri, 27 Jan 2023, 10:35 Steven Haigh via modperl, mailto:modperl@perl.apache.org>> wrote: On Thu, Jan 26 2023 at 21:07:17 -0500, Perrin Harkins mailto:phark...@gmail.com>> wrote: Maybe you haven't committed some manual change on the

Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread demerphq
On Fri, 27 Jan 2023, 10:35 Steven Haigh via modperl, < modperl@perl.apache.org> wrote: > > > On Thu, Jan 26 2023 at 21:07:17 -0500, Perrin Harkins > wrote: > > Maybe you haven't committed some manual change on the server, so it isn't > visible to other connections. > > > I thought about this -

Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread Steven Haigh via modperl
On Thu, Jan 26 2023 at 21:07:17 -0500, Perrin Harkins wrote: Maybe you haven't committed some manual change on the server, so it isn't visible to other connections. I thought about this - but surely, restarting *everything* (db + apache + entire VM) would cause this to fall out. Also,

Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread Mithun Bhattacharya
Instead of COUNT(*) what do you see when you do a SELECT * ? On Thu, Jan 26, 2023, 6:07 PM Perrin Harkins wrote: > Maybe you haven't committed some manual change on the server, so it isn't > visible to other connections. > > On Thu, Jan 26, 2023 at 8:56 PM Steven Haigh via modperl < >

Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread demerphq
On Fri, 27 Jan 2023, 09:55 Steven Haigh, wrote: > > > On Fri, Jan 27 2023 at 09:50:42 +0800, demerphq > wrote: > > On Fri, 27 Jan 2023, 09:43 Steven Haigh via modperl, < > modperl@perl.apache.org> wrote: > >> Hi all, >> >> I'm a little confused about my little mod_perl web site at the moment.

Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread Perrin Harkins
Maybe you haven't committed some manual change on the server, so it isn't visible to other connections. On Thu, Jan 26, 2023 at 8:56 PM Steven Haigh via modperl < modperl@perl.apache.org> wrote: > > > On Fri, Jan 27 2023 at 09:50:42 +0800, demerphq > wrote: > > On Fri, 27 Jan 2023, 09:43 Steven

RE: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread Mike OKrongli
Hi This page on perlmonks.org/?node_id=317752 mentions you should name the count(*) value and then call for the value of that “column”. I hope that can point you in a good direction Mike From: Steven Haigh via modperl Sent: January 26, 2023 8:56 PM To: demerphq Cc: modperl

Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread Steven Haigh via modperl
On Fri, Jan 27 2023 at 09:50:42 +0800, demerphq wrote: On Fri, 27 Jan 2023, 09:43 Steven Haigh via modperl, mailto:modperl@perl.apache.org>> wrote: Hi all, I'm a little confused about my little mod_perl web site at the moment. I'm doing an SQL query, then punting the results into a

Re: Confusion about SQL results - row counts and contents differ

2023-01-26 Thread demerphq
On Fri, 27 Jan 2023, 09:43 Steven Haigh via modperl, < modperl@perl.apache.org> wrote: > Hi all, > > I'm a little confused about my little mod_perl web site at the moment. > > I'm doing an SQL query, then punting the results into a dataset to display > via the web page. > > When I do the query

Confusion about SQL results - row counts and contents differ

2023-01-26 Thread Steven Haigh via modperl
Hi all, I'm a little confused about my little mod_perl web site at the moment. I'm doing an SQL query, then punting the results into a dataset to display via the web page. When I do the query directly on the SQL server, I see: SELECT COUNT(*) FROM printers; 30 When I do the same in code