if you find some time soon, why not make it up and submit it for the component contest ben was talking about?
sounds like a good candidate to me! ----- Original Message ----- From: "Jim Kass" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 4:57 PM Subject: RE: Witango-Talk: Quick Question... > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
