Categories > OpenTBS with DOCX >

Data from MySQL

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: mpol_ch
Date: 2013-04-29
Time: 17:14

Data from MySQL

Hello
I am using the following code in MS-Word to show the records from MySQL. But I am getting an empty row between the each row. I tried with code such block=tr or block=table or even with block=td. I just want to have the results like an excel table. Say no empty row between rows. Could you please advise what to change?

thanks
mpol_ch

[pp;block=begin]
[pp.Position]    [pp.Menge] [pp.Preis]    [pp.Total]
[pp;block=end]
By: Skrol29
Date: 2013-04-29
Time: 22:17

Re: Data from MySQL

Hi,

Do not use "block=begin" / "block=end" in tables, because it will split the XML row in a way you do not expect.

Use instead "block=w:tr". That is the XML element for a rows in Ms Word.
Since OpenTBS 1.8.0 (stable but still in beta version), you can also use the alias "block=tbs:row".
By: mpol_ch
Date: 2013-04-30
Time: 04:22

Re: Data from MySQL

Hi
Thanks a lot for the response. I adjusted the code as recommended. It works perfectly as it is as below.

[pp.Position;block=w:tr]    [pp.Menge]     [pp.Preis]    [pp.Total]

thanks again
mpol_ch