[neclimdul@gmail.com: Fwd: [development] LinksDB vs. Links]

Matthew Jenkins mattj at inty.net
Thu Aug 3 07:46:31 UTC 2006

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/

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

More information about the development mailing list