<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">That was badly phrased at the end. I meant: I think that makes sense, but I can't figure out the syntax.<div><br></div><div>Any pointers gratefully appreciated.</div><div><br><div><div>On 01 Nov 2011, at 5:33 PM, Jeff Brown wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hope you'll pardon my absolute lack of knowledge of SQL and give me a <br>little clue or 2.<br><br>I'm retroactively changing the photos layout on a site to Views <br>Gallery, and need to update a couple of image nodes to the Term <br>"gallery".<br><br>Could do it manually, I guess, but I'd really love to know this trick.<br><br>So I have nid 1,2,3,4, etc. that need to have the gallery tid = <br>'1' (for argument's sake).<br><br>Therefore I need to update the 'term_node' table - and INSERT where <br>nid = 1,2,3,4 tid = '1'<br><br>I think that makes sense?<br><br>Thanks. :)<br>-- <br>[ Drupal support list | <a href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]<br></div></blockquote></div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div><div><span class="Apple-style-span" style="font-size: medium;"><font class="Apple-style-span" face="Courier"><br></font></span></div></div></div></div></span></div></span></div></div></body></html>