Thanks everyone for jumping into this--
On Jul 4, 2011, at 3:52 AM, Beverly Voth wrote:
> Chuck is creating an INSERT, not select.
> And there is more revealed if you look at the taf in a text editor ( the raw
> XML ).
Here is the taf as revealed in textwrangler
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<TAF Version="0x02000002">
<Comments/>
<Program>
<ActionRef Ref="New_Record_Builder">
<ActionRef Ref="IfForm">
<ActionRef Ref="Form"/>
</ActionRef>
<ActionRef Ref="ElseIfInsert">
<ActionRef Ref="Insert"/>
<ActionRef Ref="InsertResponse"/>
</ActionRef>
<ActionRef Ref="ElseError">
<ActionRef Ref="InvalidFunction"/>
</ActionRef>
<ActionRef Ref="Return"/>
</ActionRef>
</Program>
<Actions>
<NewRecordBuilderAction DSID="pubradiopledge.fp7" DeploymentDSID=""
Expanded="True" ID="New_Record_Builder" Sig="igrp"
UseDevelopmentDataSource="TRUE">
<InsertColumns>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["First Name"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[First Name]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Last Name"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Last Name]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName>Email</ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle>Email</FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Partner/Spouse First Name"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Partner/ Spouse First Name]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Partner Spouse Last Name"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Partner Spouse Last Name]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Type of Membership"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Type of Membership]]></FieldTitle>
<InputOptions>
<InputDropDownList>
<InputListItem Selected="True">
<Name><![CDATA[New Member]]></Name>
<Value><![CDATA[New Member]]></Value>
</InputListItem>
<InputListItem Selected="False">
<Name><![CDATA[Renewing Member]]></Name>
<Value><![CDATA[Renewing Member]]></Value>
</InputListItem>
<InputListItem Selected="False">
<Name><![CDATA[Additional Gift]]></Name>
<Value><![CDATA[Additional Gift]]></Value>
</InputListItem>
</InputDropDownList>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Amount of Pledge"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Amount of Pledge]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["One Time Charge?"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[One Time Charge?]]></FieldTitle>
<InputOptions>
<InputRadioCluster>
<InputListItem Selected="False">
<Name><![CDATA[Charge this amount one time]]></Name>
<Value><![CDATA[One Time]]></Value>
</InputListItem>
<InputListItem Selected="False">
<Name><![CDATA[Break this amount into 10 installments]]></Name>
<Value>Installments</Value>
</InputListItem>
<InputListItem Selected="False">
<Name><![CDATA[Charge each month (create a sustaining
plan)]]></Name>
<Value>Sustaining</Value>
</InputListItem>
</InputRadioCluster>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Type of Payment"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Type of Payment]]></FieldTitle>
<InputOptions>
<InputDropDownList>
<InputListItem Selected="True">
<Name><![CDATA[Select type...]]></Name>
<Value/>
</InputListItem>
<InputListItem Selected="False">
<Name>Visa</Name>
<Value>Visa</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>Mastercard</Name>
<Value>Mastercard</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>Discover</Name>
<Value>Discover</Value>
</InputListItem>
<InputListItem Selected="False">
<Name><![CDATA[American Express]]></Name>
<Value><![CDATA[American Express]]></Value>
</InputListItem>
<InputListItem Selected="False">
<Name><![CDATA[Please Bill Me]]></Name>
<Value><![CDATA[Please Bill ]]></Value>
</InputListItem>
</InputDropDownList>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Credit Card Number"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Credit Card Number]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Expiration Month"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Expiration Month]]></FieldTitle>
<InputOptions>
<InputDropDownList>
<InputListItem Selected="False">
<Name><![CDATA[Select Month]]></Name>
<Value/>
</InputListItem>
<InputListItem Selected="False">
<Name>1</Name>
<Value>1</Value>
</InputListItem>
</InputDropDownList>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Expiration Year"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Expiration Year]]></FieldTitle>
<InputOptions>
<InputDropDownList>
<InputListItem Selected="True">
<Name><![CDATA[Select Year]]></Name>
<Value/>
</InputListItem>
<InputListItem Selected="False">
<Name>2011</Name>
<Value>2011</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2012</Name>
<Value>2012</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2013</Name>
<Value>2013</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2014</Name>
<Value>2014</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2015</Name>
<Value>2015</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2016</Name>
<Value>2016</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2017</Name>
<Value>2017</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2018</Name>
<Value>2018</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2019</Name>
<Value>2019</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>2020</Name>
<Value>2020</Value>
</InputListItem>
</InputDropDownList>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Cardholders Name"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Cardholders Name]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Street Address"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Street Address]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Street Address 2"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Street Address 2]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName>City</ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle>City</FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName>State</ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle>State</FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName>Zip</ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle>Zip</FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["Daytime Phone"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[Daytime Phone]]></FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName>Comments</ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle>Comments</FieldTitle>
<InputOptions>
<InputText Height="1" MaxLength="0" Password="False"
Scrolling="False" Width="40">
<DefaultValue/>
</InputText>
</InputOptions>
</InsertColumn>
<InsertColumn DataType="vcha" Length="0" PrimaryKey="False">
<ColumnName><![CDATA["May We Thank You On Air?"]]></ColumnName>
<TableName>pubradiopledge</TableName>
<TableOwner/>
<FieldTitle><![CDATA[May We Thank You On Air?]]></FieldTitle>
<InputOptions>
<InputDropDownList>
<InputListItem Selected="True">
<Name>Yes</Name>
<Value>Yes</Value>
</InputListItem>
<InputListItem Selected="False">
<Name>No</Name>
<Value>No</Value>
</InputListItem>
</InputDropDownList>
</InputOptions>
</InsertColumn>
</InsertColumns>
<SaveButtonTitle>Save</SaveButtonTitle>
<ResetButtonTitle><![CDATA[Reset Values]]></ResetButtonTitle>
<PageFormat BackgroundColor="default" Border="0" BorderColor="default"
CellPadding="default" CellSpacing="default" FontColor="default"
ShowEmptyCells="True" TablePadding="0" TableSpacing="0"/>
<HeaderOutput Ref="New_Record_Builder.Header"/>
<FooterOutput Ref="New_Record_Builder.Footer"/>
<InsertResponse Ref="New_Record_Builder.Response"/>
</NewRecordBuilderAction>
<IfAction ID="IfForm" Sig="if ">
<Expression><![CDATA[('<@ARG _function>'='nrform') or (!LEN('<@ARG
_function>'))]]></Expression>
<ExpressionInfo>
<ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
<ExpRight>nrform</ExpRight>
<Operator>iseq</Operator>
</ExpressionInfo>
<ExpressionInfo>
<ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
<ExpRight/>
<Conjunction><![CDATA[or ]]></Conjunction>
<Operator>iemp</Operator>
</ExpressionInfo>
</IfAction>
<ResultAction ID="Form" Sig="null">
<ResultsOutput Ref="Form.Results"/>
</ResultAction>
<ElseIfAction ID="ElseIfInsert" Sig="elif">
<Expression><![CDATA[('<@ARG _function>'='insert')]]></Expression>
<ExpressionInfo>
<ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
<ExpRight>insert</ExpRight>
<Operator>iseq</Operator>
</ExpressionInfo>
</ElseIfAction>
<InsertAction AutoCommit="True" DSID="pubradiopledge.fp7" DeploymentDSID=""
ID="Insert" Sig="insr" UseDevelopmentDataSource="TRUE">
<Tables>
<TableName>pubradiopledge</TableName>
</Tables>
<DataDictionary>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["First Name"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Last Name"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName>Email</ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Partner/Spouse First Name"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Partner Spouse Last Name"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Type of Membership"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Amount of Pledge"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["One Time Charge?"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Type of Payment"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Credit Card Number"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Expiration Month"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Expiration Year"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Cardholders Name"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Street Address"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Street Address 2"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName>City</ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName>State</ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName>Zip</ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["Daytime Phone"]]></ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName>Comments</ColumnName>
</Column>
<Column ColumnType="0" DataType="vcha">
<TableName>pubradiopledge</TableName>
<ColumnName><![CDATA["May We Thank You On Air?"]]></ColumnName>
</Column>
</DataDictionary>
<ValueList>
<ValueItem>
<Name><![CDATA["First Name"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_First Name>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Last Name"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Last Name>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name>Email</Name>
<Value><![CDATA[<@ARG pubradiopledge_Email>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Partner/Spouse First Name"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Partner/Spouse First
Name>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Partner Spouse Last Name"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Partner Spouse Last
Name>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Type of Membership"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Type of Membership>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Amount of Pledge"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Amount of Pledge>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["One Time Charge?"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_One Time Charge?>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Type of Payment"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Type of Payment>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Credit Card Number"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Credit Card Number>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Expiration Month"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Expiration Month>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Expiration Year"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Expiration Year>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Cardholders Name"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Cardholders Name>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Street Address"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Street Address>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Street Address 2"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Street Address 2>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name>City</Name>
<Value><![CDATA[<@ARG pubradiopledge_City>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name>State</Name>
<Value><![CDATA[<@ARG pubradiopledge_State>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name>Zip</Name>
<Value><![CDATA[<@ARG pubradiopledge_Zip>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["Daytime Phone"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_Daytime Phone>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name>Comments</Name>
<Value><![CDATA[<@ARG pubradiopledge_Comments>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
<ValueItem>
<Name><![CDATA["May We Thank You On Air?"]]></Name>
<Value><![CDATA[<@ARG pubradiopledge_May We Thank You On
Air?>]]></Value>
<QuoteValue>true</QuoteValue>
<IncludeIfEmpty>true</IncludeIfEmpty>
<NullValue>false</NullValue>
</ValueItem>
</ValueList>
</InsertAction>
<ResultAction ID="InsertResponse" Sig="null">
<ResultsOutput Ref="InsertResponse.Results"/>
</ResultAction>
<ElseAction ID="ElseError" Sig="else"/>
<ResultAction ID="InvalidFunction" Sig="null">
<ResultsOutput Ref="InvalidFunction.Results"/>
</ResultAction>
<ReturnAction ID="Return" Sig="stop"/>
</Actions>
<DataSources>
<DataSource ID="pubradiopledge.fp7">
<DSType>JDBC</DSType>
<DSN>pubradiopledge.fp7</DSN>
<DBMS/>
<Host>pubradiopledge.fp7</Host>
<Database/>
<UserInfo Encrypted="True" Encryption="50">
<UserName>%DF%0FI%A4%3D%A0%2E%DA</UserName>
<Password>%A3%BFfc%1D%81%29r</Password>
</UserInfo>
</DataSource>
</DataSources>
<Outputs>
<Output ID="New_Record_Builder.Header" Type="HTML"><![CDATA[<!DOCTYPE HTML
PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/REC-html40/strict.dtd";>
<html>
<head>
<meta name="security" content="public" />
<meta name="generator" content="Witango Dev Studio" />
<meta name="author" content="Witango New Record Builder" />
<meta name="robots" content="index,follow" />
<meta name="abstract" content="" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<title>New Record Form</title>
</head>
<body>
]]></Output>
<Output ID="New_Record_Builder.Footer" Type="HTML"><![CDATA[</body>
</html>]]></Output>
<Output ID="New_Record_Builder.Response" Type="HTML"><![CDATA[<!DOCTYPE
HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/REC-html40/strict.dtd";>
<html>
<head>
<meta name="security" content="public" />
<meta name="generator" content="Witango Dev Studio" />
<meta name="author" content="Witango New Record Builder" />
<meta name="robots" content="index,follow" />
<meta name="abstract" content="" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<title>New Record Added Results</title>
</head>
<body>
<h2>Record Added</h2>
<p>The record was added successfully.</p>
<p><a href="<@APPFILE>">Add another record</a></p>
</body>
</html>]]></Output>
<Output ID="Form.Results" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/REC-html40/strict.dtd";>
<html>
<head>
<meta name="security" content="public" />
<meta name="generator" content="Witango Dev Studio" />
<meta name="author" content="Witango New Record Builder" />
<meta name="robots" content="index,follow" />
<meta name="abstract" content="" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<title>New Record Form</title>
<style type="text/css">
table { border: 0px solid;
margin: 0px;
padding: 0px;
empty-cells: show; }
table th { border: 0px solid; }
table td { border: 0px solid; }
</style>
</head>
<body>
<form method="post"
action="<@cgi><@appfile>?_function=insert&<@UserReferenceArgument>">
<table>
<tr>
<td>First Name:</td>
<td><input name="pubradiopledge_First Name" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input name="pubradiopledge_Last Name" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>Email:</td>
<td><input name="pubradiopledge_Email" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>Partner/ Spouse First Name:</td>
<td><input name="pubradiopledge_Partner/Spouse First Name" type="text"
size="40" maxLength="0"></td>
</tr>
<tr>
<td>Partner Spouse Last Name:</td>
<td><input name="pubradiopledge_Partner Spouse Last Name" type="text"
size="40" maxLength="0"></td>
</tr>
<tr>
<td>Type of Membership:</td>
<td><select name="pubradiopledge_Type of Membership" size="1">
<option value="New Member" selected="selected">New
Member</option>
<option value="Renewing Member">Renewing Member</option>
<option value="Additional Gift">Additional Gift</option>
</select></td>
</tr>
<tr>
<td>Amount of Pledge:</td>
<td><input name="pubradiopledge_Amount of Pledge" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>One Time Charge?:</td>
<td>
<input name="pubradiopledge_One Time Charge?" type="radio"
value="One Time">Charge this amount one time
<input name="pubradiopledge_One Time Charge?" type="radio"
value="Installments">Break this amount into 10 installments
<input name="pubradiopledge_One Time Charge?" type="radio"
value="Sustaining">Charge each month (create a sustaining plan)</td>
</tr>
<tr>
<td>Type of Payment:</td>
<td><select name="pubradiopledge_Type of Payment" size="1">
<option value="" selected="selected">Select
type...</option>
<option value="Visa">Visa</option>
<option value="Mastercard">Mastercard</option>
<option value="Discover">Discover</option>
<option value="American Express">American
Express</option>
<option value="Please Bill ">Please Bill Me</option>
</select></td>
</tr>
<tr>
<td>Credit Card Number:</td>
<td><input name="pubradiopledge_Credit Card Number" type="text"
size="40" maxLength="0"></td>
</tr>
<tr>
<td>Expiration Month:</td>
<td><select name="pubradiopledge_Expiration Month" size="1">
<option value="">Select Month</option>
<option value="1">1</option>
</select></td>
</tr>
<tr>
<td>Expiration Year:</td>
<td><select name="pubradiopledge_Expiration Year" size="1">
<option value="" selected="selected">Select
Year</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
</select></td>
</tr>
<tr>
<td>Cardholders Name:</td>
<td><input name="pubradiopledge_Cardholders Name" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>Street Address:</td>
<td><input name="pubradiopledge_Street Address" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>Street Address 2:</td>
<td><input name="pubradiopledge_Street Address 2" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>City:</td>
<td><input name="pubradiopledge_City" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>State:</td>
<td><input name="pubradiopledge_State" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>Zip:</td>
<td><input name="pubradiopledge_Zip" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>Daytime Phone:</td>
<td><input name="pubradiopledge_Daytime Phone" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>Comments:</td>
<td><input name="pubradiopledge_Comments" type="text" size="40"
maxLength="0"></td>
</tr>
<tr>
<td>May We Thank You On Air?:</td>
<td><select name="pubradiopledge_May We Thank You On Air?" size="1">
<option value="Yes" selected="selected">Yes</option>
<option value="No">No</option>
</select></td>
</tr>
</table>
<input type="submit" value="Save"> <input type="reset" value="Reset Values">
</form>
</body>
</html>
]]></Output>
<Output ID="InsertResponse.Results" Type="HTML"><![CDATA[<!DOCTYPE HTML
PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/REC-html40/strict.dtd";>
<html>
<head>
<meta name="security" content="public" />
<meta name="generator" content="Witango Dev Studio" />
<meta name="author" content="Witango New Record Builder" />
<meta name="robots" content="index,follow" />
<meta name="abstract" content="" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<title>New Record Added Results</title>
</head>
<body>
<h2>Record Added</h2>
<p>The record was added successfully.</p>
<p><a href="<@APPFILE>">Add another record</a></p>
</body>
</html>]]></Output>
<Output ID="InvalidFunction.Results" Type="HTML"><![CDATA[<b>Error: Invalid
function call specified.</b>]]></Output>
</Outputs>
</TAF>
Chuck Leavens
Leavens Media Associates LLC
1919 Riggs Rd
Pittsburgh PA 15129
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe witango-talk" in the body.
