[Solar-talk] problem with related tables with latest svn
Paul M Jones
pmjones at paul-m-jones.com
Sat Apr 12 08:21:36 CDT 2008
On Apr 12, 2008, at 06:45 , Jeff Surgeson wrote:
> SELECT
> COUNT(gallery.id)
> FROM gallery
> WHERE
> gallerycat.sub_cat_name = \'bike images\'
> LIMIT 1
The reason it doesn't work is the WHERE clause; there's no FROM or
JOIN to the "gallerycat" table. I'll go back over the countPages()
code and make sure it's not stripping things out that it needs. Sorry
for the trouble.
-- pmj
More information about the Solar-talk
mailing list