Skip to main content
N
naglists1-Visitor
1-Visitor
February 19, 2011
Question

sql server datamerge (7 emails, 6 files total)

  • February 19, 2011
  • 14 replies
  • 2118 views
1 of 7

Hi,
I hacked together a SQL Server datamerge and have now generalized it into a
sample like the Access and Excel ones that install with Editor. (Frankly,
it's better documented if I do say so myself.) I am going to send each of
the six files I've created one at a time as replies to this e-mail.
Eventually, I'll upload it to adepters.org. If you try it and it works (or
doesn't work), please let me know.

--
Paul Nagai

    14 replies

    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    E-mail 2 of 7.

    File 1 of 6. readme.txt:

    This is a SQL Server datamerge setup for axdocbook.

    Paul Nagai
    paul@panaga.com
    20110218

    Datamerge demo files and directory structure:


    sql_server_datamerge.zip Contains everything mentioned below.

    readme.txt. this file.

    sql_server_datamerge.pdf screen caps associated with the
    sql_server_datamerge.doc steps documented in readme.txt.

    docbook_sql_server_datamerge.xml This is an XML instance with
    a resolved datamerge in it.

    hardware_sql.sql Contains hardware_sql database creation
    and data insertion query.

    NOTES:
    * This demo was developed against SQL Server 2005.
    * I had admin access to the server hosting SQL Server.
    * The .sql file could possibly be simplified but I
    quit when it worked.


    Custom Directory files (Arbortext install custom if you dare ... make
    backups of any files you need to replace OR set APTCUSTOM to something
    else, e.g. c:\datamerge):

    datamerge directory
    sql.dmf The datamerge configuration file which
    defines a query using a SQL Server database:
    Hardware Reqs in a freeform table (using xsl transformer)

    sqlhardware.xsl freeform xsl that converts
    datamerge namespace elements into
    CALS / OASIS table elements.

    doctype directory
    axdocbook.dcf a modification of axdocbook dcf file


    How to set up the demo:
    1. Unzip datamerge_sql.zip to a directory (e.g. c:\datamerge)
    2. Point APTCUSTOM to the directory where the demo file unzipped
    (e.g. c:\datamerge)
    3. Create a SQL Server database using hardware_sql.sql.
    a. Start Microsoft SQL Server Management Studio.
    b. Click New Query.
    c. Open hardware_sql.sql in Notepad.
    d. Copy and paste its contents into the new query.
    e. Click Execute.
    f. Select Databases in the left-hand pane of SQL Server Management
    Studio.
    g. Select View > Refresh.
    h. Confirm hardware_sql has been created.
    4. Setup System DSN for SQL Server.
    a. Control Panel -> Administrative Tools-> Data Sources (ODBC)
    b. Go to System DSN tab and click add
    c. Select the SQL Server driver.
    d. Set "Data Source Name" to "sql".
    e. Set the Description to anything you like.
    f. Set the server to the server where you created the database.
    g. Click Next.
    h. Accept the defaults on the next dialog by clicking Next.
    i. Select the Change the default database to checkbox.
    j. Select the hardware_sql database.
    k. Click Next.
    l. Accept the defaults on the next dialog by clicking Next.
    m. Select Test Data Source to test the new data source.
    n. Click OK several times to close out the ODBC Data Source
    Administrator.
    3. Setup xsl stylesheet path for
    a. Open sql.dmf in a text editor (or Epic)
    b. Near the bottom of the dmf file, you will see
    <transformerref name="transformer" nameref="XSLTransformer">
    <parameterref name="p_stylesheet" nameref="stylesheet">
    <value>c:/mylocation/sqlhardware.xsl</value>
    </parameterref>
    </transformerref>
    c. Change the value of stylesheet location to match where you put
    sqlhardware.xsl
    is. (e.g. c:/datamerge/sqlhardware.xsl)


    How to run the demo
    1. Open an axdocbook document
    2. Place your cursor in a document location where table is valid.
    3. Go to Insert->Markup
    3. In the mode drop down list, select "Query" (it may take a few seconds
    the
    first time to start Java and load config files)
    4. You should see the query Hardware Requirements in a freeform table
    (Company, Platform) in the dialog.
    5. Click Insert.
    6. Click Next. (You can change the choices if you want.)
    7. Clear the Auto Update on Open checkbox. (Or not. Your choice. It
    bugged me.)
    8. Click Insert.
    9. Editor inserts the query (note the datamerge icon) and renders the
    table.
    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    E-mail 3 of 7.

    File 2 of 6. axdocbook.dcf:



    Configuration 2.0//EN"
    "dcfdtd.dtd" [
    Configuration 1.0//EN" ">
    Configuration Translated Strings 1.0//EN" "../../lib/dcf_strings.ent">
    %strings;
    ]>
    <documenttypeconfiguration>
    <options allowfosimod="yes" allowtouchup="yes" protected="no"/">
    <newdialog>
    <new description="Arbortext" xml=" docbook=" v4.0&quot;=" samplefile="demo.xml"&lt;br"/>templateFile="template.xml"/></newdialog>
    <elementoptions>
    <elementoption allowspellchecking="no" element="abbrev"/">
    <elementoption category="division" element="abstract"/">
    <elementoption allowspellchecking="no" element="accel"/">
    <elementoption allowspellchecking="no" element="acronym"/">
    <elementoption category="division" element="appendix"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="arg"/>
    <elementoption category="division" element="article"/">
    <elementoption allowspellchecking="no" element="artpagenums"/">
    <elementoption allowspellchecking="no" element="authorinitials"/">
    <elementoption category="division" element="bibliodiv"/">
    <elementoption category="division" element="bibliography"/">
    <elementoption category="division" element="blockquote"/">
    <elementoption category="division" element="book"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption element="bookinfo" webcomposepageboundary="yes"/">
    <elementoption category="division" element="caution"/">
    <elementoption category="division" element="chapter"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption allowcharactersubstitution="no" element="cmdsynopsis"/">
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="command"/>
    <elementoption allowspellchecking="no" element="computeroutput"/">
    <elementoption allowspellchecking="no" element="contractnum"/">
    <elementoption allowspellchecking="no" element="database"/">
    <elementoption category="division" element="dedication"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="email"/>
    <elementoption allowspellchecking="no" element="envar"/">
    <elementoption allowspellchecking="no" category="division"&lt;br"/>element="equation"/>
    <elementoption allowspellchecking="no" element="errorcode"/">
    <elementoption category="division" element="example"/">
    <elementoption category="division" element="figure"/">
    <elementoption allowspellchecking="no" element="filename"/">
    <elementoption element="footnote" spellcheckingnewword="yes"/">
    <elementoption category="division" element="formalpara"/">
    <elementoption allowspellchecking="no" element="funcdef"/">
    <elementoption allowcharactersubstitution="no" element="funcsynopsisinfo"/">
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="function"/>
    <elementoption category="division" element="glossary"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption category="division" element="glossdiv"/">
    <elementoption category="division" element="glossentry"/">
    <elementoption element="holder" spellcheckingnewword="yes"/">
    <elementoption category="division" element="important"/">
    <elementoption category="division" element="index"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption category="division" element="indexdiv"/">
    <elementoption element="indexterm" spellcheckingnewword="yes"/">
    <elementoption allowspellchecking="no" element="informalequation"/">
    <elementoption allowspellchecking="no" element="inlinemediaobject"/">
    <elementoption allowspellchecking="no" element="invpartnumber"/">
    <elementoption allowspellchecking="no" element="isbn"/">
    <elementoption allowspellchecking="no" element="issn"/">
    <elementoption allowspellchecking="no" element="issuenum"/">
    <elementoption element="itemizedlist" listtype="block"/">
    <elementoption category="division" element="legalnotice"/">
    <elementoption element="listitem" listtype="item"/">
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="literal"/>
    <elementoption allowcharactersubstitution="no" element="literallayout"/">
    <elementoption allowspellchecking="no" element="manvolnum"/">
    <elementoption allowspellchecking="no" element="markup"/">
    <elementoption element="member" listtype="item"/">
    <elementoption category="division" element="note"/">
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="option"/>
    <elementoption element="orderedlist" listtype="block"/">
    <elementoption allowspellchecking="no" element="pagenums"/">
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="parameter"/>
    <elementoption category="division" element="part"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption category="division" element="partintro"/">
    <elementoption allowspellchecking="no" element="pob"/">
    <elementoption allowspellchecking="no" element="postcode"/">
    <elementoption category="division" element="preface"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption element="primary" spellcheckingnewword="yes"/">
    <elementoption category="division" element="procedure" listtype="block"/">
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="programlisting"/>
    <elementoption category="division" element="refentry"/">
    <elementoption category="division" element="reference"/">
    <elementoption category="title" element="refmeta"/">
    <elementoption category="division" element="refsect1"/">
    <elementoption category="division" element="refsect2"/">
    <elementoption category="division" element="refsect3"/">
    <elementoption category="division" element="refsynopsisdiv"/">
    <elementoption allowcharactersubstitution="no" element="replaceable"/">
    <elementoption allowcharactersubstitution="no" element="screen"/">
    <elementoption element="secondary" spellcheckingnewword="yes"/">
    <elementoption category="division" element="sect1"&lt;br"/>webComposePageBoundary="yes"/>
    <elementoption category="division" element="sect2"/">
    <elementoption category="division" element="sect3"/">
    <elementoption category="division" element="sect4"/">
    <elementoption category="division" element="sect5"/">
    <elementoption category="division" element="section"/">
    <elementoption category="division" element="simplesect"/">
    <elementoption category="division" element="set"/">
    <elementoption category="division" element="setindex"/">
    <elementoption allowspellchecking="no" element="sgmltag"/">
    <elementoption category="division" element="sidebar"/">
    <elementoption element="simplelist" listtype="block"/">
    <elementoption element="state" spellcheckingnewword="yes"/">
    <elementoption element="step" listtype="item"/">
    <elementoption element="substeps" listtype="block"/">
    <elementoption allowcharactersubstitution="no" element="synopsis"/">
    <elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="systemitem"/>
    <elementoption category="division" element="table"/">
    <elementoption category="division" element="tip"/">
    <elementoption category="title" element="title"/">
    <elementoption allowspellchecking="no" element="userinput"/">
    <elementoption category="division" element="variablelist"/">
    <elementoption category="division" element="varlistentry"/">
    <elementoption allowspellchecking="no" element="varname"/">
    <elementoption allowspellchecking="no" element="volumenum"/">
    <elementoption category="division" element="warning"/"></elementoptions>
    <attributeoptions>
    <attributeoption attribute="security" profiling="yes"/">
    <attributeoption attribute="os" profiling="yes"/">
    <attributeoption attribute="userlevel" profiling="yes"/">
    <attributeoption attribute="arch" profiling="yes"/"></attributeoptions>
    <display>
    <icon characternumber="16" characternumberlocal="15"&lt;br"/>characterSet="ati_tag" id="para"/>
    <icon characternumber="18" characternumberlocal="17"&lt;br"/>characterSet="ati_tag" id="endpara"/>
    <elementdisplay element="abstract" partialtagmodedisplay="full"/">
    <elementdisplay element="anchor" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="appendix" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="area" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="article" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="authorgroup" partialtagmodedisplay="full"/">
    <elementdisplay element="beginpage" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="bibliodiv" partialtagmodedisplay="full"/">
    <elementdisplay element="bibliography" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="blockquote" partialtagmodedisplay="full"/">
    <elementdisplay element="book" newline="yes" partialtagmodedisplay="full"/">
    <elementdisplay element="bookinfo" partialtagmodedisplay="full"/">
    <elementdisplay element="calloutlist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="caution" partialtagmodedisplay="full"/">
    <elementdisplay element="chapter" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="cmdsynopsis" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="cmdsynopsis" newline="yes" pair="end"/">
    <elementdisplay element="co" pair="start" partialtagmodedisplay="partial"/">
    <elementdisplay element="colspec" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="dedication" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="equation" partialtagmodedisplay="full"/">
    <elementdisplay element="example" partialtagmodedisplay="full"/">
    <elementdisplay element="figure" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="footnoteref" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="funcsynopsis" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="funcsynopsis" newline="yes" pair="end"/">
    <elementdisplay element="glossary" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="glossdiv" partialtagmodedisplay="full"/">
    <elementdisplay element="glossentry" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="glosslist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="graphic" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="important" partialtagmodedisplay="full"/">
    <elementdisplay element="index" newline="yes" notagmodeprompt="no"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="indexdiv" partialtagmodedisplay="full"/">
    <elementdisplay element="inlinegraphic" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="itemizedlist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="legalnotice" partialtagmodedisplay="full"/">
    <elementdisplay element="literallayout" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="literallayout" newline="yes" pair="end"/">
    <elementdisplay element="msgentry" partialtagmodedisplay="full"/">
    <elementdisplay element="msgset" partialtagmodedisplay="full"/">
    <elementdisplay element="note" partialtagmodedisplay="full"/">
    <elementdisplay element="orderedlist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="para" pair="start" partialtagmodeicon="para"/">
    <elementdisplay element="para" pair="end" partialtagmodeicon="endpara"/">
    <elementdisplay element="part" newline="yes" partialtagmodedisplay="full"/">
    <elementdisplay element="partintro" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="preface" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="procedure" partialtagmodedisplay="full"/">
    <elementdisplay element="programlisting" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="programlisting" newline="yes" pair="end"/">
    <elementdisplay element="programlistingco" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="quote" partialtagmodedisplay="none"/">
    <elementdisplay element="refentry" partialtagmodedisplay="full"/">
    <elementdisplay element="reference" partialtagmodedisplay="full"/">
    <elementdisplay element="refmeta" partialtagmodedisplay="full"/">
    <elementdisplay element="refnamediv" partialtagmodedisplay="full"/">
    <elementdisplay element="refsect1" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="refsect2" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="refsect3" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="refsynopsisdiv" partialtagmodedisplay="full"/">
    <elementdisplay element="revhistory" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="sbr" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="screen" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="screen" newline="yes" pair="end"/">
    <elementdisplay element="sect1" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="sect2" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="sect3" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="sect4" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="sect5" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="segmentedlist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="set" newline="yes" partialtagmodedisplay="full"/">
    <elementdisplay element="setindex" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="sidebar" partialtagmodedisplay="full"/">
    <elementdisplay element="simplelist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="spanspec" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="synopsis" newline="yes"/">
    <elementdisplay element="table" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="tip" partialtagmodedisplay="full"/">
    <elementdisplay element="toc" notagmodeprompt="no"/">
    <elementdisplay element="varargs" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="variablelist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="varlistentry" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
    <elementdisplay element="void" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
    <elementdisplay element="warning" partialtagmodedisplay="full"/">
    <elementdisplay element="xref" pair="start"&lt;br"/>partialTagModeDisplay="partial"/></display>
    <specials>
    <graphic element="inlinegraphic" entity="entityref" filename="fileref"&lt;br"/>horizScale="scale" inline="yes" reproDepth="depth" reproWidth="width"
    scaleToFit="scalefit" vertScale="scale"/>
    <graphic element="graphic" entity="entityref" filename="fileref"&lt;br"/>horizScale="scale" reproDepth="depth" reproWidth="width"
    scaleToFit="scalefit" vertScale="scale"/>
    <graphic element="imagedata" entity="entityref" filename="fileref"&lt;br"/>horizScale="scale" reproDepth="depth" reproWidth="width"
    scaleToFit="scalefit" vertScale="scale"/>
    <link element="ulink" uri="url"/">
    <link element="link" idref="linkend"/">
    <link element="glossterm" idref="linkend"/">
    <target element="anchor"/">
    <paragraph element="para"/">
    <paragraph element="member"/">&activex;
    </specials>
    <contexttransformations>
    <insertaroundtofix>
    <elementlistitem element="para"/">
    <elementlistitem element="member"/">
    <elementlistitem element="term"/">
    <elementlistitem element="equation"/">
    <elementlistitem element="inlineequation"/"></insertaroundtofix>
    <substitutions element="appendix">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="glossary"/">
    <elementlistitem element="section"/"></substitutions>
    <substitutions element="appendixinfo">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="glossaryinfo"/">
    <elementlistitem element="sectioninfo"/"></substitutions>
    <substitutions element="bridgehead">
    <elementlistitem element="title"/"></substitutions>
    <substitutions element="chapter">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="section"/">
    <elementlistitem element="simplesect"/">
    <elementlistitem element="appendix"/"></substitutions>
    <substitutions element="chapterinfo">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="sectioninfo"/">
    <elementlistitem element="appendixinfo"/"></substitutions>
    <substitutions element="glossary">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="appendix"/">
    <elementlistitem element="section"/"></substitutions>
    <substitutions element="glossaryinfo">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="appendixinfo"/">
    <elementlistitem element="sectioninfo"/"></substitutions>
    <substitutions element="glossdef">
    <elementlistitem element="listitem"/"></substitutions>
    <substitutions element="glossterm">
    <elementlistitem element="term"/"></substitutions>
    <substitutions element="member">
    <elementlistitem element="para"/">
    <elementlistitem element="listitem"/"></substitutions>
    <substitutions element="para">
    <elementlistitem element="member"/"></substitutions>
    <substitutions element="part">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="section"/">
    <elementlistitem element="simplesect"/">
    <elementlistitem element="appendix"/"></substitutions>
    <substitutions element="partinfo">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="sectioninfo"/">
    <elementlistitem element="appendixinfo"/"></substitutions>
    <substitutions element="refsect1">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="appendix"/">
    <elementlistitem element="glossary"/">
    <elementlistitem element="section"/"></substitutions>
    <substitutions element="refsect1info">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="appendixinfo"/">
    <elementlistitem element="glossaryinfo"/">
    <elementlistitem element="sectioninfo"/"></substitutions>
    <substitutions element="refsect2">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="appendix"/">
    <elementlistitem element="glossary"/">
    <elementlistitem element="section"/"></substitutions>
    <substitutions element="refsect2info">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="appendixinfo"/">
    <elementlistitem element="glossaryinfo"/">
    <elementlistitem element="sectioninfo"/"></substitutions>
    <substitutions element="refsect3">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="appendix"/">
    <elementlistitem element="glossary"/">
    <elementlistitem element="section"/"></substitutions>
    <substitutions element="refsect3info">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="appendixinfo"/">
    <elementlistitem element="glossaryinfo"/">
    <elementlistitem element="sectioninfo"/"></substitutions>
    <substitutions element="sect1">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="section"/">
    <elementlistitem element="simplesect"/">
    <elementlistitem element="appendix"/"></substitutions>
    <substitutions element="sect1info">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="sectioninfo"/">
    <elementlistitem element="appendixinfo"/"></substitutions>
    <substitutions element="sect2">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="section"/">
    <elementlistitem element="simplesect"/">
    <elementlistitem element="appendix"/"></substitutions>
    <substitutions element="sect2info">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="sectioninfo"/">
    <elementlistitem element="appendixinfo"/"></substitutions>
    <substitutions element="sect3">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="section"/">
    <elementlistitem element="simplesect"/">
    <elementlistitem element="appendix"/"></substitutions>
    <substitutions element="sect3info">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="sectioninfo"/">
    <elementlistitem element="appendixinfo"/"></substitutions>
    <substitutions element="sect4">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="section"/">
    <elementlistitem element="simplesect"/">
    <elementlistitem element="appendix"/"></substitutions>
    <substitutions element="sect4info">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="sectioninfo"/">
    <elementlistitem element="appendixinfo"/"></substitutions>
    <substitutions element="sect5">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="section"/">
    <elementlistitem element="simplesect"/">
    <elementlistitem element="appendix"/"></substitutions>
    <substitutions element="sect5info">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="sectioninfo"/">
    <elementlistitem element="appendixinfo"/"></substitutions>
    <substitutions element="section">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="part"/">
    <elementlistitem element="refsect1"/">
    <elementlistitem element="refsect2"/">
    <elementlistitem element="refsect3"/">
    <elementlistitem element="appendix"/">
    <elementlistitem element="simplesect"/"></substitutions>
    <substitutions element="sectioninfo">
    <elementlistitem element="sect1info"/">
    <elementlistitem element="sect2info"/">
    <elementlistitem element="sect3info"/">
    <elementlistitem element="sect4info"/">
    <elementlistitem element="sect5info"/">
    <elementlistitem element="chapterinfo"/">
    <elementlistitem element="partinfo"/">
    <elementlistitem element="refsect1info"/">
    <elementlistitem element="refsect2info"/">
    <elementlistitem element="refsect3info"/">
    <elementlistitem element="appendixinfo"/"></substitutions>
    <substitutions element="simplesect">
    <elementlistitem element="formalpara"/"></substitutions>
    <substitutions element="term">
    <elementlistitem element="glossterm"/"></substitutions>
    <substitutions element="title">
    <elementlistitem element="bridgehead"/"></substitutions>
    <substitutions element="varlistentry">
    <elementlistitem element="glossentry"/"></substitutions>
    <insertautowithin element="glossary" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:title></axdocbook:title><insertautoselection/><insertautocaret<br/>/></insertautowithin>
    <insertautowithin element="indexterm" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:primary><insertautoselection/><insertautocaret/></axdocbook:primary<br/>></insertautowithin>
    <insertautowithin element="listitem" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:para><insertautoselection/><insertautocaret/></axdocbook:para<br/>></insertautowithin>
    <insertautowithin element="refentry" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:refmeta><insertautoselection/><insertautocaret/></axdocbook:refmeta<br/>></insertautowithin>
    <insertautowithin element="sidebar" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:title></axdocbook:title><insertautoselection/><insertautocaret<br/>/></insertautowithin>
    <insertautowithin element="step"&lt;br"/>xmlns:axdocbook="axdocbook.dtd"><axdocbook:para<br/>><insertautoselection/><insertautocaret/></axdocbook:para></insertautowithin>
    </contexttransformations>
    <textstyles>
    <bold attribute="role" attributevalue="bold" element="emphasis"/">
    <underline attribute="role" attributevalue="underline" element="emphasis"/">
    <italic attribute="role" attributevalue="italic" element="emphasis"/">
    </textstyles>
    <lists>
    <bulleted>
    <block element="itemizedlist"/">
    <item element="listitem"/"></bulleted>
    <numbered>
    <block element="orderedlist"/">
    <item element="listitem"/"></numbered>
    </lists>
    <smartinsert>
    <category title="&amp;Admonition;">
    <elementlistitem element="caution"/">
    <elementlistitem element="important"/">
    <elementlistitem element="note"/">
    <elementlistitem element="tip"/">
    <elementlistitem element="warning"/"></category>
    <category title="&amp;Base;">
    <elementlistitem element="anchor"/"></category>
    <category title="&amp;Compound;">
    <elementlistitem element="msgset"/">
    <elementlistitem element="procedure"/">
    <elementlistitem element="qandaset"/">
    <elementlistitem element="sidebar"/"></category>
    <category title="&amp;Description;">
    <elementlistitem element="abstract"/">
    <elementlistitem element="authorblurb"/">
    <elementlistitem element="epigraph"/"></category>
    <category title="&amp;Division;">
    <elementlistitem element="appendix"/">
    <elementlistitem element="chapter"/">
    <elementlistitem element="glossary"/">
    <elementlistitem element="preface"/">
    <elementlistitem element="sect1"/">
    <elementlistitem element="sect2"/">
    <elementlistitem element="sect3"/">
    <elementlistitem element="sect4"/">
    <elementlistitem element="sect5"/"></category>
    <category title="&amp;DocumentInformation;">
    <elementlistitem element="author"/">
    <elementlistitem element="authorinitials"/">
    <elementlistitem element="corpauthor"/">
    <elementlistitem element="modespec"/">
    <elementlistitem element="othercredit"/">
    <elementlistitem element="productname"/">
    <elementlistitem element="productnumber"/">
    <elementlistitem element="revhistory"/"></category>
    <category title="&amp;Formal;">
    <elementlistitem element="equation"/">
    <elementlistitem element="example"/">
    <elementlistitem element="figure"/">
    <elementlistitem element="table"/"></category>
    <category title="&amp;General;">
    <elementlistitem element="abbrev"/">
    <elementlistitem element="acronym"/">
    <elementlistitem element="anchor"/">
    <elementlistitem element="bridgehead"/">
    <elementlistitem element="citation"/">
    <elementlistitem element="citerefentry"/">
    <elementlistitem element="citetitle"/">
    <elementlistitem element="emphasis"/">
    <elementlistitem element="firstterm"/">
    <elementlistitem element="footnote"/">
    <elementlistitem element="foreignphrase"/">
    <elementlistitem element="glossterm"/">
    <elementlistitem element="highlights"/">
    <elementlistitem element="phrase"/">
    <elementlistitem element="quote"/">
    <elementlistitem element="remark"/">
    <elementlistitem element="subscript"/">
    <elementlistitem element="superscript"/">
    <elementlistitem element="trademark"/">
    <elementlistitem element="wordasword"/"></category>
    <category title="&amp;Graphic;">
    <elementlistitem element="graphic"/">
    <elementlistitem element="inlinegraphic"/">
    <elementlistitem element="imagedata"/"></category>
    <category title="&amp;Index;">
    <elementlistitem element="indexterm"/"></category>
    <category title="&amp;Informal;">
    <elementlistitem element="address"/">
    <elementlistitem element="blockquote"/">
    <elementlistitem element="graphic"/">
    <elementlistitem element="graphicco"/">
    <elementlistitem element="informalequation"/">
    <elementlistitem element="informalexample"/">
    <elementlistitem element="informalfigure"/">
    <elementlistitem element="informaltable"/">
    <elementlistitem element="mediaobject"/">
    <elementlistitem element="mediaobjectco"/"></category>
    <category title="&amp;Inline;">
    <elementlistitem element="inlineequation"/">
    <elementlistitem element="inlinegraphic"/"></category>
    <category title="&amp;LineSpecific;">
    <elementlistitem element="literallayout"/">
    <elementlistitem element="programlisting"/">
    <elementlistitem element="programlistingco"/">
    <elementlistitem element="screen"/">
    <elementlistitem element="screenco"/">
    <elementlistitem element="screenshot"/"></category>
    <category title="&amp;Link;">
    <elementlistitem element="link"/">
    <elementlistitem element="olink"/">
    <elementlistitem element="ulink"/"></category>
    <category title="&amp;Lists;">
    <elementlistitem element="calloutlist"/">
    <elementlistitem element="glosslist"/">
    <elementlistitem element="itemizedlist"/">
    <elementlistitem element="orderedlist"/">
    <elementlistitem element="segmentedlist"/">
    <elementlistitem element="simplelist"/">
    <elementlistitem element="variablelist"/"></category>
    <category title="&amp;Paragraph;">
    <elementlistitem element="formalpara"/">
    <elementlistitem element="para"/">
    <elementlistitem element="simpara"/"></category>
    <category title="&amp;Reference;">
    <elementlistitem element="footnoteref"/">
    <elementlistitem element="xref"/"></category>
    <category title="&amp;Synopsis;">
    <elementlistitem element="classsynopsis"/">
    <elementlistitem element="cmdsynopsis"/">
    <elementlistitem element="constructorsynopsis"/">
    <elementlistitem element="destructorsynopsis"/">
    <elementlistitem element="fieldsynopsis"/">
    <elementlistitem element="funcsynopsis"/">
    <elementlistitem element="methodsynopsis"/">
    <elementlistitem element="synopsis"/"></category>
    <category title="&amp;Technical;">
    <elementlistitem element="accel"/">
    <elementlistitem element="action"/">
    <elementlistitem element="application"/">
    <elementlistitem element="classname"/">
    <elementlistitem element="command"/">
    <elementlistitem element="computeroutput"/">
    <elementlistitem element="database"/">
    <elementlistitem element="email"/">
    <elementlistitem element="envar"/">
    <elementlistitem element="errorcode"/">
    <elementlistitem element="errorname"/">
    <elementlistitem element="errortype"/">
    <elementlistitem element="exceptionname"/">
    <elementlistitem element="filename"/">
    <elementlistitem element="function"/">
    <elementlistitem element="guibutton"/">
    <elementlistitem element="guiicon"/">
    <elementlistitem element="guilabel"/">
    <elementlistitem element="guimenu"/">
    <elementlistitem element="guimenuitem"/">
    <elementlistitem element="guisubmenu"/">
    <elementlistitem element="hardware"/">
    <elementlistitem element="interface"/">
    <elementlistitem element="interfacename"/">
    <elementlistitem element="keycap"/">
    <elementlistitem element="keycode"/">
    <elementlistitem element="keycombo"/">
    <elementlistitem element="keysym"/">
    <elementlistitem element="literal"/">
    <elementlistitem element="markup"/">
    <elementlistitem element="medialabel"/">
    <elementlistitem element="menuchoice"/">
    <elementlistitem element="methodname"/">
    <elementlistitem element="mousebutton"/">
    <elementlistitem element="msgtext"/">
    <elementlistitem element="ooclass"/">
    <elementlistitem element="ooexception"/">
    <elementlistitem element="oointerface"/">
    <elementlistitem element="option"/">
    <elementlistitem element="optional"/">
    <elementlistitem element="parameter"/">
    <elementlistitem element="prompt"/">
    <elementlistitem element="property"/">
    <elementlistitem element="replaceable"/">
    <elementlistitem element="returnvalue"/">
    <elementlistitem element="sgmltag"/">
    <elementlistitem element="structfield"/">
    <elementlistitem element="structname"/">
    <elementlistitem element="symbol"/">
    <elementlistitem element="systemitem"/">
    <elementlistitem element="token"/">
    <elementlistitem element="type"/">
    <elementlistitem element="userinput"/"></category>
    </smartinsert>
    <profiling config="axdocbook.pcf"/">
    <framesets>
    <frameset description="default" location="default"/"></framesets>
    <composition>
    <compose type="htmlfile"></compose>
    <compose type="htmlhelp"></compose>
    <compose type="pdf"></compose>
    <compose type="profile"></compose>
    <compose type="web"></compose>
    <compose type="xsl"></compose>
    <compose type="xslfo"></compose>
    </composition>
    <datamerge><datasource enabled="yes" name="sql"/"></datamerge>
    </documenttypeconfiguration>

    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    E-mail 4 of 7.

    File 3 of 6. docbook_sql_server_datamerge.xml:



    "axdocbook.dtd">

    <book>
    <title></title>
    <subtitle></subtitle>
    <bookinfo>
    <pubdate></pubdate>
    <authorgroup>
    <corpauthor></corpauthor>
    </authorgroup>
    <address><street></street><city></city><state></state><postcode></postcode<br/>><country></country><phone></phone></address>
    </bookinfo>
    <chapter>
    <title></title>
    <para>Here comes the datamerge output.</para>
    <atidm:query fontcolor="gray5" backcolor="inherit"&lt;br"/>queryKey="sql:HardwareReqItems"
    queryName="Hardware Requirements in a freeform Table(Company, Platform)"
    queryType="freeform" timestamp="1298058096893" updateOnOpen="no"
    updateOnCompose="yes" updateManually="yes" p01="ARBWRE" p02="Windows"
    xmlns:atidm="
    <title>Results</title>
    <tgroup cols="4">
    <colspec colname="col1" colwidth="*"/">
    <colspec colname="col2" colwidth="*"/">
    <colspec colname="col3" colwidth="*"/">
    <colspec colname="col4" colwidth="*"/">
    <thead>
    <row><entry>processor</entry><entry>operating_system</entry><entry<br/>>memory</entry><entry>disk_space</entry></row>
    </thead>
    <tbody>
    <row>
    <entry>IBM-compatible PC with a Pentium IV processor</entry>
    <entry>Vista</entry>
    <entry>512 MB RAM</entry>
    <entry>300 MB additional disk space</entry>
    </row>
    <row>
    <entry>IBM-compatible PC with a Pentium IV processor</entry>
    <entry>Win98</entry>
    <entry>12</entry>
    <entry>300 MB additional disk space</entry>
    </row>
    <row>
    <entry>IBM-compatible PC with a Pentium IV processor</entry>
    <entry>7 Ultimate</entry>
    <entry>4 GB</entry>
    <entry>600 MB additional disk space</entry>
    </row>
    <row>
    <entry>IBM-compatible PC with a Pentium IV processor</entry>
    <entry>7 Universe</entry>
    <entry>1 <bold>TB</bold></entry>
    <entry>600 MB additional disk space</entry>
    </row>
    </tbody>
    </tgroup>
    </table></atidm:query>
    </chapter>
    </book>

    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    Adepters shut me down for sending too many things too fast. Resending.

    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    On Fri, Feb 18, 2011 at 3:36 PM, Paul Nagai <-> wrote:

    > E-mail 6 of 7.
    >
    > File 5 of 6. sql.dmf
    >
    >
    >
    > > "../doctypes/datamerge/datamerge.dtd" [
    > > component list//EN" "component.ent">
    > %component;
    > ]>
    > <datamerge>
    > <resource>&domReader;
    > &msAccessSource;
    > &xslTransformer;
    > &tableModelTransformer;
    > </resource>
    >
    >
    > <query name="HardwareReqItems" querytype="freeform" rootelement="table">
    > <label>Hardware Requirements in a freeform Table</label>
    > <interface>
    > <label>Query Parameters</label>
    > <queryfield name="p01" displaytype="combo" value="ARBWRE">
    > <label>Company</label>
    > <listitem>ARBWRE</listitem>
    > <listitem>TRU</listitem>
    > </queryfield>
    > <queryfield name="p02" displaytype="combo" value="Windows">
    > <label>Platform</label>
    > <listitem>Windows</listitem>
    > <listitem>Unix</listitem>
    > </queryfield>
    > </interface>
    > <sourceref name="r1" nameref="MS_Access_Source">
    >
    > <parameterref name="p_statement" nameref="sqlStatement">
    > <value>select processor, operating_system, memory, disk_space from
    > hardware_tbl WHERE company=? AND platform=?</value>
    > </parameterref>
    >
    > <parametergroupref name="queryParameters" nameref="sqlParameters">
    > <parameterref name="Model" datatype="string">
    > <queryfieldref nameref="p01"></queryfieldref>
    > </parameterref>
    > <parameterref name="Year" datatype="string">
    > <queryfieldref nameref="p02"></queryfieldref>
    > </parameterref>
    > </parametergroupref>
    >
    > <parametergroupref name="p_connect" nameref="connectionProperties">
    > <parameterref name="p_url" nameref="url">
    > <value>jdbcSmiley Surpriseddbc:sql</value>
    > </parameterref>
    > </parametergroupref>
    > </sourceref>
    >
    > <transformerref name="transformer" nameref="XSLTransformer">
    > <parameterref name="p_stylesheet" nameref="stylesheet">
    > <value>C:/Program
    > Files/Arbortext/Editor53/custom/datamerge/sqlhardware.xsl</value>
    > </parameterref>
    > </transformerref>
    > </query>
    > </datamerge>
    >
    >


    --
    Paul Nagai
    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    On Fri, Feb 18, 2011 at 3:37 PM, Paul Nagai <-> wrote:

    > E-mail 7 of 7.
    >
    > File 6 of 6. sqlhardware.xsl
    >
    >
    >
    >
    >
    > <xsl:stylesheet version="1.0"&lt;br"/>> xmlns:xsl="
    >
    > xmlns:atidm="
    > >
    >
    > <xslSmiley Surprisedutput indent="yes" method="xml" encoding="UTF-8"/">
    >
    > <xslSmiley Tonguearam name="output-encoding">UTF-8</xslSmiley Tonguearam>
    >
    > <xsl:template match="/">
    > <xsl:apply-templates/>
    > </xsl:template>
    >
    > <xsl:template match="atidm:ResultSet">
    >
    > <table>
    > <title>Results</title>
    > <tgroup cols="4">
    > <colspec colname="col1" colwidth="*"/">
    > <colspec colname="col2" colwidth="*"/">
    > <colspec colname="col3" colwidth="*"/">
    > <colspec colname="col4" colwidth="*"/">
    > <thead>
    > <row>
    > <entry>processor</entry>
    > <entry>operating_system</entry>
    > <entry>memory</entry>
    > <entry>disk_space</entry>
    > </row>
    > </thead>
    > <tbody>
    > <xsl:apply-templates/>
    > </tbody>
    > </tgroup>
    > </table>
    >
    > </xsl:template>
    >
    > <xsl:template match="atidm:Row">
    > <row>
    > <xsl:apply-templates/>
    > </row>
    > </xsl:template>
    >
    > <xsl:template match="atidm:Header">
    > </xsl:template>
    >
    > <xsl:template match="atidm:Value">
    > <xsl:apply-templates/>
    > </xsl:template>
    >
    > <xsl:template match="atidm:Column">
    > <entry>
    > <xsl:apply-templates/>
    > </entry>
    > </xsl:template>
    >
    >
    > </xsl:stylesheet>
    >
    >
    >


    --
    Paul Nagai
    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    On Fri, Feb 18, 2011 at 3:38 PM, Paul Nagai <-> wrote:

    > All done. I just remembered, though, I should mention that the readme.txt
    > references a Word .doc and an Acrobat .pdf that I'm not going to send across
    > the mailing list. They are duplicates of each other and only contain screen
    > caps. The readme.txt is probably enough.
    >



    --
    Paul Nagai
    S
    steve.thompson41-Visitor
    1-Visitor
    February 19, 2011
    Paul,

    Just FYI...

    File 3 of 6 didn't make it. With this last email, there should have been 8, counting your introductory message. Double checked, twice. Not triple, double twice, which is what... fourple? 😄

    Anyway, no File 3 of 6. Looks like the "shut me down... Resending" needed to include File 3.

    Regards,
    Steve Thompson
    +1(316)977-0515
    B
    bibach1-Visitor
    1-Visitor
    February 19, 2011
    Perhaps that message got caught by a filter of some sort at your
    location, Steve? I got a copy of it, and all of the messages are
    intact in the archives on ptcuser.org.

    -Brandon 🙂


    On Sat, Feb 19, 2011 at 7:32 AM, EXT-Thompson, Steve
    <steve.thompson2@boeing.com> wrote:
    > Paul,
    >
    > Just FYI...
    >
    > File 3 of 6 didn't make it. With this lastemail, there should have been 8,
    > counting your introductory message. Double checked, twice. Not triple,
    > double twice, which is what... fourple? 😄
    >
    > Anyway, no File 3 of 6. Looks like the "shut me down... Resending" needed to
    > include File 3.
    >
    > Regards,
    > Steve Thompson
    > +1(316)977-0515
    S
    steve.thompson41-Visitor
    1-Visitor
    February 19, 2011
    Good news for everyone else. Unhappily, they don't dump the 'filtered' files into a folder for review. Just gone.

    As long as it's on ptcuser.org, it will be 'findable'...

    Thanks,
    Steve Thompson
    +1(316)977-0515

    Show more replies
    Terms & ConditionsAccessibility statement