Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Horizontally repeat region in columns

Status
Not open for further replies.

catch99

Programmer
Jul 17, 2003
8
SE
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....
 
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>
 
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
 
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>
 
&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 ::
 
I've tried that extension before, but it write's out the recordset as this:

Category1 | Link1 | Link2
Category2 | Link1 | Link2
Category3 | Link1 | Link2
 
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 ::
 
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.
 
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 :)

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 ::
 
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.
 
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;)

 
double check that extention!
it works fine
Horizontal looper will produce:
Code:
1 2 3 4
5 6 7 8
or as many coulms or rows as u need.


Simulated Nested will prduce:
Code:
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 ::
 
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?
 
your keyboard and code view work? ;-)


:--------------------------------------------------------------------------:
fugitive.gif

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:
 
link above should help?no?
\4guyfrom rolla
also look through:


:--------------------------------------------------------------------------:
fugitive.gif

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top