[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