Well, I must be doing something wrong then. My taf is
very simple, with 4 actions.
1. Search (retrieves name and location from an access
table)
2. Results html (displays resultset)
3. Simple mail action
4. Duplicate of above results html
John
Here is the output of my taf:
Title:
Author:
Version:
Debug: on
docs_metatag [Results]
Search [Search]
defaultresultset [Results]
Mail2 [Email]
samedefaultresultset [Results]
---------------------------------------------------------
-----------------------
docs_metatag [Results]
ResultHTML
<@docs encoding="none">
---------------------------------------------------------
-----------------------
Search [Search]
Select Column
tblEmployees.last_name
tblEmployees.first_name
tblEmployees.LS_location
Criteria
Column Oper Value Incl. Empty Quote Value
Results
MaxRows StartFrom DistinctRows TotalRows
3 1 off off
ResultHTML
DataSource
resources (type:ODBC user: database: deployment_user:)
---------------------------------------------------------
-----------------------
defaultresultset [Results]
ResultHTML
@@resultset
---------------------------------------------------------
-----------------------
Mail2 [Email]
>From [EMAIL PROTECTED]
To [EMAIL PROTECTED]
Cc
Bcc
Subject test
Message
test
Options
Content Type text/plain
Character Set iso-8859-1
Wrap lines at 72 characters
Custom Headers
Attachments
---------------------------------------------------------
-----------------------
samedefaultresultset [Results]
ResultHTML
@@resultset
Metzger Roger
Ayrault Lisa MS 105
Blumenthal Jabe Allen Gates Hall Math Core
220 lion.lakesideschool.org Microsoft ESMTP MAIL
Service, Version: 5.0.2195.5329 ready at Tue, 15 Oct
2002 10:38:49 -0700
250 lion.lakesideschool.org Hello [172.16.1.46]
Command: MAIL FROM: <[EMAIL PROTECTED]>
250 2.1.0 [EMAIL PROTECTED] OK
Command: RCPT TO:
<[EMAIL PROTECTED]>
250 2.1.5 [EMAIL PROTECTED]
Command: Starting to send content
354 Start mail input; end with <CRLF>.<CRLF>
Command: Content sent
250 2.6.0
<[EMAIL PROTECTED]&g
t; Queued mail for delivery
221 2.0.0 lion.lakesideschool.org Service closing
transmission channel
---------------------------------------------------------
-----------------------
[Application File] [16]
START /technology/regonline/instructors/maildocs.taf
Tango_2000_Server
[Results Action] [16] docs_metatag
[Search Action] [16] Search
[Query] [16] SELECT
t1.last_name,t1.first_name,t1.LS_location FROM
tblEmployees t1
[ActionResults] [33] Metzger Roger
[Results Action] [33] defaultresultset
[Mail Action] [33] Mail2
[Query] [33] Server: 172.16.1.79 Port: 25 Message:
[Subject: test Date: Tue, 15 Oct 2002 10:38:49 -0800
From: [EMAIL PROTECTED] To:
[EMAIL PROTECTED] CC: Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1" Content-
transfer-encoding: quoted-printable X-Mailer: Tango 2000
Version 4.05.020 ]
[ActionResults] [50] 220 lion.lakesideschool.org
Microsoft ESMTP MAIL Service, Version: 5.0.2195.5329
ready at Tue, 15 Oct 2002 10:38:49 -0700
[Results Action] [50] samedefaultresultset
[local$ Vars] [66] resultSet=[Array:11x1]
variableTimeout=30
> ??? What do you mean? A query is a select from a database and a mail
> action is not. If you're getting a resultset over written it's because
> you're doing SOMETHING in the mail action (Like calling a method which
> does a query) which is overwriting your original resultset.
>
> Pretty bad assumption.
>
> R
> On Tuesday, October 15, 2002, at 01:08 PM, [EMAIL PROTECTED] wrote:
>
> > I just realized after beating my head against a wall for
> > a few hours trying to solve an odd resultset behavior,
> > that a mail action is a query, and creates its own
> > resultset, over writing any previous resultset.
> >
> > Just had to tell somebody!
> >
> > JOhn NEwsom
> >
> > _______________________________________________________________________
> > _
> > TO UNSUBSCRIBE: send a plain text/US ASCII email to
> > [EMAIL PROTECTED]
> > with unsubscribe witango-talk in the message body
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
