Skip to main content
Feb 19, 2011 12:32 AM UTC
Question

sql server datamerge (7 emails, 6 files total)

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

    naglistsAuthor
    Feb 19, 2011 6:58 PM UTC
    Here you go, Steve.

    naglistsAuthor
    Feb 19, 2011 10:33 PM UTC
    Doing his best Ron Popeil:

    BUT WAIT! THAT'S NOT ALL! THREE THREE THREE BONUS FILES!

    1) An "identity" XSL stylesheet used to return the raw datamerge markup.
    2) An example of the raw datamerge markup created by #1.
    3) An "enhanced" example of an XSL that names ALL elements in the datamerge
    markup. Even if it doesn't do anything different from the XSL delivered in
    the sample with the new elements. Plus this contains processing that will
    return a "row" as an <h1> with nested <h2> / para children.


    Feb 20, 2011 11:57 PM UTC
    Very cool Paul, thanks for sharing!!


    Jan 21, 2012 6:58 AM UTC
    Hi Everyone,

    I've been testing some files for an update from Editor 5.3 - 5.4M80
    and encountered a problem with the graphic spacing. It seems that in
    one of my file, the graphic was moved to another page because of an
    increase in the spacing between graphic and generated caption. I have
    nothing special in postspace setting just a zero space with
    precedence=none.

    I cant force it to use 0pt because it will re-flow the other pages.
    What I find weird also is that when I force it to use 8pt, then that
    graphic fit and look exactly as in 5.3, but decrease the space to 7pt,
    and again was pushed to the next page.

    I also tested this in 5.4 M60 and this is not a problem. Was looking
    at the release notes of 5.4 M70 and 5.4M80 and didnt see anything with
    regards to this.

    Anyone knows any work around for this or am I missing something?

    Thanks.

    Milton