Hey guys, thanks. So the consensus is there is no shorter way to do this - sounds like someone should develop a custom tag for <@JOIN>.
I'm using this functionality a lot to grab pri keys from a table so I could imagine developing a .tcf which does what I want, and then use it like this: SELECT ... WHERE id IS IN ( '<@JOIN ARRAY=local$idArray DELIMITER="','">' ) If no one has one like it already - maybe I'll take a crack at it when I have some free time. Jim Kass Web Developer -- Forestweb: The Source for Industry Intelligence Best Content -- Most Relevant -- Best Delivery http://www.forestweb.com (310) 553 - 0008 -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 4:20 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Quick Question... <@ASSIGN NAME="Trans" VALUE='<@TRANSPOSE ARRAY="@@resultSet">' SCOPE="request"> <@ASSIGN NAME="Rtrans" VALUE='<@VAR NAME=Trans SCOPE=request TYPE="text" APREFIX="" ASUFFIX="" RPREFIX="" RSUFFIX="" CSUFFIX="," CPREFIX="">' SCOPE="request"> <@ASSIGN NAME="NewTrans" VALUE='<@SUBSTRING STR="@@request$Rtrans" START="1" NUMCHARS="<@CALC EXPR='len(@@request$Rtrans) - 1'>">' SCOPE="request"> @@request$NewTrans Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Jim Kass [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 4:01 PM To: [EMAIL PROTECTED] Com Subject: Witango-Talk: Quick Question... Excuse me if I've already asked this (I may have, I don't remember)... What is the fastest way to turn an array into a string separated by commas, i.e the opposite of the @TOKENIZE, and equivalent of a "JOIN". As you can imagine: <@VAR NAME=about_list SCOPE=domain TYPE="text" APREFIX="" ASUFFIX="" RPREFIX="" RSUFFIX="," CSUFFIX="" CPREFIX=""> ends up with an extra comma-- Jim Kass Web Developer -- Forestweb: The Source for Industry Intelligence Best Content -- Most Relevant -- Best Delivery http://www.forestweb.com (310) 553 - 0008 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
