On 3 Aug 2006, at 07:18, Sammy Spets wrote:
Hi all,
* Your SQL queries will not work on PostgreSQL. It needs db_query('word "%s" word') not db_query("word '%s' word").
For the reference of those that don't know yet, the correct way for both MySQL and PostgreSQL is: db_query("word '%s' word");
Strings in ALL database systems must be encased in single quotes. If you do otherwise you're breaking the SQL standard.
I'll guess I'll be going back and changing it all to what it was then before moby chipped in... ;)
Cheers,
-- Sammy Spets Synerger Pty Ltd http://www.synerger.com/
M Information in this electronic mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this mail by anyone else is unauthorised. If you are not the intended recipient any use, disclosure, copying or distribution of this message is prohibited and may be unlawful. When addressed to our customers, any information contained in this message is subject to intY's Terms & Conditions. Please rely on your own virus scanning and procedures with regard to any attachments to this message. Scanned by MailDefender - managed email security from intY - www.maildefender.net