Moreover, update_sql() does not accept % arguments. It only accepts one argument<br>with is the SQL, so you have to concatenate what you need apriori.<br><br><div class="gmail_quote">On Fri, Feb 29, 2008 at 3:05 PM, Earnie Boyd <<a href="mailto:earnie@users.sourceforge.net">earnie@users.sourceforge.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="Wj3C7c">Quoting mark burdett <<a href="mailto:mfburdett@gmail.com">mfburdett@gmail.com</a>>:<br>
<br>
> On Fri, Feb 29, 2008 at 8:01 AM, Earnie Boyd<br>
> <<a href="mailto:earnie@users.sourceforge.net">earnie@users.sourceforge.net</a>> wrote:<br>
>> $sql[] = "UPDATE {profile_files} SET category = '%s' WHERE<br>
>> LOWER(category) = '%s'";<br>
>> $sql[] = 'Account settings';<br>
>> $sql[] = 'account';<br>
>> $ret[] = update_sql($sql);<br>
><br>
> I guess this was an example of how it could work but doesn't?<br>
> update_sql and db_query need a string as their argument and first<br>
> argument, respectively.<br>
><br>
<br>
</div></div>Sorry, yes, I misread db_query. What good is update_sql then? Hmm...<br>
I find a two plus years old ticket for this [1].<br>
<br>
[1] <a href="http://drupal.org/node/36324" target="_blank">http://drupal.org/node/36324</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com">2bits.com</a>, Inc.<br><a href="http://2bits.com">http://2bits.com</a><br>Drupal optimization, development, customization and consulting.