Re: Text Reports query

On Thu, 27 Nov 2003 13:35:50 -0700
Vincent Danen <[email protected]> wrote:

> 
> On Nov 27, 2003, at 13:31, Russell Valentine wrote:
> 
> >>>> Ok... I don't get any errors with the changes to textreport or the
> >>>> advanced query, but I don't get any data either.  The report is 
> >>>> empty
> >>>> other than the header info and the advanced query also shows the
> >>>> header
> >>>> but no data.
> >>>
> >>> Thats odd, I modified the query in a version I was working on, but
> >>> didn't
> >>> take into account Mysql and I got data. I'll take a look at the
> >>> changes.
> >>
> >> No, this was on the postgres install I have that I got no data...
> >> haven't tried on the mysql side yet.
> >>
> >> Take a look in CVS (may want to do a checkout as I've changed a few
> >> things already today... that'll keep us on the same page).
> >
> > Did a checkout of cvs, I'm getting data.. Darn. I'll try to figure out
> > what the deal could be.
> 
> Can you double-check that you've got revision 1.110 of 
> functions.inc.php?

[email protected] include $ cvs status functions.inc.php
===================================================================
File: functions.inc.php Status: Up-to-date

   Working revision:    1.110
   Repository revision: 1.110   /cvsroot/anthill-0.3/include/functions.inc.php,v
   Sticky Tag:          (none)
   Sticky Date:         (none)
   Sticky Options:      (none)


Its probably a problem with the joins, joins are my weak area in my SQL
knowledge.

I get both reports and advance queries fine, I have three bugs in my
database and I try doing differt queries and sorting. It is all working
for me. I'll put in other fake data/users to try to resolve the issue and
readup more about joins again.

If you put the query in psql you get no data either?


Russell Valentine

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/xmTjO0EDJO5MgRYRAiB+AJ9xYsipzBsoLS4WzgLO4MPvKaPOGgCbBlNp
f9b6UKCw+c9UZWcBG2iTzS0=
=LEW3
-----END PGP SIGNATURE-----