Forums

Hi I have an odd formatting issue where the tenth record appears to be in another table below the footer. I have no code in the footer for connectivity

My Header code is

The Registered Attendees Database.  
<br />
<div>{new_record}<br />
<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0">
  <tbody>
    <tr>
       <td style="font-weight: bold; width: 10%;">Last Name</td>
      <td style="font-weight: bold; width: 5%;">First Name</td>
      <td style="font-weight: bold; width: 5%;">Title</td>
      <td style="font-weight: bold; width: 15%;">Company</td>
      <td style="font-weight: bold; width: 5%;">State</td>
      <td style="font-weight: bold; width: 10%;">Industry</td>
      <td style="font-weight: bold; width: 10%;">Mobile</td>
    </tr>
  </tbody>
</table>
</div>

And my body code is:

<div><table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0">
  <tbody>
         <td style="width: 10%;">{last_3}</td>
      <td style="width: 5%;">{name_1}</td>
      <td style="width: 5%;">{title_10}</td>
      <td style="width: 15%;">{company_19}</td>
      <td style="width: 5%;">{state_13}</td>
      <td style="width: 10%;">{industry_9}</td>
      <td style="width: 10%;">{mobile_18}</td>
    </tr>
  </tbody></div>

Hi deavandeva,

Your body code opens a table but doesn't close it again. And you don't open the <tr> tag either.

I suggest you structure the table like this. In the Header box

<table . . .>
  <thead>
   <tr>
     <th>. . .</th>
     . . . 
     <th>. . .</th>
   </tr>
  </thead>
  <tfoot>
    <tr>
     <td>. . .</td>
     . . . 
     <td>. . .</td>
   </tr>
  </tfoot>
  <tbody>

In the body section:

    <tr>
     <td>. . .</td>
     . . . 
     <td>. . .</td>
   </tr>

and in the footer section:

  </tbody>
</table>

You may not want all of the sections but this is the full set I think.

Bob

Thanks all working now.

BTW do you know of any neat way to export the data into an excel file ?

EDIT I found the Component Sql to Excel, is there anyway to find the exact SQL query that Chrono Connectivity is running?

Basically I just want the ability to export the results to an excel sheet with table headers?

Thanks


Dean