You pass in a one column array, and the delimiter you want and it returns a string. I guess I could also accept a boolean to determine whether you wanted the values encapsulated.
Robert.
On Wednesday, August 13, 2003, at 04:57 PM, Jim Kass wrote:
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
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
