Horizontally repeat region in columns

[catch99]

Is there anyway to write out a recordset as follows.

1 2 3
1.1 2.1 3.1
1.2 2.2 3.2
1.3
1.4

4 5 6
4.1 5.1 6.1
4.2 5.2
4.3 5.3

and so on.....

I've tried different extensions but none works.
horizontal looper 2 only loops from left to right.
example.
1 1.1 1.2
1.3 2 2.1
2.2 3 3.1

Please! anyone....

 

[deecee]

so you mean you have headers like name, age and location and then you want them to appear below?

<signature>
sometime you just gotta say &quot;WHAT THE @#*% !!&quot;
</signature>

 

[catch99]

I have Category and links.
So what i want is to get Category as header and links vertically displayed.
example:

Category1 | Category2 | Category3
Link1 | Link1 | Link1
Link2 | Link2 | Link2
Category4 | Category5 | Category6
Link1 | Link1 | Link1
Link2 | Link2 | Link2

 

[deecee]

what server language are you using? that would help a lot, also i would assume mysql

<signature>
sometime you just gotta say &quot;WHAT THE @#*% !!&quot;
</signature>

 

[catch99]

Hi,
your right, im using MySQL.

 

[lebisol]

&quot;what server language are you using? &quot;
A:your right, im using MySQL

hm...I hope it was a misread post
so PHP or ASP...or JSP?

> need more info?
:: don't click HERE ::

 

[catch99]

It's ASP i'm using.

 

[lebisol]

in that case here is an extention:

http://www.basic-ultradev.com/exthelp/HLooperhelp.htm

All the best!

> need more info?
:: don't click HERE ::

 

[catch99]

I've tried that extension before, but it write's out the recordset as this:

Category1 | Link1 | Link2
Category2 | Link1 | Link2
Category3 | Link1 | Link2

 

[lebisol]

if it s comming from 1 recordset then eeeeek
but if not then use different Repeated Regions and diffrened RecordSets for each Categoty?!no?

> need more info?
:: don't click HERE ::

 

[lebisol]

&quot;DUDirectory&quot; on:

http://duresources.com/resources/detail.asp?r=applications&t=UltraDev&i=497

> need more info?
:: don't click HERE ::

 

[catch99]

It's coming from one recordset.
But maybe I can split it up in two, and try it your way with different repeat regions.
Only prob. is that I don't know how many Categories there will be, so I have to build it dynamic.

 

[lebisol]

hm I know...gnad-parent-child was alway a Bit of work to display....look into &quot;data shaping&quot; concept....Code Only no DW behind this one

http://www.4guysfromrolla.com/webtech/092599-1.shtml

good luck!

p.s. be careful if use multiple repat regions that theyu don't get decalred on top of each other...DW likes to do that.

> need more info?
:: don't click HERE ::

 

[Cheech]

use nested recordsets

first one pulls the catagories

then loop through another selecting on category from first. dw dont like nested rs so you will have to handcode it.

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[martiros]

If you are displaying just a simple list of links in columns, I'd try GetString method for each column - your pages will load faster (try to display 100 or more rows using traditional RS looping & GetString - a BIG difference)

you'll need several small recordsets for each column though...

String = recordset.GetString(StringFormat, NumRows, ColumnDelimiter, RowDelimiter, NullExpr)

Example:

Response.write(&quot;<a href=&quot;&quot;display.asp?ID=&quot
Response.Write recordset.GetString(,,&quot;&quot;&quot;>&quot;,&quot;</a><br><a href=&quot;&quot;display.asp?ID=&quot;, &quot;-null-&quot
Response.Write(&quot;&quot;&quot;></a>&quot

 

[lebisol]

double check that extention!
it works fine
Horizontal looper will produce:

1 2 3 4
5 6 7 8

or as many coulms or rows as u need.


Simulated Nested will prduce:

Comedy
     Monty Python and the Holy Grail 
     Blazing Saddles 
     Animal House 
Horror
      Dracula 
      Frankenstein 
Action
      Enter the Dragon 
      The Crow 
      The Matrix

I am not sure if u can cobine the two....

HTH
All the best!


> need more info?
:: don't click HERE ::

 

[blasterstudios]

I downloaded hlooper, but do not see it on my Server Behaviors menu. I am using MX 2004. Is it because it's for an older version?

Also, is there a website that has a ton of extensions to browse through for MX 2004?

 

[lebisol]

your keyboard and code view work? ;-)


:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:

 

[blasterstudios]

i learn by example

 

[lebisol]

link above should help?no?
\4guyfrom rolla
also look through:

http://www.basic-ultradev.com/extensions/

:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------: