home *** CD-ROM | disk | FTP | other *** search
/ Chip 2000 April / Chip_2000-04_cd.bin / zkuste / Tango / data1.cab / Tango_Tutorials / TangoTutorial / memberupdate.taf < prev    next >
Extensible Markup Language  |  1999-09-21  |  60KB  |  962 lines
  1. <?xml version="1.0" encoding="ISO-8859-1" ?>
  2. <!DOCTYPE TAF SYSTEM "tango.dtd" >
  3. <TAF Version="0x02000001">
  4.     <Comments />
  5.  
  6.     <!--Main program-->
  7.     <Program>
  8.         <ActionRef Ref="Search_Builder">
  9.             <ActionRef Ref="IfForm">
  10.                 <ActionRef Ref="Form" />
  11.             </ActionRef>
  12.             <ActionRef Ref="ElseIfList">
  13.                 <ActionRef Ref="RecordList" />
  14.             </ActionRef>
  15.             <ActionRef Ref="ElseIfDetail">
  16.                 <ActionRef Ref="RecordDetail" />
  17.             </ActionRef>
  18.             <ActionRef Ref="ElseIfUpdate">
  19.                 <ActionRef Ref="IfMissingRequiredField">
  20.                     <ActionRef Ref="MissingFieldsMessage" />
  21.                 </ActionRef>
  22.                 <ActionRef Ref="ElseDoUpdate">
  23.                     <ActionRef Ref="Update1" />
  24.                     <ActionRef Ref="UpdateResponse" />
  25.                 </ActionRef>
  26.             </ActionRef>
  27.             <ActionRef Ref="ElseIfDelete">
  28.                 <ActionRef Ref="Delete" />
  29.                 <ActionRef Ref="DeleteResponse" />
  30.             </ActionRef>
  31.             <ActionRef Ref="ElseError">
  32.                 <ActionRef Ref="InvalidFunction" />
  33.             </ActionRef>
  34.             <ActionRef Ref="Return" />
  35.         </ActionRef>
  36.     </Program>
  37.  
  38.     <!--Program actions-->
  39.     <Actions>
  40.         <SearchBuilderAction UseDevelopmentDataSource="TRUE" DSID="Music" DeploymentDSID="" ID="Search_Builder" Sig="sgrp" Expanded="True">
  41.             <Comments>This file was created entirely by the Search Builder.  No changes have been made outside the Search Builder.</Comments>
  42.             <SearchPageInfo>
  43.                 <SearchPageColumns>
  44.                     <SearchPageColumn DataType="text" Length="20" PrimaryKey="False" Operator="swth">
  45.                         <ColumnName>firstname</ColumnName>
  46.                         <TableName>siteusers</TableName>
  47.                         <TableOwner />
  48.                         <FieldTitle>First Name</FieldTitle>
  49.                         <InputOptions>
  50.                             <InputText Required="False" Width="20" Height="1" MaxLength="20" Scrolling="False" Password="False">
  51.                                 <DefaultValue />
  52.                             </InputText>
  53.                         </InputOptions>
  54.                     </SearchPageColumn>
  55.                     <SearchPageColumn DataType="text" Length="20" PrimaryKey="False" Operator="swth">
  56.                         <ColumnName>lastname</ColumnName>
  57.                         <TableName>siteusers</TableName>
  58.                         <TableOwner />
  59.                         <FieldTitle>Last Name</FieldTitle>
  60.                         <InputOptions>
  61.                             <InputText Required="False" Width="20" Height="1" MaxLength="20" Scrolling="False" Password="False">
  62.                                 <DefaultValue />
  63.                             </InputText>
  64.                         </InputOptions>
  65.                     </SearchPageColumn>
  66.                     <SearchPageColumn DataType="text" Length="20" PrimaryKey="False" Operator="swth">
  67.                         <ColumnName>login_id</ColumnName>
  68.                         <TableName>siteusers</TableName>
  69.                         <TableOwner />
  70.                         <FieldTitle>Login ID</FieldTitle>
  71.                         <InputOptions>
  72.                             <InputText Required="False" Width="20" Height="1" MaxLength="20" Scrolling="False" Password="False">
  73.                                 <DefaultValue />
  74.                             </InputText>
  75.                         </InputOptions>
  76.                     </SearchPageColumn>
  77.                     <SearchPageColumn DataType="text" Length="25" PrimaryKey="False" Operator="swth">
  78.                         <ColumnName>company</ColumnName>
  79.                         <TableName>siteusers</TableName>
  80.                         <TableOwner />
  81.                         <FieldTitle>Company</FieldTitle>
  82.                         <InputOptions>
  83.                             <InputText Required="False" Width="25" Height="1" MaxLength="25" Scrolling="False" Password="False">
  84.                                 <DefaultValue />
  85.                             </InputText>
  86.                         </InputOptions>
  87.                     </SearchPageColumn>
  88.                     <SearchPageColumn DataType="text" Length="25" PrimaryKey="False" Operator="swth">
  89.                         <ColumnName>city</ColumnName>
  90.                         <TableName>siteusers</TableName>
  91.                         <TableOwner />
  92.                         <FieldTitle>City</FieldTitle>
  93.                         <InputOptions>
  94.                             <InputText Required="False" Width="25" Height="1" MaxLength="25" Scrolling="False" Password="False">
  95.                                 <DefaultValue />
  96.                             </InputText>
  97.                         </InputOptions>
  98.                     </SearchPageColumn>
  99.                 </SearchPageColumns>
  100.                 <PageFormat Border="0" BorderColor="default" BackgroundColor="default" CellPadding="default" CellSpacing="default" />
  101.                 <HeaderOutput Ref="Search_Builder.SearchHeader" />
  102.                 <FooterOutput Ref="Search_Builder.SearchFooter" />
  103.                 <FindButtonTitle>Find</FindButtonTitle>
  104.                 <ResetButtonTitle>Reset Values</ResetButtonTitle>
  105.             </SearchPageInfo>
  106.             <ListPageInfo MaxRows="10" MultiPage="True">
  107.                 <ListPageColumns>
  108.                     <ListPageColumn DataType="text" Length="20" PrimaryKey="False">
  109.                         <ColumnName>firstname</ColumnName>
  110.                         <TableName>siteusers</TableName>
  111.                         <TableOwner />
  112.                         <FieldTitle>First Name</FieldTitle>
  113.                         <DisplayOptions>
  114.                             <DisplayNormal LineBreaks="False" Format="None" />
  115.                         </DisplayOptions>
  116.                     </ListPageColumn>
  117.                     <ListPageColumn DataType="text" Length="20" PrimaryKey="False">
  118.                         <ColumnName>lastname</ColumnName>
  119.                         <TableName>siteusers</TableName>
  120.                         <TableOwner />
  121.                         <FieldTitle>Last Name</FieldTitle>
  122.                         <DisplayOptions>
  123.                             <DisplayDetailLink Format="None" />
  124.                         </DisplayOptions>
  125.                     </ListPageColumn>
  126.                     <ListPageColumn DataType="text" Length="20" PrimaryKey="False">
  127.                         <ColumnName>login_id</ColumnName>
  128.                         <TableName>siteusers</TableName>
  129.                         <TableOwner />
  130.                         <FieldTitle>Login ID</FieldTitle>
  131.                         <DisplayOptions>
  132.                             <DisplayNormal LineBreaks="False" Format="None" />
  133.                         </DisplayOptions>
  134.                     </ListPageColumn>
  135.                     <ListPageColumn DataType="text" Length="25" PrimaryKey="False">
  136.                         <ColumnName>company</ColumnName>
  137.                         <TableName>siteusers</TableName>
  138.                         <TableOwner />
  139.                         <FieldTitle>Company</FieldTitle>
  140.                         <DisplayOptions>
  141.                             <DisplayNormal LineBreaks="False" Format="None" />
  142.                         </DisplayOptions>
  143.                     </ListPageColumn>
  144.                     <ListPageColumn DataType="text" Length="30" PrimaryKey="False">
  145.                         <ColumnName>address</ColumnName>
  146.                         <TableName>siteusers</TableName>
  147.                         <TableOwner />
  148.                         <FieldTitle>Address</FieldTitle>
  149.                         <DisplayOptions>
  150.                             <DisplayNormal LineBreaks="False" Format="None" />
  151.                         </DisplayOptions>
  152.                     </ListPageColumn>
  153.                     <ListPageColumn DataType="text" Length="25" PrimaryKey="False">
  154.                         <ColumnName>city</ColumnName>
  155.                         <TableName>siteusers</TableName>
  156.                         <TableOwner />
  157.                         <FieldTitle>City</FieldTitle>
  158.                         <DisplayOptions>
  159.                             <DisplayNormal LineBreaks="False" Format="None" />
  160.                         </DisplayOptions>
  161.                     </ListPageColumn>
  162.                 </ListPageColumns>
  163.                 <OrderColumns>
  164.                     <OrderColumn Ascending="True">
  165.                         <TableOwner />
  166.                         <TableName>siteusers</TableName>
  167.                         <ColumnName>lastname</ColumnName>
  168.                     </OrderColumn>
  169.                 </OrderColumns>
  170.                 <PageFormat Border="1" BorderColor="default" BackgroundColor="default" CellPadding="default" CellSpacing="default" />
  171.                 <HeaderOutput Ref="Search_Builder.ListHeader" />
  172.                 <FooterOutput Ref="Search_Builder.ListFooter" />
  173.                 <NoResultsOutput Ref="Search_Builder.ListNoResults" />
  174.             </ListPageInfo>
  175.             <DetailsPageInfo>
  176.                 <DetailsPageColumns>
  177.                     <DetailsPageColumn DataType="long" Length="4" PrimaryKey="True">
  178.                         <ColumnName>siteusers_key</ColumnName>
  179.                         <TableName>siteusers</TableName>
  180.                         <TableOwner />
  181.                         <FieldTitle>Siteusers key</FieldTitle>
  182.                         <DisplayOptions>
  183.                             <DisplayNormal LineBreaks="False" Format="None" />
  184.                         </DisplayOptions>
  185.                     </DetailsPageColumn>
  186.                     <DetailsPageColumn DataType="text" Length="20" PrimaryKey="False">
  187.                         <ColumnName>login_id</ColumnName>
  188.                         <TableName>siteusers</TableName>
  189.                         <TableOwner />
  190.                         <FieldTitle>Login id</FieldTitle>
  191.                         <InputOptions>
  192.                             <InputText Required="True" Width="20" Height="1" MaxLength="20" Scrolling="False" Password="False">
  193.                                 <DefaultValue />
  194.                             </InputText>
  195.                         </InputOptions>
  196.                     </DetailsPageColumn>
  197.                     <DetailsPageColumn DataType="text" Length="20" PrimaryKey="False">
  198.                         <ColumnName>passwd</ColumnName>
  199.                         <TableName>siteusers</TableName>
  200.                         <TableOwner />
  201.                         <FieldTitle>Passwd</FieldTitle>
  202.                         <InputOptions>
  203.                             <InputText Required="True" Width="20" Height="1" MaxLength="20" Scrolling="False" Password="False">
  204.                                 <DefaultValue />
  205.                             </InputText>
  206.                         </InputOptions>
  207.                     </DetailsPageColumn>
  208.                     <DetailsPageColumn DataType="shor" Length="2" PrimaryKey="False">
  209.                         <ColumnName>ulevel</ColumnName>
  210.                         <TableName>siteusers</TableName>
  211.                         <TableOwner />
  212.                         <FieldTitle>Ulevel</FieldTitle>
  213.                         <InputOptions>
  214.                             <InputText Required="True" Width="10" Height="1" MaxLength="30" Scrolling="False" Password="False">
  215.                                 <DefaultValue />
  216.                             </InputText>
  217.                         </InputOptions>
  218.                     </DetailsPageColumn>
  219.                     <DetailsPageColumn DataType="text" Length="20" PrimaryKey="False">
  220.                         <ColumnName>firstname</ColumnName>
  221.                         <TableName>siteusers</TableName>
  222.                         <TableOwner />
  223.                         <FieldTitle>Firstname</FieldTitle>
  224.                         <InputOptions>
  225.                             <InputText Required="True" Width="20" Height="1" MaxLength="20" Scrolling="False" Password="False">
  226.                                 <DefaultValue />
  227.                             </InputText>
  228.                         </InputOptions>
  229.                     </DetailsPageColumn>
  230.                     <DetailsPageColumn DataType="text" Length="20" PrimaryKey="False">
  231.                         <ColumnName>lastname</ColumnName>
  232.                         <TableName>siteusers</TableName>
  233.                         <TableOwner />
  234.                         <FieldTitle>Lastname</FieldTitle>
  235.                         <InputOptions>
  236.                             <InputText Required="True" Width="20" Height="1" MaxLength="20" Scrolling="False" Password="False">
  237.                                 <DefaultValue />
  238.                             </InputText>
  239.                         </InputOptions>
  240.                     </DetailsPageColumn>
  241.                     <DetailsPageColumn DataType="text" Length="25" PrimaryKey="False">
  242.                         <ColumnName>company</ColumnName>
  243.                         <TableName>siteusers</TableName>
  244.                         <TableOwner />
  245.                         <FieldTitle>Company</FieldTitle>
  246.                         <InputOptions>
  247.                             <InputText Required="False" Width="25" Height="1" MaxLength="25" Scrolling="False" Password="False">
  248.                                 <DefaultValue />
  249.                             </InputText>
  250.                         </InputOptions>
  251.                     </DetailsPageColumn>
  252.                     <DetailsPageColumn DataType="text" Length="30" PrimaryKey="False">
  253.                         <ColumnName>address</ColumnName>
  254.                         <TableName>siteusers</TableName>
  255.                         <TableOwner />
  256.                         <FieldTitle>Address</FieldTitle>
  257.                         <InputOptions>
  258.                             <InputText Required="True" Width="30" Height="1" MaxLength="30" Scrolling="False" Password="False">
  259.                                 <DefaultValue />
  260.                             </InputText>
  261.                         </InputOptions>
  262.                     </DetailsPageColumn>
  263.                     <DetailsPageColumn DataType="text" Length="25" PrimaryKey="False">
  264.                         <ColumnName>city</ColumnName>
  265.                         <TableName>siteusers</TableName>
  266.                         <TableOwner />
  267.                         <FieldTitle>City</FieldTitle>
  268.                         <InputOptions>
  269.                             <InputText Required="False" Width="25" Height="1" MaxLength="25" Scrolling="False" Password="False">
  270.                                 <DefaultValue />
  271.                             </InputText>
  272.                         </InputOptions>
  273.                     </DetailsPageColumn>
  274.                     <DetailsPageColumn DataType="text" Length="3" PrimaryKey="False">
  275.                         <ColumnName>state_prov</ColumnName>
  276.                         <TableName>siteusers</TableName>
  277.                         <TableOwner />
  278.                         <FieldTitle>State prov</FieldTitle>
  279.                         <InputOptions>
  280.                             <InputText Required="False" Width="3" Height="1" MaxLength="3" Scrolling="False" Password="False">
  281.                                 <DefaultValue />
  282.                             </InputText>
  283.                         </InputOptions>
  284.                     </DetailsPageColumn>
  285.                     <DetailsPageColumn DataType="text" Length="20" PrimaryKey="False">
  286.                         <ColumnName>country</ColumnName>
  287.                         <TableName>siteusers</TableName>
  288.                         <TableOwner />
  289.                         <FieldTitle>Country</FieldTitle>
  290.                         <InputOptions>
  291.                             <InputText Required="False" Width="20" Height="1" MaxLength="20" Scrolling="False" Password="False">
  292.                                 <DefaultValue />
  293.                             </InputText>
  294.                         </InputOptions>
  295.                     </DetailsPageColumn>
  296.                     <DetailsPageColumn DataType="text" Length="10" PrimaryKey="False">
  297.                         <ColumnName>zip_post_code</ColumnName>
  298.                         <TableName>siteusers</TableName>
  299.                         <TableOwner />
  300.                         <FieldTitle>Zip post code</FieldTitle>
  301.                         <InputOptions>
  302.                             <InputText Required="False" Width="10" Height="1" MaxLength="10" Scrolling="False" Password="False">
  303.                                 <DefaultValue />
  304.                             </InputText>
  305.                         </InputOptions>
  306.                     </DetailsPageColumn>
  307.                     <DetailsPageColumn DataType="text" Length="45" PrimaryKey="False">
  308.                         <ColumnName>email</ColumnName>
  309.                         <TableName>siteusers</TableName>
  310.                         <TableOwner />
  311.                         <FieldTitle>Email</FieldTitle>
  312.                         <InputOptions>
  313.                             <InputText Required="True" Width="40" Height="1" MaxLength="45" Scrolling="False" Password="False">
  314.                                 <DefaultValue />
  315.                             </InputText>
  316.                         </InputOptions>
  317.                     </DetailsPageColumn>
  318.                     <DetailsPageColumn DataType="text" Length="15" PrimaryKey="False">
  319.                         <ColumnName>groupname</ColumnName>
  320.                         <TableName>siteusers</TableName>
  321.                         <TableOwner />
  322.                         <FieldTitle>Groupname</FieldTitle>
  323.                         <InputOptions>
  324.                             <InputText Required="False" Width="15" Height="1" MaxLength="15" Scrolling="False" Password="False">
  325.                                 <DefaultValue />
  326.                             </InputText>
  327.                         </InputOptions>
  328.                     </DetailsPageColumn>
  329.                 </DetailsPageColumns>
  330.                 <PageFormat Border="1" BorderColor="default" BackgroundColor="default" CellPadding="default" CellSpacing="default" />
  331.                 <HeaderOutput Ref="Search_Builder.DetailsHeader" />
  332.                 <FooterOutput Ref="Search_Builder.DetailsFooter" />
  333.                 <DeleteResponse Ref="Search_Builder.DetailsDelete" />
  334.                 <UpdateResponse Ref="Search_Builder.DetailsUpdate" />
  335.                 <SaveButtonTitle>Save</SaveButtonTitle>
  336.                 <ResetButtonTitle>Reset Values</ResetButtonTitle>
  337.                 <DeleteButtonTitle>Delete</DeleteButtonTitle>
  338.                 <DeleteFromTable>siteusers</DeleteFromTable>
  339.             </DetailsPageInfo>
  340.         </SearchBuilderAction>
  341.         <IfAction ID="IfForm" Sig="if  ">
  342.             <Expression>(<![CDATA['<@ARG _function>'='sform') or (!LEN('<@ARG _function>'))]]></Expression>
  343.             <ExpressionInfo>
  344.                 <ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
  345.                 <ExpRight>sform</ExpRight>
  346.                 <Operator>iseq</Operator>
  347.             </ExpressionInfo>
  348.             <ExpressionInfo>
  349.                 <ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
  350.                 <ExpRight />
  351.                 <Conjunction>or  </Conjunction>
  352.                 <Operator>iemp</Operator>
  353.             </ExpressionInfo>
  354.         </IfAction>
  355.         <ResultAction ID="Form" Sig="null">
  356.             <ResultsOutput Ref="Form.Results" />
  357.         </ResultAction>
  358.         <ElseIfAction ID="ElseIfList" Sig="elif">
  359.             <Expression>(<![CDATA['<@ARG _function>'='list')]]></Expression>
  360.             <ExpressionInfo>
  361.                 <ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
  362.                 <ExpRight>list</ExpRight>
  363.                 <Operator>iseq</Operator>
  364.             </ExpressionInfo>
  365.         </ElseIfAction>
  366.         <SearchAction TotalRows="True" UseDevelopmentDataSource="TRUE" DSID="Music" DeploymentDSID="" ID="RecordList" Sig="srch">
  367.             <Tables>
  368.                 <TableName>siteusers</TableName>
  369.             </Tables>
  370.             <DataDictionary>
  371.                 <Column DataType="text" ColumnType="0">
  372.                     <TableName>siteusers</TableName>
  373.                     <ColumnName>firstname</ColumnName>
  374.                 </Column>
  375.                 <Column DataType="text" ColumnType="0">
  376.                     <TableName>siteusers</TableName>
  377.                     <ColumnName>lastname</ColumnName>
  378.                 </Column>
  379.                 <Column DataType="text" ColumnType="0">
  380.                     <TableName>siteusers</TableName>
  381.                     <ColumnName>login_id</ColumnName>
  382.                 </Column>
  383.                 <Column DataType="text" ColumnType="0">
  384.                     <TableName>siteusers</TableName>
  385.                     <ColumnName>company</ColumnName>
  386.                 </Column>
  387.                 <Column DataType="text" ColumnType="0">
  388.                     <TableName>siteusers</TableName>
  389.                     <ColumnName>city</ColumnName>
  390.                 </Column>
  391.                 <Column DataType="text" ColumnType="0">
  392.                     <TableName>siteusers</TableName>
  393.                     <ColumnName>address</ColumnName>
  394.                 </Column>
  395.                 <Column DataType="long" ColumnType="0">
  396.                     <TableName>siteusers</TableName>
  397.                     <ColumnName>siteusers_key</ColumnName>
  398.                 </Column>
  399.                 <Column DataType="text" ColumnType="0">
  400.                     <TableName>siteusers</TableName>
  401.                     <ColumnName>passwd</ColumnName>
  402.                 </Column>
  403.                 <Column DataType="shor" ColumnType="0">
  404.                     <TableName>siteusers</TableName>
  405.                     <ColumnName>ulevel</ColumnName>
  406.                 </Column>
  407.                 <Column DataType="text" ColumnType="0">
  408.                     <TableName>siteusers</TableName>
  409.                     <ColumnName>state_prov</ColumnName>
  410.                 </Column>
  411.                 <Column DataType="text" ColumnType="0">
  412.                     <TableName>siteusers</TableName>
  413.                     <ColumnName>country</ColumnName>
  414.                 </Column>
  415.                 <Column DataType="text" ColumnType="0">
  416.                     <TableName>siteusers</TableName>
  417.                     <ColumnName>zip_post_code</ColumnName>
  418.                 </Column>
  419.                 <Column DataType="text" ColumnType="0">
  420.                     <TableName>siteusers</TableName>
  421.                     <ColumnName>email</ColumnName>
  422.                 </Column>
  423.                 <Column DataType="text" ColumnType="0">
  424.                     <TableName>siteusers</TableName>
  425.                     <ColumnName>groupname</ColumnName>
  426.                 </Column>
  427.             </DataDictionary>
  428.             <SearchColumns>
  429.                 <ColumnReference>
  430.                     <TableName>siteusers</TableName>
  431.                     <ColumnName>siteusers_key</ColumnName>
  432.                 </ColumnReference>
  433.                 <ColumnReference>
  434.                     <TableName>siteusers</TableName>
  435.                     <ColumnName>firstname</ColumnName>
  436.                 </ColumnReference>
  437.                 <ColumnReference>
  438.                     <TableName>siteusers</TableName>
  439.                     <ColumnName>lastname</ColumnName>
  440.                 </ColumnReference>
  441.                 <ColumnReference>
  442.                     <TableName>siteusers</TableName>
  443.                     <ColumnName>login_id</ColumnName>
  444.                 </ColumnReference>
  445.                 <ColumnReference>
  446.                     <TableName>siteusers</TableName>
  447.                     <ColumnName>company</ColumnName>
  448.                 </ColumnReference>
  449.                 <ColumnReference>
  450.                     <TableName>siteusers</TableName>
  451.                     <ColumnName>address</ColumnName>
  452.                 </ColumnReference>
  453.                 <ColumnReference>
  454.                     <TableName>siteusers</TableName>
  455.                     <ColumnName>city</ColumnName>
  456.                 </ColumnReference>
  457.             </SearchColumns>
  458.             <OrderColumns>
  459.                 <OrderColumn>
  460.                     <Ascending>True</Ascending>
  461.                     <TableOwner />
  462.                     <TableName>siteusers</TableName>
  463.                     <ColumnName>lastname</ColumnName>
  464.                 </OrderColumn>
  465.             </OrderColumns>
  466.             <Criteria>
  467.                 <CriteriaItem>
  468.                     <Conjunction>none</Conjunction>
  469.                     <TableName>siteusers</TableName>
  470.                     <ColumnName>firstname</ColumnName>
  471.                     <Operator>swth</Operator>
  472.                     <Value><![CDATA[<@ARG firstname>]]></Value>
  473.                     <QuoteValue>true</QuoteValue>
  474.                     <IncludeIfEmpty>false</IncludeIfEmpty>
  475.                 </CriteriaItem>
  476.                 <CriteriaItem>
  477.                     <Conjunction>and </Conjunction>
  478.                     <TableName>siteusers</TableName>
  479.                     <ColumnName>lastname</ColumnName>
  480.                     <Operator>swth</Operator>
  481.                     <Value><![CDATA[<@ARG lastname>]]></Value>
  482.                     <QuoteValue>true</QuoteValue>
  483.                     <IncludeIfEmpty>false</IncludeIfEmpty>
  484.                 </CriteriaItem>
  485.                 <CriteriaItem>
  486.                     <Conjunction>and </Conjunction>
  487.                     <TableName>siteusers</TableName>
  488.                     <ColumnName>login_id</ColumnName>
  489.                     <Operator>swth</Operator>
  490.                     <Value><![CDATA[<@ARG login_id>]]></Value>
  491.                     <QuoteValue>true</QuoteValue>
  492.                     <IncludeIfEmpty>false</IncludeIfEmpty>
  493.                 </CriteriaItem>
  494.                 <CriteriaItem>
  495.                     <Conjunction>and </Conjunction>
  496.                     <TableName>siteusers</TableName>
  497.                     <ColumnName>company</ColumnName>
  498.                     <Operator>swth</Operator>
  499.                     <Value><![CDATA[<@ARG company>]]></Value>
  500.                     <QuoteValue>true</QuoteValue>
  501.                     <IncludeIfEmpty>false</IncludeIfEmpty>
  502.                 </CriteriaItem>
  503.                 <CriteriaItem>
  504.                     <Conjunction>and </Conjunction>
  505.                     <TableName>siteusers</TableName>
  506.                     <ColumnName>city</ColumnName>
  507.                     <Operator>swth</Operator>
  508.                     <Value><![CDATA[<@ARG city>]]></Value>
  509.                     <QuoteValue>true</QuoteValue>
  510.                     <IncludeIfEmpty>false</IncludeIfEmpty>
  511.                 </CriteriaItem>
  512.             </Criteria>
  513.             <StartRow><![CDATA[<@ARG _start>]]></StartRow>
  514.             <MaxRows>10</MaxRows>
  515.             <ResultsOutput Ref="RecordList.Results" />
  516.             <NoResultsOutput Ref="RecordList.NoResults" />
  517.         </SearchAction>
  518.         <ElseIfAction ID="ElseIfDetail" Sig="elif">
  519.             <Expression>(<![CDATA['<@ARG _function>'='detail')]]></Expression>
  520.             <ExpressionInfo>
  521.                 <ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
  522.                 <ExpRight>detail</ExpRight>
  523.                 <Operator>iseq</Operator>
  524.             </ExpressionInfo>
  525.         </ElseIfAction>
  526.         <SearchAction UseDevelopmentDataSource="TRUE" DSID="Music" DeploymentDSID="" ID="RecordDetail" Sig="srch">
  527.             <Tables>
  528.                 <TableName>siteusers</TableName>
  529.             </Tables>
  530.             <DataDictionary>
  531.                 <Column DataType="text" ColumnType="0">
  532.                     <TableName>siteusers</TableName>
  533.                     <ColumnName>firstname</ColumnName>
  534.                 </Column>
  535.                 <Column DataType="text" ColumnType="0">
  536.                     <TableName>siteusers</TableName>
  537.                     <ColumnName>lastname</ColumnName>
  538.                 </Column>
  539.                 <Column DataType="text" ColumnType="0">
  540.                     <TableName>siteusers</TableName>
  541.                     <ColumnName>login_id</ColumnName>
  542.                 </Column>
  543.                 <Column DataType="text" ColumnType="0">
  544.                     <TableName>siteusers</TableName>
  545.                     <ColumnName>company</ColumnName>
  546.                 </Column>
  547.                 <Column DataType="text" ColumnType="0">
  548.                     <TableName>siteusers</TableName>
  549.                     <ColumnName>city</ColumnName>
  550.                 </Column>
  551.                 <Column DataType="text" ColumnType="0">
  552.                     <TableName>siteusers</TableName>
  553.                     <ColumnName>address</ColumnName>
  554.                 </Column>
  555.                 <Column DataType="long" ColumnType="0">
  556.                     <TableName>siteusers</TableName>
  557.                     <ColumnName>siteusers_key</ColumnName>
  558.                 </Column>
  559.                 <Column DataType="text" ColumnType="0">
  560.                     <TableName>siteusers</TableName>
  561.                     <ColumnName>passwd</ColumnName>
  562.                 </Column>
  563.                 <Column DataType="shor" ColumnType="0">
  564.                     <TableName>siteusers</TableName>
  565.                     <ColumnName>ulevel</ColumnName>
  566.                 </Column>
  567.                 <Column DataType="text" ColumnType="0">
  568.                     <TableName>siteusers</TableName>
  569.                     <ColumnName>state_prov</ColumnName>
  570.                 </Column>
  571.                 <Column DataType="text" ColumnType="0">
  572.                     <TableName>siteusers</TableName>
  573.                     <ColumnName>country</ColumnName>
  574.                 </Column>
  575.                 <Column DataType="text" ColumnType="0">
  576.                     <TableName>siteusers</TableName>
  577.                     <ColumnName>zip_post_code</ColumnName>
  578.                 </Column>
  579.                 <Column DataType="text" ColumnType="0">
  580.                     <TableName>siteusers</TableName>
  581.                     <ColumnName>email</ColumnName>
  582.                 </Column>
  583.                 <Column DataType="text" ColumnType="0">
  584.                     <TableName>siteusers</TableName>
  585.                     <ColumnName>groupname</ColumnName>
  586.                 </Column>
  587.             </DataDictionary>
  588.             <SearchColumns>
  589.                 <ColumnReference>
  590.                     <TableName>siteusers</TableName>
  591.                     <ColumnName>siteusers_key</ColumnName>
  592.                 </ColumnReference>
  593.                 <ColumnReference>
  594.                     <TableName>siteusers</TableName>
  595.                     <ColumnName>login_id</ColumnName>
  596.                 </ColumnReference>
  597.                 <ColumnReference>
  598.                     <TableName>siteusers</TableName>
  599.                     <ColumnName>passwd</ColumnName>
  600.                 </ColumnReference>
  601.                 <ColumnReference>
  602.                     <TableName>siteusers</TableName>
  603.                     <ColumnName>ulevel</ColumnName>
  604.                 </ColumnReference>
  605.                 <ColumnReference>
  606.                     <TableName>siteusers</TableName>
  607.                     <ColumnName>firstname</ColumnName>
  608.                 </ColumnReference>
  609.                 <ColumnReference>
  610.                     <TableName>siteusers</TableName>
  611.                     <ColumnName>lastname</ColumnName>
  612.                 </ColumnReference>
  613.                 <ColumnReference>
  614.                     <TableName>siteusers</TableName>
  615.                     <ColumnName>company</ColumnName>
  616.                 </ColumnReference>
  617.                 <ColumnReference>
  618.                     <TableName>siteusers</TableName>
  619.                     <ColumnName>address</ColumnName>
  620.                 </ColumnReference>
  621.                 <ColumnReference>
  622.                     <TableName>siteusers</TableName>
  623.                     <ColumnName>city</ColumnName>
  624.                 </ColumnReference>
  625.                 <ColumnReference>
  626.                     <TableName>siteusers</TableName>
  627.                     <ColumnName>state_prov</ColumnName>
  628.                 </ColumnReference>
  629.                 <ColumnReference>
  630.                     <TableName>siteusers</TableName>
  631.                     <ColumnName>country</ColumnName>
  632.                 </ColumnReference>
  633.                 <ColumnReference>
  634.                     <TableName>siteusers</TableName>
  635.                     <ColumnName>zip_post_code</ColumnName>
  636.                 </ColumnReference>
  637.                 <ColumnReference>
  638.                     <TableName>siteusers</TableName>
  639.                     <ColumnName>email</ColumnName>
  640.                 </ColumnReference>
  641.                 <ColumnReference>
  642.                     <TableName>siteusers</TableName>
  643.                     <ColumnName>groupname</ColumnName>
  644.                 </ColumnReference>
  645.             </SearchColumns>
  646.             <Criteria>
  647.                 <CriteriaItem>
  648.                     <Conjunction>none</Conjunction>
  649.                     <TableName>siteusers</TableName>
  650.                     <ColumnName>siteusers_key</ColumnName>
  651.                     <Operator>iseq</Operator>
  652.                     <Value><![CDATA[<@ARG siteusers_uid1>]]></Value>
  653.                     <QuoteValue>false</QuoteValue>
  654.                     <IncludeIfEmpty>false</IncludeIfEmpty>
  655.                 </CriteriaItem>
  656.             </Criteria>
  657.             <MaxRows>1</MaxRows>
  658.             <ResultsOutput Ref="RecordDetail.Results" />
  659.         </SearchAction>
  660.         <ElseIfAction ID="ElseIfUpdate" Sig="elif">
  661.             <Expression>(<![CDATA['<@ARG _function>'='update')]]></Expression>
  662.             <ExpressionInfo>
  663.                 <ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
  664.                 <ExpRight>update</ExpRight>
  665.                 <Operator>iseq</Operator>
  666.             </ExpressionInfo>
  667.         </ElseIfAction>
  668.         <IfAction ID="IfMissingRequiredField" Sig="if  ">
  669.             <Expression>(!LEN(<![CDATA['<@ARG login_id>')) or (!LEN('<@ARG passwd>')) or (!LEN('<@ARG ulevel>')) or (!LEN('<@ARG firstname>')) or (!LEN('<@ARG lastname>')) or (!LEN('<@ARG address>')) or (!LEN('<@ARG email>'))]]></Expression>
  670.             <ExpressionInfo>
  671.                 <ExpLeft><![CDATA[<@ARG login_id>]]></ExpLeft>
  672.                 <ExpRight />
  673.                 <Operator>iemp</Operator>
  674.             </ExpressionInfo>
  675.             <ExpressionInfo>
  676.                 <ExpLeft><![CDATA[<@ARG passwd>]]></ExpLeft>
  677.                 <ExpRight />
  678.                 <Conjunction>or  </Conjunction>
  679.                 <Operator>iemp</Operator>
  680.             </ExpressionInfo>
  681.             <ExpressionInfo>
  682.                 <ExpLeft><![CDATA[<@ARG ulevel>]]></ExpLeft>
  683.                 <ExpRight />
  684.                 <Conjunction>or  </Conjunction>
  685.                 <Operator>iemp</Operator>
  686.             </ExpressionInfo>
  687.             <ExpressionInfo>
  688.                 <ExpLeft><![CDATA[<@ARG firstname>]]></ExpLeft>
  689.                 <ExpRight />
  690.                 <Conjunction>or  </Conjunction>
  691.                 <Operator>iemp</Operator>
  692.             </ExpressionInfo>
  693.             <ExpressionInfo>
  694.                 <ExpLeft><![CDATA[<@ARG lastname>]]></ExpLeft>
  695.                 <ExpRight />
  696.                 <Conjunction>or  </Conjunction>
  697.                 <Operator>iemp</Operator>
  698.             </ExpressionInfo>
  699.             <ExpressionInfo>
  700.                 <ExpLeft><![CDATA[<@ARG address>]]></ExpLeft>
  701.                 <ExpRight />
  702.                 <Conjunction>or  </Conjunction>
  703.                 <Operator>iemp</Operator>
  704.             </ExpressionInfo>
  705.             <ExpressionInfo>
  706.                 <ExpLeft><![CDATA[<@ARG email>]]></ExpLeft>
  707.                 <ExpRight />
  708.                 <Conjunction>or  </Conjunction>
  709.                 <Operator>iemp</Operator>
  710.             </ExpressionInfo>
  711.         </IfAction>
  712.         <ResultAction ID="MissingFieldsMessage" Sig="null">
  713.             <ResultsOutput Ref="MissingFieldsMessage.Results" />
  714.         </ResultAction>
  715.         <ElseAction ID="ElseDoUpdate" Sig="else" />
  716.         <UpdateAction UseDevelopmentDataSource="TRUE" DSID="Music" DeploymentDSID="" ID="Update1" Sig="updt" AutoCommit="True">
  717.             <Tables>
  718.                 <TableName>siteusers</TableName>
  719.             </Tables>
  720.             <DataDictionary>
  721.                 <Column DataType="long" ColumnType="0">
  722.                     <TableName>siteusers</TableName>
  723.                     <ColumnName>siteusers_key</ColumnName>
  724.                 </Column>
  725.                 <Column DataType="text" ColumnType="0">
  726.                     <TableName>siteusers</TableName>
  727.                     <ColumnName>login_id</ColumnName>
  728.                 </Column>
  729.                 <Column DataType="text" ColumnType="0">
  730.                     <TableName>siteusers</TableName>
  731.                     <ColumnName>passwd</ColumnName>
  732.                 </Column>
  733.                 <Column DataType="shor" ColumnType="0">
  734.                     <TableName>siteusers</TableName>
  735.                     <ColumnName>ulevel</ColumnName>
  736.                 </Column>
  737.                 <Column DataType="text" ColumnType="0">
  738.                     <TableName>siteusers</TableName>
  739.                     <ColumnName>firstname</ColumnName>
  740.                 </Column>
  741.                 <Column DataType="text" ColumnType="0">
  742.                     <TableName>siteusers</TableName>
  743.                     <ColumnName>lastname</ColumnName>
  744.                 </Column>
  745.                 <Column DataType="text" ColumnType="0">
  746.                     <TableName>siteusers</TableName>
  747.                     <ColumnName>company</ColumnName>
  748.                 </Column>
  749.                 <Column DataType="text" ColumnType="0">
  750.                     <TableName>siteusers</TableName>
  751.                     <ColumnName>address</ColumnName>
  752.                 </Column>
  753.                 <Column DataType="text" ColumnType="0">
  754.                     <TableName>siteusers</TableName>
  755.                     <ColumnName>city</ColumnName>
  756.                 </Column>
  757.                 <Column DataType="text" ColumnType="0">
  758.                     <TableName>siteusers</TableName>
  759.                     <ColumnName>state_prov</ColumnName>
  760.                 </Column>
  761.                 <Column DataType="text" ColumnType="0">
  762.                     <TableName>siteusers</TableName>
  763.                     <ColumnName>country</ColumnName>
  764.                 </Column>
  765.                 <Column DataType="text" ColumnType="0">
  766.                     <TableName>siteusers</TableName>
  767.                     <ColumnName>zip_post_code</ColumnName>
  768.                 </Column>
  769.                 <Column DataType="text" ColumnType="0">
  770.                     <TableName>siteusers</TableName>
  771.                     <ColumnName>email</ColumnName>
  772.                 </Column>
  773.                 <Column DataType="text" ColumnType="0">
  774.                     <TableName>siteusers</TableName>
  775.                     <ColumnName>groupname</ColumnName>
  776.                 </Column>
  777.             </DataDictionary>
  778.             <Criteria>
  779.                 <CriteriaItem>
  780.                     <Conjunction>none</Conjunction>
  781.                     <TableName>siteusers</TableName>
  782.                     <ColumnName>siteusers_key</ColumnName>
  783.                     <Operator>iseq</Operator>
  784.                     <Value><![CDATA[<@ARG siteusers_uid1>]]></Value>
  785.                     <QuoteValue>false</QuoteValue>
  786.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  787.                 </CriteriaItem>
  788.             </Criteria>
  789.             <ValueList>
  790.                 <ValueItem>
  791.                     <Name>login_id</Name>
  792.                     <Value><![CDATA[<@ARG login_id>]]></Value>
  793.                     <QuoteValue>true</QuoteValue>
  794.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  795.                     <NullValue>false</NullValue>
  796.                 </ValueItem>
  797.                 <ValueItem>
  798.                     <Name>passwd</Name>
  799.                     <Value><![CDATA[<@ARG passwd>]]></Value>
  800.                     <QuoteValue>true</QuoteValue>
  801.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  802.                     <NullValue>false</NullValue>
  803.                 </ValueItem>
  804.                 <ValueItem>
  805.                     <Name>ulevel</Name>
  806.                     <Value><![CDATA[<@ARG ulevel>]]></Value>
  807.                     <QuoteValue>false</QuoteValue>
  808.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  809.                     <NullValue>false</NullValue>
  810.                 </ValueItem>
  811.                 <ValueItem>
  812.                     <Name>firstname</Name>
  813.                     <Value><![CDATA[<@ARG firstname>]]></Value>
  814.                     <QuoteValue>true</QuoteValue>
  815.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  816.                     <NullValue>false</NullValue>
  817.                 </ValueItem>
  818.                 <ValueItem>
  819.                     <Name>lastname</Name>
  820.                     <Value><![CDATA[<@ARG lastname>]]></Value>
  821.                     <QuoteValue>true</QuoteValue>
  822.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  823.                     <NullValue>false</NullValue>
  824.                 </ValueItem>
  825.                 <ValueItem>
  826.                     <Name>company</Name>
  827.                     <Value><![CDATA[<@ARG company>]]></Value>
  828.                     <QuoteValue>true</QuoteValue>
  829.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  830.                     <NullValue>false</NullValue>
  831.                 </ValueItem>
  832.                 <ValueItem>
  833.                     <Name>address</Name>
  834.                     <Value><![CDATA[<@ARG address>]]></Value>
  835.                     <QuoteValue>true</QuoteValue>
  836.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  837.                     <NullValue>false</NullValue>
  838.                 </ValueItem>
  839.                 <ValueItem>
  840.                     <Name>city</Name>
  841.                     <Value><![CDATA[<@ARG city>]]></Value>
  842.                     <QuoteValue>true</QuoteValue>
  843.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  844.                     <NullValue>false</NullValue>
  845.                 </ValueItem>
  846.                 <ValueItem>
  847.                     <Name>state_prov</Name>
  848.                     <Value><![CDATA[<@ARG state_prov>]]></Value>
  849.                     <QuoteValue>true</QuoteValue>
  850.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  851.                     <NullValue>false</NullValue>
  852.                 </ValueItem>
  853.                 <ValueItem>
  854.                     <Name>country</Name>
  855.                     <Value><![CDATA[<@ARG country>]]></Value>
  856.                     <QuoteValue>true</QuoteValue>
  857.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  858.                     <NullValue>false</NullValue>
  859.                 </ValueItem>
  860.                 <ValueItem>
  861.                     <Name>zip_post_code</Name>
  862.                     <Value><![CDATA[<@ARG zip_post_code>]]></Value>
  863.                     <QuoteValue>true</QuoteValue>
  864.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  865.                     <NullValue>false</NullValue>
  866.                 </ValueItem>
  867.                 <ValueItem>
  868.                     <Name>email</Name>
  869.                     <Value><![CDATA[<@ARG email>]]></Value>
  870.                     <QuoteValue>true</QuoteValue>
  871.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  872.                     <NullValue>false</NullValue>
  873.                 </ValueItem>
  874.                 <ValueItem>
  875.                     <Name>groupname</Name>
  876.                     <Value><![CDATA[<@ARG groupname>]]></Value>
  877.                     <QuoteValue>true</QuoteValue>
  878.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  879.                     <NullValue>false</NullValue>
  880.                 </ValueItem>
  881.             </ValueList>
  882.         </UpdateAction>
  883.         <ResultAction ID="UpdateResponse" Sig="null">
  884.             <ResultsOutput Ref="UpdateResponse.Results" />
  885.         </ResultAction>
  886.         <ElseIfAction ID="ElseIfDelete" Sig="elif">
  887.             <Expression>(<![CDATA['<@ARG _function>'='delete')]]></Expression>
  888.             <ExpressionInfo>
  889.                 <ExpLeft><![CDATA[<@ARG _function>]]></ExpLeft>
  890.                 <ExpRight>delete</ExpRight>
  891.                 <Operator>iseq</Operator>
  892.             </ExpressionInfo>
  893.         </ElseIfAction>
  894.         <DeleteAction UseDevelopmentDataSource="TRUE" DSID="Music" DeploymentDSID="" ID="Delete" Sig="dele" AutoCommit="True">
  895.             <Tables>
  896.                 <TableName>siteusers</TableName>
  897.             </Tables>
  898.             <DataDictionary>
  899.                 <Column DataType="long" ColumnType="0">
  900.                     <TableName>siteusers</TableName>
  901.                     <ColumnName>siteusers_key</ColumnName>
  902.                 </Column>
  903.             </DataDictionary>
  904.             <Criteria>
  905.                 <CriteriaItem>
  906.                     <Conjunction>none</Conjunction>
  907.                     <TableName>siteusers</TableName>
  908.                     <ColumnName>siteusers_key</ColumnName>
  909.                     <Operator>iseq</Operator>
  910.                     <Value><![CDATA[<@ARG siteusers_uid1>]]></Value>
  911.                     <QuoteValue>false</QuoteValue>
  912.                     <IncludeIfEmpty>true</IncludeIfEmpty>
  913.                 </CriteriaItem>
  914.             </Criteria>
  915.         </DeleteAction>
  916.         <ResultAction ID="DeleteResponse" Sig="null">
  917.             <ResultsOutput Ref="DeleteResponse.Results" />
  918.         </ResultAction>
  919.         <ElseAction ID="ElseError" Sig="else" />
  920.         <ResultAction ID="InvalidFunction" Sig="null">
  921.             <ResultsOutput Ref="InvalidFunction.Results" />
  922.         </ResultAction>
  923.         <ReturnAction ID="Return" Sig="stop" />
  924.     </Actions>
  925.  
  926.     <!--Data sources-->
  927.     <DataSources>
  928.         <DataSource ID="Music">
  929.             <DSType>Pervasive.SQL</DSType>
  930.             <DSN>Music</DSN>
  931.             <DBMS />
  932.             <Host>Music</Host>
  933.             <Database />
  934.             <UserInfo Encrypted="True">
  935.                 <UserName />
  936.                 <Password />
  937.             </UserInfo>
  938.         </DataSource>
  939.     </DataSources>
  940.  
  941.     <!--Output blocks-->
  942.     <Outputs>
  943.         <Output ID="Search_Builder.SearchHeader" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>Search Fan Club Members</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>images/_pmusic_logo2.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[</CENTER>]]> <![CDATA[<P>Which Fan Club Member(s) are you looking to update?</P>]]> </Output>
  944.         <Output ID="Search_Builder.SearchFooter" Type="HTML"><![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  945.         <Output ID="Search_Builder.ListHeader" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>Matching Records</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>images/_pmusic_logo2.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[</CENTER>]]> <![CDATA[<P>]]> <![CDATA[<@IF "<@TOTALROWS> = -1">]]> <![CDATA[    There are <B><@NUMROWS></B> matching records.]]> <![CDATA[<@ELSEIF "<@TOTALROWS> != 1">]]> <![CDATA[    There are <B><@TOTALROWS></B> matching records.]]> <![CDATA[    <@IF "<@MAXROWS> > 1">]]> <![CDATA[        <P>Displaying matches ]]> <![CDATA[        <B><@STARTROW></B>]]> <![CDATA[        through    ]]> <![CDATA[        <B><@CALC "<@STARTROW> + <@NUMROWS> - 1">.</B>]]> <![CDATA[    </@IF>]]> <![CDATA[<@ELSE>]]> <![CDATA[    There is <B>1</B> matching record.]]> <![CDATA[</@IF>]]> <![CDATA[</P>]]></Output>
  946.         <Output ID="Search_Builder.ListFooter" Type="HTML"><![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  947.         <Output ID="Search_Builder.ListNoResults" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>No Matching Records</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[    <H2>No Matching Records</H2>]]> <![CDATA[    <P>No records match your search criteria.</P>]]> <![CDATA[    <P><A HREF="<@CGI><@APPFILE>?<@UserReferenceArgument>">Search Again</A></P>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  948.         <Output ID="Search_Builder.DetailsHeader" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>Record Detail</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>images/_pmusic_logo2.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[</CENTER>]]> <![CDATA[<P>Update or delete the Fan Club Member's record as necessary.</P>]]> </Output>
  949.         <Output ID="Search_Builder.DetailsFooter" Type="HTML"><![CDATA[<P><A HREF="<@CGI><@APPFILE>?<@UserReferenceArgument>">Search Again</A></P>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  950.         <Output ID="Search_Builder.DetailsDelete" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[<TITLE>Record Deletion Result</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>images/_pmusic_logo2.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[<@ASSIGN NAME=numAffected VALUE=<@NUMAFFECTED>]]> SCOPE=local<![CDATA[>]]> <![CDATA[<@IF EXPR="(@@numAffected = 1) or (@@numAffected < 0)">]]> <![CDATA[<H2>Record Deleted</H2>]]> <![CDATA[<P>The record was deleted successfully.</P>]]> <![CDATA[<@ELSEIF EXPR="@@numAffected = 0">]]> <![CDATA[<H2>No Records Deleted</H2>]]> <![CDATA[<P>No records were deleted. Perhaps the record has already been deleted.</P>]]> <![CDATA[<@ELSE>]]> <![CDATA[<H2>Multiple Records Deleted</H2>]]> <![CDATA[<P>@@numAffected records were deleted.</P>]]> <![CDATA[</@IF>]]> <![CDATA[<P><A HREF="<@CGI><@APPFILE>?<@UserReferenceArgument>">Search]]> Again<![CDATA[</A</P>]]> <![CDATA[</CENTER>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  951.         <Output ID="Search_Builder.DetailsUpdate" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[<TITLE>Record Update Result</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>images/_pmusic_logo2.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[<@ASSIGN NAME=numAffected VALUE=<@NUMAFFECTED>]]> SCOPE=local<![CDATA[>]]> <![CDATA[<@IF EXPR="(@@numAffected = 1) or (@@numAffected < 0)">]]> <![CDATA[<H2>Record Updated</H2>]]> <![CDATA[<P>The record was updated successfully.</P>]]> <![CDATA[<@ELSEIF EXPR="@@numAffected = 0">]]> <![CDATA[<H2>No Records Updated</H2>]]> <![CDATA[<P>No records were updated. Perhaps the record has been deleted.</P>]]> <![CDATA[<@ELSE>]]> <![CDATA[<H2>Multiple Records Updated</H2>]]> <![CDATA[<P>@@numAffected records were updated.</P>]]> <![CDATA[</@IF>]]> <![CDATA[<P><A HREF="<@CGI><@APPFILE>?<@UserReferenceArgument>">Search]]> Again<![CDATA[</A></P>]]> <![CDATA[</CENTER>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  952.         <Output ID="Form.Results" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>Search Fan Club Members</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>resources/logo.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[</CENTER>]]> <![CDATA[<P>Which Fan Club Member(s) are you looking to update?</P>]]> <![CDATA[<FORM METHOD="POST" ACTION="<@CGI><@APPFILE>?_function=list&<@UserReferenceArgument>&_start=1">]]> <![CDATA[<TABLE BORDER=0>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        First Name: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="firstname" TYPE=TEXT SIZE=20 MAXLENGTH=20 VALUE="">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Last Name: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="lastname" TYPE=TEXT SIZE=20 MAXLENGTH=20 VALUE="">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Login ID: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="login_id" TYPE=TEXT SIZE=20 MAXLENGTH=20 VALUE="">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Company: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="company" TYPE=TEXT SIZE=25 MAXLENGTH=25 VALUE="">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        City: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="city" TYPE=TEXT SIZE=25 MAXLENGTH=25 VALUE="">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[</TABLE>]]> <![CDATA[<INPUT TYPE=SUBMIT VALUE="Find"> <INPUT TYPE=RESET VALUE="Reset Values"> ]]> <![CDATA[</FORM>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]> </Output>
  953.         <Output ID="RecordList.Results" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>Matching Records</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>resources/logo.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[</CENTER>]]> <![CDATA[<P>]]> <![CDATA[<@IF "<@TOTALROWS> = -1">]]> <![CDATA[    There are <B><@NUMROWS></B> matching records.]]> <![CDATA[<@ELSEIF "<@TOTALROWS> != 1">]]> <![CDATA[    There are <B><@TOTALROWS></B> matching records.]]> <![CDATA[    <@IF "<@MAXROWS> > 1">]]> <![CDATA[        <P>Displaying matches ]]> <![CDATA[        <B><@STARTROW></B>]]> <![CDATA[        through    ]]> <![CDATA[        <B><@CALC "<@STARTROW> + <@NUMROWS> - 1">.</B>]]> <![CDATA[    </@IF>]]> <![CDATA[<@ELSE>]]> <![CDATA[    There is <B>1</B> matching record.]]> <![CDATA[</@IF>]]> <![CDATA[</P>]]> <![CDATA[<TABLE BORDER=1>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        <B>First Name</B>]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <B>Last Name</B>]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <B>Login ID</B>]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <B>Company</B>]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <B>Address</B>]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <B>City</B>]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<@ROWS>]]> <![CDATA[<TR VALIGN=TOP>]]> <![CDATA[    <TD>]]> <![CDATA[        <@COLUMN "siteusers.firstname">]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <A HREF="<@CGI><@APPFILE>?_function=detail&siteusers_uid1=<@COLUMN "siteusers.siteusers_key" ENCODING=URL>&<@UserReferenceArgument>"><@COLUMN "siteusers.lastname"></A>]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <@COLUMN "siteusers.login_id">]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <@COLUMN "siteusers.company">]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <@COLUMN "siteusers.address">]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <@COLUMN "siteusers.city">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[</@ROWS>]]> <![CDATA[</TABLE>]]> <![CDATA[<P>]]> <![CDATA[<@COMMENT>]]> <![CDATA[    ----- BEGIN  NEXT/PREV BUTTONS -----]]> <![CDATA[</@COMMENT>]]> <![CDATA[<@IF "<@MAXROWS> > 0">]]> <![CDATA[    <@COMMENT>]]> <![CDATA[        If a max. number of records was specified, show Next and/or Previous buttons.]]> <![CDATA[    </@COMMENT>]]> <![CDATA[    <@COMMENT>]]> <![CDATA[        ----- BUILD SEARCH VALUES  -----]]> <![CDATA[        The Next and Previous buttons must pass to Tango all the search values entered by the user. This]]> <![CDATA[        section loops through all the args received -- via form fields (postargs) and the URL (searchargs) --]]> <![CDATA[        and creates hidden form fields for them. The resulting HTML is used in the form for each button.]]> <![CDATA[    </@COMMENT>]]> <![CDATA[    <@ASSIGN arg_names <@ARGNAMES> SCOPE=LOCAL>]]> <![CDATA[    <@ASSIGN search_vals_HTML "" SCOPE=LOCAL>]]> <![CDATA[    <@ASSIGN crlf "<@CHAR 13><@CHAR 10>" SCOPE=LOCAL>    <@COMMENT>line ending</@COMMENT>]]> <![CDATA[    <@ROWS ARRAY=arg_names>]]> <![CDATA[        <@ASSIGN arg_name "<@COL 1>" SCOPE=LOCAL>]]> <![CDATA[        <@IF "'<@LEFT @@arg_name 1>' != '_'">]]> <![CDATA[            <@COMMENT> Ignore args beginning with '_'; they'll be passed manually.</@COMMENT>]]> <![CDATA[            <@ASSIGN arg_values "<@ARG @@arg_name TYPE=ARRAY>" SCOPE=LOCAL>]]> <![CDATA[            <@COMMENT>]]> <![CDATA[                Assign the current argument's values to a variable. Use]]> <![CDATA[                TYPE=ARRAY to get all the values for multi-select lists.]]> <![CDATA[            </@COMMENT>]]> <![CDATA[            <@ROWS ARRAY=arg_values>]]> <![CDATA[                <@COMMENT>]]> <![CDATA[                    Loop through all the values for the current arg. Build a hidden form field for each.]]> <![CDATA[                    Append field HTML to existing HTML.]]> <![CDATA[                </@COMMENT>]]> <![CDATA[                <@ASSIGN search_vals_HTML '@@search_vals_HTML<INPUT TYPE="HIDDEN" NAME="<@VAR arg_name>" VALUE="<@COL 1>">@@crlf' SCOPE=LOCAL>]]> <![CDATA[            </@ROWS>]]> <![CDATA[        </@IF>    <@COMMENT>End ignoring args beginning with _ </@COMMENT>]]> <![CDATA[    </@ROWS>]]> <![CDATA[    <@COMMENT>]]> <![CDATA[        ----- END BUILD SEARCH VALUES -----]]> <![CDATA[    </@COMMENT>]]> <![CDATA[    <TABLE BORDER=0>]]> <![CDATA[    <TR>]]> <![CDATA[    <@COMMENT>]]> <![CDATA[        ----- PREVIOUS BUTTON -----]]> <![CDATA[    </@COMMENT>]]> <![CDATA[    <TD>]]> <![CDATA[    <@IF "<@STARTROW> != 1">]]> <![CDATA[        <@COMMENT>]]> <![CDATA[        We are beyond the first match; we need a Previous button]]> <![CDATA[        </@COMMENT>]]> <![CDATA[        <@ASSIGN new_start <@CALC "<@STARTROW> - <@MAXROWS>"> SCOPE=LOCAL>]]> <![CDATA[        <@ASSIGN new_start <@CALC "max(@@new_start 1)"> SCOPE=LOCAL>]]> <![CDATA[        <@COMMENT>]]> <![CDATA[            Subtract the max. number of rows per page from the current start]]> <![CDATA[            to get new start. Use 1 if it's less than 1.]]> <![CDATA[        </@COMMENT>]]> <![CDATA[        <FORM METHOD="POST" ACTION="<@CGI><@APPFILE>?_function=list&_start=@@new_start&<@UserReferenceArgument>">]]> <![CDATA[        <@VAR search_vals_HTML ENCODING=NONE>]]> <![CDATA[        <@COMMENT> Hidden fields containing original search values</@COMMENT>]]> <![CDATA[        <@IF "<@STARTROW> > <@MAXROWS>">]]> <![CDATA[            <@ASSIGN num_on_prev_page <@MAXROWS> SCOPE=LOCAL>]]> <![CDATA[        <@ELSE>]]> <![CDATA[            <@ASSIGN num_on_prev_page <@CALC <@STARTROW>-1> SCOPE=LOCAL>]]> <![CDATA[        </@IF>]]> <![CDATA[        <INPUT TYPE="SUBMIT" VALUE="<@IF "@@num_on_prev_page < <@CALC 'min(<@MAXROWS> <@TOTALROWS>)'>">First <@CALC 'min(<@MAXROWS> <@TOTALROWS>)'><@ELSE>Previous @@num_on_prev_page</@IF> Matches">]]> <![CDATA[        </FORM>]]> <![CDATA[    </@IF>]]> <![CDATA[    </TD>]]> <![CDATA[    <@COMMENT>]]> <![CDATA[        ----- END PREVIOUS BUTTON -----]]> <![CDATA[    </@COMMENT>]]> <![CDATA[    <@COMMENT>]]> <![CDATA[        ----- NEXT BUTTON -----]]> <![CDATA[    </@COMMENT>]]> <![CDATA[    <TD>]]> <![CDATA[    <@ASSIGN rows_left <@CALC "<@TOTALROWS> - (<@STARTROW> + <@MAXROWS> - 1)"> SCOPE=LOCAL>]]> <![CDATA[    <@IF "@@rows_left > 0">]]> <![CDATA[        <@COMMENT>More rows? We need a Next button.</@COMMENT>]]> <![CDATA[        <@ASSIGN new_start <@CALC "<@STARTROW> + <@MAXROWS>"> SCOPE=LOCAL>]]> <![CDATA[        <@COMMENT>Add the max. number of rows per page to the current start to get new start.</@COMMENT>]]> <![CDATA[        <FORM METHOD="POST" ACTION="<@CGI><@APPFILE>?_function=list&_start=@@new_start&<@UserReferenceArgument>">]]> <![CDATA[        <@VAR search_vals_HTML ENCODING=NONE>]]> <![CDATA[        <@COMMENT> Hidden fields containing original search values </@COMMENT>]]> <![CDATA[        <@ASSIGN num_on_next_page <@CALC "min(@@rows_left <@MAXROWS>)"> SCOPE=LOCAL>]]> <![CDATA[        <@COMMENT>]]> <![CDATA[            Number of records on next page is the number]]> <![CDATA[            of rows remaining or the max. per page, whichever is less.]]> <![CDATA[        </@COMMENT>]]> <![CDATA[        <INPUT TYPE="SUBMIT" VALUE="Next @@num_on_next_page Match<@IF "@@num_on_next_page != 1">es</@IF>">]]> <![CDATA[        </FORM>]]> <![CDATA[    </@IF>]]> <![CDATA[    </TD>]]> <![CDATA[    <@COMMENT>]]> <![CDATA[        ----- END NEXT BUTTON -----]]> <![CDATA[    </@COMMENT>]]> <![CDATA[    </TR>]]> <![CDATA[    </TABLE>]]> <![CDATA[</@IF>]]> <![CDATA[<@COMMENT>]]> <![CDATA[    ----- END NEXT/PREV BUTTONS -----]]> <![CDATA[</@COMMENT></BODY>]]> <![CDATA[</HTML>]]> </Output>
  954.         <Output ID="RecordList.NoResults" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>No Matching Records</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<IMG SRC="<@APPFILEPATH>resources/logo.gif">]]> <![CDATA[    <H2>No Matching Records</H2>]]> <![CDATA[    <P>No records match your search criteria.</P>]]> <![CDATA[    <P><A HREF="<@CGI><@APPFILE>?<@UserReferenceArgument>">Search Again</A></P>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  955.         <Output ID="RecordDetail.Results" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>Record Detail</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>resources/logo.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[</CENTER>]]> <![CDATA[<P>Update or delete the Fan Club Member's record as necessary.</P>]]> <![CDATA[<@ROWS>]]> <![CDATA[<FORM METHOD="POST" ACTION="<@CGI><@APPFILE>?_function=update&siteusers_uid1=<@COLUMN "siteusers.siteusers_key" ENCODING=URL>&<@UserReferenceArgument>">]]> <![CDATA[<TABLE BORDER=1>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Siteusers key: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <@COLUMN "siteusers.siteusers_key">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Login id: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="login_id" TYPE=TEXT SIZE=20 MAXLENGTH=20 VALUE="<@COLUMN "siteusers.login_id">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Passwd: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="passwd" TYPE=TEXT SIZE=20 MAXLENGTH=20 VALUE="<@COLUMN "siteusers.passwd">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Ulevel: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="ulevel" TYPE=TEXT SIZE=10 MAXLENGTH=30 VALUE="<@COLUMN "siteusers.ulevel">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Firstname: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="firstname" TYPE=TEXT SIZE=20 MAXLENGTH=20 VALUE="<@COLUMN "siteusers.firstname">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Lastname: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="lastname" TYPE=TEXT SIZE=20 MAXLENGTH=20 VALUE="<@COLUMN "siteusers.lastname">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Company: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="company" TYPE=TEXT SIZE=25 MAXLENGTH=25 VALUE="<@COLUMN "siteusers.company">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Address: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="address" TYPE=TEXT SIZE=30 MAXLENGTH=30 VALUE="<@COLUMN "siteusers.address">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        City: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="city" TYPE=TEXT SIZE=25 MAXLENGTH=25 VALUE="<@COLUMN "siteusers.city">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        State prov: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="state_prov" TYPE=TEXT SIZE=3 MAXLENGTH=3 VALUE="<@COLUMN "siteusers.state_prov">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Country: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="country" TYPE=TEXT SIZE=20 MAXLENGTH=20 VALUE="<@COLUMN "siteusers.country">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Zip post code: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="zip_post_code" TYPE=TEXT SIZE=10 MAXLENGTH=10 VALUE="<@COLUMN "siteusers.zip_post_code">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Email: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="email" TYPE=TEXT SIZE=40 MAXLENGTH=45 VALUE="<@COLUMN "siteusers.email">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[<TR VALIGN=TOP ALIGN=LEFT>]]> <![CDATA[    <TD>]]> <![CDATA[        Groupname: ]]> <![CDATA[    </TD>]]> <![CDATA[    <TD>]]> <![CDATA[        <INPUT NAME="groupname" TYPE=TEXT SIZE=15 MAXLENGTH=15 VALUE="<@COLUMN "siteusers.groupname">">]]> <![CDATA[    </TD>]]> <![CDATA[</TR>]]> <![CDATA[</TABLE>]]> <![CDATA[<INPUT TYPE=SUBMIT VALUE="Save"> <INPUT TYPE=RESET VALUE="Reset Values"> ]]> <![CDATA[</FORM>]]> <![CDATA[<FORM METHOD=GET ACTION="<@CGI><@APPFILE>">]]> <![CDATA[<INPUT TYPE=HIDDEN NAME="_function" VALUE="delete">]]> <![CDATA[<INPUT TYPE=HIDDEN NAME="siteusers_uid1" VALUE="<@COLUMN "siteusers.siteusers_key">">]]> <![CDATA[<INPUT TYPE=HIDDEN NAME="_userReference" VALUE="<@UserReference>">]]> <![CDATA[<INPUT TYPE=SUBMIT VALUE="Delete"> ]]> <![CDATA[</FORM>]]> <![CDATA[</@ROWS>]]> <![CDATA[<P><A HREF="<@CGI><@APPFILE>?<@UserReferenceArgument>">Search Again</A></P>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]> </Output>
  956.         <Output ID="MissingFieldsMessage.Results" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[    <TITLE>Error: Missing Required Fields</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<IMG SRC="<@APPFILEPATH>resources/logo.gif" ALT="Pervasive Music Logo">]]> <![CDATA[<H2>Error: Missing Required Fields</H2>]]> <![CDATA[<P>]]> <![CDATA[    The record could not be updated because the following required fields were left empty:]]> <![CDATA[</P>]]> <![CDATA[<UL TYPE=SQUARE>]]> <![CDATA[<@IFEMPTY <@ARG login_id>>]]> <![CDATA[    <LI>Login id]]> <![CDATA[</@IF>]]> <![CDATA[<@IFEMPTY <@ARG passwd>>]]> <![CDATA[    <LI>Passwd]]> <![CDATA[</@IF>]]> <![CDATA[<@IFEMPTY <@ARG ulevel>>]]> <![CDATA[    <LI>Ulevel]]> <![CDATA[</@IF>]]> <![CDATA[<@IFEMPTY <@ARG firstname>>]]> <![CDATA[    <LI>Firstname]]> <![CDATA[</@IF>]]> <![CDATA[<@IFEMPTY <@ARG lastname>>]]> <![CDATA[    <LI>Lastname]]> <![CDATA[</@IF>]]> <![CDATA[<@IFEMPTY <@ARG address>>]]> <![CDATA[    <LI>Address]]> <![CDATA[</@IF>]]> <![CDATA[<@IFEMPTY <@ARG email>>]]> <![CDATA[    <LI>Email]]> <![CDATA[</@IF>]]> <![CDATA[</UL>]]> <![CDATA[<P>]]> Please go back and enter values for these fields.<![CDATA[</P>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  957.         <Output ID="UpdateResponse.Results" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[<TITLE>Record Update Result</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>resources/logo.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[<@ASSIGN NAME=numAffected VALUE=<@NUMAFFECTED>]]> SCOPE=local<![CDATA[>]]> <![CDATA[<@IF EXPR="(@@numAffected = 1) or (@@numAffected < 0)">]]> <![CDATA[<H2>Record Updated</H2>]]> <![CDATA[<P>The record was updated successfully.</P>]]> <![CDATA[<@ELSEIF EXPR="@@numAffected = 0">]]> <![CDATA[<H2>No Records Updated</H2>]]> <![CDATA[<P>No records were updated. Perhaps the record has been deleted.</P>]]> <![CDATA[<@ELSE>]]> <![CDATA[<H2>Multiple Records Updated</H2>]]> <![CDATA[<P>@@numAffected records were updated.</P>]]> <![CDATA[</@IF>]]> <![CDATA[<P><A HREF="<@CGI><@APPFILE>?<@UserReferenceArgument>">Search]]> Again<![CDATA[</A></P>]]> <![CDATA[</CENTER>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  958.         <Output ID="DeleteResponse.Results" Type="HTML"><![CDATA[<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">]]> <![CDATA[<HTML>]]> <![CDATA[<HEAD>]]> <![CDATA[<TITLE>Record Deletion Result</TITLE>]]> <![CDATA[</HEAD>]]> <![CDATA[<BODY>]]> <![CDATA[<CENTER>]]> <![CDATA[    <IMG SRC="<@APPFILEPATH>resources/logo.gif" ALT="Pervasive Music Logo">]]> <![CDATA[    <H2 ALIGN=CENTER>Fan Club Member Administration</H2>]]> <![CDATA[<@ASSIGN NAME=numAffected VALUE=<@NUMAFFECTED>]]> SCOPE=local<![CDATA[>]]> <![CDATA[<@IF EXPR="(@@numAffected = 1) or (@@numAffected < 0)">]]> <![CDATA[<H2>Record Deleted</H2>]]> <![CDATA[<P>The record was deleted successfully.</P>]]> <![CDATA[<@ELSEIF EXPR="@@numAffected = 0">]]> <![CDATA[<H2>No Records Deleted</H2>]]> <![CDATA[<P>No records were deleted. Perhaps the record has already been deleted.</P>]]> <![CDATA[<@ELSE>]]> <![CDATA[<H2>Multiple Records Deleted</H2>]]> <![CDATA[<P>@@numAffected records were deleted.</P>]]> <![CDATA[</@IF>]]> <![CDATA[<P><A HREF="<@CGI><@APPFILE>?<@UserReferenceArgument>">Search]]> Again<![CDATA[</A</P>]]> <![CDATA[</CENTER>]]> <![CDATA[</BODY>]]> <![CDATA[</HTML>]]></Output>
  959.         <Output ID="InvalidFunction.Results" Type="HTML"><![CDATA[<B>Error: Invalid function value specified in CGI call.</B>]]></Output>
  960.     </Outputs>
  961. </TAF>
  962.