Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Horizontal recordset repeat

View all replies to this thread

Horizontal recordset repeat

Thread began 1/10/2017 6:18 am by Darren | Last modified 1/23/2017 12:21 pm by Darren | 1537 views | 7 replies

1/10/2017 6:18 amDarren

Horizontal recordset repeat

I'm trying to output a recordset horizontal instead of vertical

I have a SQL/recordset with 6 ids each with 5 fields

example of recordset id1
RS1
id = RS1
field1 = txt11
field2 = txt12
field3 = txt13
field4 = txt14
field5 = txt15

with datassist I can output the recordset

RS1 - txt11 - txt12 - txt13 - txt14 - txt15
RS2 - txt21 - txt22 - txt23 - txt24 - txt25
RS3 - txt31 - txt32 - txt33 - txt34 - txt35
RS4 - txt41 - txt42 - txt43 - txt44 - txt45
RS5 - txt51 - txt52 - txt53 - txt54 - txt55
RS6 - txt61 - txt62 - txt63 - txt64 - txt65

I am trying to rotate this so the id is at the top and the field follow down

RS1 RS2 RS3 RS4 RS5 RS6
txt11 txt21 txt31 txt41 txt51 txt61
txt12 txt22 txt32 txt42 txt52 txt62
txt13 txt22 txt33 txt43 txt53 txt63
txt14 txt22 txt34 txt44 txt54 txt64
txt15 txt22 txt35 txt45 txt55 txt65

as suggestion how I do this with datassist

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.