[neclimdul@gmail.com: Fwd: [development] LinksDB vs. Links]
Syscrusher
syscrusher at 4th.com
Thu Aug 3 15:18:51 UTC 2006
On Thursday 03 August 2006 02:18, Sammy Spets wrote:
> 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 wondered about that when I saw the original post by Morbus Iff. I use
single quotes all the time in Postgres with Java programming, but I don't
use PG with Drupal or PHP at all, so I just assumed it must be some quirk in
the PHP Postgres libs. Thanks for clarifying. My world is at rest again.
Syscrusher
--
-------------------------------------------------------------------------------
Syscrusher (Scott Courtney) Drupal page: http://drupal.org/user/9184
syscrusher at 4th dot com Home page: http://4th.com/
More information about the development
mailing list