Thanks especially to Jason who called me a worked with me on the phone till I got close enough to figure this out and then used his extra pair of eyes to spot the last small (duh)
The working results page is attached -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: "[Gauthier]" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Fri, 26 Jul 2002 22:15:14 +0200 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: <@Rows> <@For> I'm lost > > Just about the <@FILTER> MetaTag: > > ARRAY attribute expect the array name instead of the ARRAY value unless you > have stored arrayname in a variable > > so it may look like > <@FILTER ARRAY="Local$ResultSet" EXPR="#1=<@VAR Local$Course[<@CURROW>,8]>"> > > don't forget that <@CURROW> only work within <@FOR> or <@ROWS> MetaTags and > that you may need to assign the <@CURROW> value to some variable in order to > use it in nested loops > > Gauthier > > PS: I may take this thread from the root to be as accurate as possible, if > I'm totally out of topic, just warn me ;) > > ----- Original Message ----- > From: "Jason Pamental" <[EMAIL PROTECTED]> > To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> > Sent: Friday, July 26, 2002 4:05 PM > Subject: Re: Witango-Talk: <@Rows> <@For> I'm lost > > >> Dan, >> >> In your filter for the roster array, it looks like you are using all > course >> rows, not just the current one... >> >> <@ROWS <@FILTER ARRAY='@@resultset' EXPR='#1=local$course[*,8]'>> >> >> Shouldn't it be: >> >> <@ROWS <@FILTER ARRAY='@@resultset' EXPR='#1=local$course[<@currow>,8]'>> >> >> To only get names for the current loop in the course array? >> >> Jason >> >> On 7/26/02 9:39 AM, "Dan Stein" <[EMAIL PROTECTED]> wrote: >> >>> OK I put the correction back in and indeed it looks better but I still > have >>> everyone who is signed up for any course in every course. >>> >>> So it is not "filtering" the people for the course_ID >>> >> >> -- >> ____________________________________________________________________ >> >> Jason Pamental, President [EMAIL PROTECTED] >> >> Bathysphere Digital Media Services, Inc. http://bathyspheredms.com >> ____________________________________________________________________ >> >> Tel: 401.490.6830 Fax: 401.490.6831 >> ________________________________________ >> >> >> A North American Distributor for Witango (http://www.witango.com) >> >> Rapid Web Application Development - XML Execution Engine >> >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body > > > ______________________________________________________________________________ > ifrance.com, l'email gratuit le plus complet de l'Internet ! > vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... > http://www.ifrance.com/_reloc/email.emailif > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body >
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML> <HEAD> <SCRIPT LANGUAGE="JavaScript"> <!-- Original: CodeLifter.com ([EMAIL PROTECTED]) --> <!-- Web Site: http://www.codelifter.com --> <!-- This script and many more are available free online at --> <!-- The JavaScript Source!! http://javascript.internet.com --> <!-- Begin function printWindow() { bV = parseInt(navigator.appVersion); if (bV >= 4) window.print(); } // End --> </script> <TITLE>Course Roster By Name</TITLE> </HEAD> <BODY> <p><A HREF="#" onclick="javascript:window.close();">Close Window</A></p> <p><a href="javascript:printWindow()">Print This Page</a></p> <@ASSIGN NAME="local$results" VALUE="@@resultset"> <@ROWS ARRAY=local$courses > <DIV STYLE="page-break-after:always"> <h2 align="center"><font face="Arial, Helvetica, sans-serif"><@COL NUM=1> </font></h2> <h3 align="center"><font face="Arial, Helvetica, sans-serif">Course Number: <@COL NUM=9> </font></h3> <h4 align="center"><font face="Arial, Helvetica, sans-serif">Dates: <@COL NUM=2 FORMAT="datetime:@@dateFormat"> <@IF EXPR='<@COL NUM=2 FORMAT="datetime:@@dateFormat">=<@COL NUM=3 FORMAT="datetime:@@dateFormat">' <@ELSE> <@COL NUM=3 FORMAT="datetime:@@dateFormat"> </font></h4> </@IF> <h4 align="center"><font face="Arial, Helvetica, sans-serif">Times: <@COL NUM=4 FORMAT='datetime:%I:%M %p'> <@COL NUM=5 FORMAT='datetime:%I:%M %p'> </font></h4> <h4 align="center"><font face="Arial, Helvetica, sans-serif">Location: <@COL NUM=6> <@COL NUM=7> </font></h4> <h4 align="center"><font face="Arial, Helvetica, sans-serif">Sorted by Registration Date </font></h4> <table width="50%" border="0"> <tr> <td><strong><font size="2" face="Arial, Helvetica, sans-serif">Name</font></strong></td> <td><strong><font size="2" face="Arial, Helvetica, sans-serif">Phone</font></strong></td> </tr> <@COMMENT> local$courses[<@CURROW>,1572]'> </@COMMENT> <@ASSIGN NAME="local$reg" VALUE="<@FILTER ARRAY=local$results EXPR='#1=<@var local$courses[<@CURROW>,8]>'>"> <@ROWS> <@IFEMPTY <@VAR local$reg[<@CURROW>,3]>> <@ELSE> <tr> <td><font size="2" face="Arial, Helvetica, sans-serif"><@VAR local$reg[<@CURROW>,3]> <@VAR local$reg[<@CURROW>,4]></font></td> <td><font size="2" face="Arial, Helvetica, sans-serif"><@VAR local$reg[<@CURROW>,5]>-<@VAR local$reg[<@CURROW>,6]>-<@VAR local$reg[<@CURROW>,7]></font></td> </tr> </@IF> </@ROWS> </table> </DIV> </@ROWS> <p> </p> </BODY> </HTML>
