[development] Best practice for update_sql?

Earnie Boyd earnie at users.sourceforge.net
Fri Feb 29 20:05:25 UTC 2008


Quoting mark burdett <mfburdett at gmail.com>:

> On Fri, Feb 29, 2008 at 8:01 AM, Earnie Boyd
> <earnie at users.sourceforge.net> wrote:
>>  $sql[] = "UPDATE {profile_files} SET category = '%s' WHERE
>>  LOWER(category) = '%s'";
>>  $sql[] = 'Account settings';
>>  $sql[] = 'account';
>>  $ret[] = update_sql($sql);
>
> I guess this was an example of how it could work but doesn't?
> update_sql and db_query need a string as their argument and first
> argument, respectively.
>

Sorry, yes, I misread db_query.  What good is update_sql then?  Hmm... 
I find a two plus years old ticket for this [1].

[1] http://drupal.org/node/36324

Earnie -- http://for-my-kids.com/
-- http://give-me-an-offer.com/



More information about the development mailing list