MX Looper Forum :: Force redundant columns to appear with Horizontal Region

With the horizontal repeat region, is there a way to align the generated repeat region data to the preset number of columns entered when setting the repeat region.

For example, if a column is set to spread 7 across, but only 3 records are found, the extension creates just 3 columns justified across which can make the layout rather messy.

http://www.collegecameras.co.uk/euro/www/CatChainsType.asp?CatID=87

The example above shows that just under the dropmenus there is a horizontal repeat region set to 7 columns wide, however 3 records were found so the columns are justified to fill the whole width. I want there to still be 7 columns, even if the last redundant 4 columns are empty.

Many Thanks
Rob

Hi Rob,

Please specify what exactly are you using - the Repeat Region that comes with Dreamweaver or the horizontal command in MX Looper? In both cases, if the database table does not return all the records that you have specified, it will either create empty columns, or will not crete them at all.

Regards,
Cristian

Hi,

I'm using the Interakt Looper, i want the looper to return empty table cells that are set to specific widths so that returned records match the intended layout and design.

http://www.collegecameras.co.uk/euro/www/CatShanksType.asp?CatID=5

http://www.collegecameras.co.uk/euro/www/CatShanksType.asp?CatID=6

The above examples show the same page, example 1 is how i want the page to look (6 records wide). In the second example, only 5 records are returned so the cells are justified across to only 5 records wide.

TIA
Rob

Hi Rob,

MX Looper only creates columns when there is data to display. When no more records are retrieved, the looper closes the row and table used to display data.

In order for it to display blank cells to the upper limit that was set you would have to modify the php code  that generates it.

Regards,
Cristian

Hi there,

I posted a question a few months ago on this forum asking whether it was possible to force redundant columns to appear with your horizontal repeat region.

The previous links on the forum page can now be seen here.
http://www.eurofindings.com/CatChainsType.asp?CatID=87
http://www.eurofindings.com/CatChainsType.asp?CatID=93

I have since come back to the problem to finally fix it but can't understand how to edit the code. I'm working with ASP and have posted an extract below. If this is more complicated do you still offer your Custom Support Incidents?

Many Thanks
Rob

<%
  if len(nested_rsChain)<=0 then
    Dim nested_rsChain
    nested_rsChain = rsChain.Source
  end if
  nst_sw = false
  rsChain.Close()
  rsChain.Source = Replace(nested_rsChain, "123456789", rsChainMetals.Fields.Item("MetalID").Value)
  rsChain.Open()
  ' Horizontal Looper version 3
  'While ((Repeat_rsChain__numRowsHL <> 0) AND (NOT rsChain.EOF))
  nested_rsChain1 = 1
  While (NOT rsChain.EOF)
            'While (NOT rsChain.EOF)
'    'Nested repeat
%>
                              <td><div align="left">
                                <table width="110" border="0" align="left" cellpadding="2" cellspacing="0" >
                                    <tr >
                                      <%
            rsImage.Close()
            rsImage.Source = "SELECT PrdID, Image FROM ProductImg WHERE Sortby = 1 AND PrdID = " + Replace(rsChain.Fields.Item("PrdID").Value, "'", "''") + ""
            rsImage.Open()
%>
                                      <td colspan="2" class="DGrey11pxReg"><div align="center"><a href="<%=(rsChain.Fields.Item("PageURL").Value)%>?<%= Server.HTMLEncode(MM_keepNone) & MM_joinChar(MM_keepNone) & "PrdID=" & rsChain.Fields.Item("PrdID").Value %>"><img src="<%=tNG_showDynamicThumbnail("", "images/Products/", "{rsImage.Image}", 100, 75, false)%>" border="1" class="BorderBlack1px" /></a></div></td>
                                    </tr>