[support] Another DBTNG question

Ms. Nancy Wichmann nan_wich at bellsouth.net
Tue Oct 25 22:39:47 UTC 2011


Boombatower's conversion doesn't seem to handle HAVING:
  SELECT uid FROM {userpoints} WHERE uid > 0  GROUP BY uid HAVING SUM(points) > %d

I wonder if this even works on a Postgres system, but that's not my issue.

How would this convert to DBTNG? Yes, I know I can still do a db_query (as I am currently doing), but I'd like to convert everything.

 
Nancy 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20111025/bfe3ef9e/attachment.html 


More information about the support mailing list