This is splorp.

ISSN 1496-3221

|

June 19, 2003

Querious maximus.

UPDATE images_augSET keywords = IIF(kw1,kw1 & ", ", "") & IIF(kw2,kw2 & ", ", "") & IIF(kw3,kw3 & ", ", "") & IIF(kw4,kw4 & ", ", "") & IIF(kw5,kw5 & ", ", "") & IIF(kw6,kw6 & ", ", "") & IIF(kw7,kw7 & ", ", "") & IIF(kw8,kw8 & ", ", "") & IIF(kw9,kw9 & ", ", "") & IIF(kw10,kw10 & ", ", "") & IIF(kw11,kw11 & ", ", "") & IIF(kw12,kw12 & ", ", "") & IIF(kw13,kw13 & ", ", "") & IIF(kw14,kw14 & ", ", "") & IIF(kw15,kw15 & ", ", "") & IIF(kw16,kw16 & ", ", "") & IIF(kw17,kw17 & ", ", "") & IIF(kw18,kw18 & ", ","") & IIF(kw19,kw19 & ", ", "") & IIF(kw20,kw20 & ", ", "") & IIF(kw21,kw21 & ", ", "") & IIF(kw22,kw22 & ", ", "") & IIF(kw23,kw23 & ", ", "") & IIF(kw24,kw24 & ", ", "") & IIF(kw25,kw25 & ", ", "") & IIF(kw26,kw26 & ", ", "") & IIF(kw27,kw27 & ", ", "") & IIF(kw28,kw28 & ", ", "") & IIF(kw29,kw29 & ", ", "") & IIF(kw30,kw30 & ", ", "") & IIF(kw31,kw31 & ", ", "") & IIF(kw32,kw32 & ", ", "") & IIF(kw33,kw33 & ", ", "") & IIF(kw34,kw34 & ", ", "") & IIF(kw35,kw35 & ", ", "") & IIF(kw36,kw36 & ", ", "") & IIF(kw37,kw37 & ", ", "") & IIF(kw38,kw38 & ", ", "") & IIF(kw39,kw39 & ", ", "") & IIF(kw40,kw40 & ", ", "") & IIF(kw41,kw41 & ", ", "") & IIF(kw42,kw42 & ", ", "") & IIF(kw43,kw43 & ", ", "") & IIF(kw44,kw44 & ", ", "") & IIF(kw45,kw45 & ", ", "") & IIF(kw46,kw46 & ", ", "") & IIF(kw47,kw47 & ", ", "") & IIF(kw48,kw48 & ", ", "") & IIF(kw49,kw49 & ", ", "") & IIF(kw50,kw50 & ", ", "") & IIF(kw51,kw51 & ", ", "") & IIF(kw52,kw52 & ", ", "") & IIF(kw53,kw53 & ", ", "") & IIF(kw54,kw54 & ", ", "") & IIF(kw55,kw55 & ", ", "") & IIF(kw56,kw56 & ", ", "") & IIF(kw57,kw57 & ", ", "") & IIF(kw58,kw58 & ", ", "") & IIF(kw59,kw59 & ", ", "") & IIF(kw60,kw60 & ", ", "") & IIF(kw61,kw61 & ", ", "");

Oof. Can somebody please help my friend Issa figure out how to loop through a query array in SQL? He’d be most appreciative.

This item was posted by Grant Hutchinson.

Categories:

Leave a comment or send a trackback from your own site.

|

Leave a comment.

You may use the following HTML elements and attributes to format your comment:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>