Menu

#1104 Table Data not parsed for dangerous HTML code

open
5
2003-04-29
2003-04-29
Anonymous
No

When viewing database table data, the postgreSQL
module does not parse for HTML-alike characters.

Therefore, the table view gets distroyed completely
which leads to completly wrong values for the entry id's
being displayed.

This makes it useless and sometimes dangerous to
alter and view data.

Discussion

  • Robert Oschwald

    Robert Oschwald - 2003-04-29

    Logged In: YES
    user_id=155253

    Submitted by me.

    To test this:
    Create a db in UNICODE encoding and add a Table to it.
    Then add some unicode Data to it or try to add html tags.

    Funny.

     
  • Jamie Cameron

    Jamie Cameron - 2003-04-29

    Logged In: YES
    user_id=129364

    Are you using the latest version of webmin, such as 1.080?
    It has code to escape HTML tags in table data ..
    If so and if problems are still happening, could you attach
    a 'view source' from your browser to this bug report?

     
  • Robert Oschwald

    Robert Oschwald - 2003-04-30

    Logged In: YES
    user_id=155253

    We are using latest 1.080 Version (SuSE 8.0).

    We digged deeper into the problem and figured out that the
    problem are html tags in table cells.
    We got </tr> inside one cell which corrupts the table output
    of the webmin psql view data module.

    Here is a sample html sourcecode which shows the problem:

    <!doctype html public "-//W3C//DTD HTML 3.2 Final//EN">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html;
    Charset=iso-8859-1">
    <link rel='icon' href='/images/webmin_icon.png'
    type='image/png'>
    <title>Table Data</title>
    <SCRIPT LANGUAGE="JavaScript">
    defaultStatus="root logged into Webmin 1.080 on
    apps.symentis.com (SuSE Linux 8.0)";
    </SCRIPT>
    </head>
    <body bgcolor=#6696bc link=#000000 vlink=#000000
    text=#000000 leftmargin="0" topmargin="0" marginwidth="0"
    marginheight="0" ><table width="100%" border="0"
    cellspacing="0" cellpadding="0"
    background="/images/top_bar/bg.jpg" height="32">
    <tr>
    <td width="4" nowrap><img
    src="/images/top_bar/left.jpg" width="4" height="32"></td>
    <td width="100%" nowrap><a
    href="http://www.webmin.com"><img
    src="/images/top_bar/webmin_logo.jpg" width="99"
    height="32" border="0" alt="Webmin home
    page"></a></td><td><a href='/feedback_form.cgi?
    module=postgresql'><img src=/images/top_bar/feedback.jpg
    width=97 height=32 alt="Feedback.."
    border=0></a></td><td><img
    src=/images/top_bar/top_sep.jpg width=12
    height=32></td><td width="84" nowrap><a
    href='/session_login.cgi?logout=1'><img
    src="/images/top_bar/logout.jpg" height="31" width=84
    border="0" alt="Logout"></a></td><td width="3" nowrap>
    <div align="right"><img
    src="/images/top_bar/right.jpg" width="3" height="32"></div>
    </td>
    </tr>
    </table><table width="100%" border="0"
    cellspacing="0" cellpadding="0" height="7">
    <tr>
    <td background="/images/top_bar/shadow_bg.jpg"
    nowrap><img src="/images/top_bar/shadow.jpg" width="8"
    height="7"></td>
    </tr>
    </table><table width="100%" border="0" cellspacing="0"
    cellpadding="0" height="57"
    background="/images/nav/bg.jpg">
    <tr background="/images/nav/bg.jpg">
    <td width="6" nowrap><img src="/images/nav/left.jpg"
    width="3" height="57"></td><td nowrap><a href=/?
    cat=webmin><center><img src="/images/cats/webmin.jpg"
    width="43" height="44" border=0 alt=webmin><br><img
    src=/images/letters2/87.gif width=14 height=16 alt="87"
    align=bottom border=0><img src=/images/letters2/101.gif
    width=11 height=16 alt="101" align=bottom border=0><img
    src=/images/letters2/98.gif width=10 height=16 alt="98"
    align=bottom border=0><img src=/images/letters2/109.gif
    width=14 height=16 alt="109" align=bottom border=0><img
    src=/images/letters2/105.gif width=4 height=16 alt="105"
    align=bottom border=0><img src=/images/letters2/110.gif
    width=9 height=16 alt="110" align=bottom
    border=0></a></center></td>
    <td width="17" nowrap><img src="/images/nav/sep.jpg"
    width="17" height="57"></td><td nowrap><a href=/?
    cat=system><center><img src="/images/cats/system.jpg"
    width="43" height="44" border=0 alt=system><br><img
    src=/images/letters2/83.gif width=9 height=16 alt="83"
    align=bottom border=0><img src=/images/letters2/121.gif
    width=10 height=16 alt="121" align=bottom border=0><img
    src=/images/letters2/115.gif width=8 height=16 alt="115"
    align=bottom border=0><img src=/images/letters2/116.gif
    width=6 height=16 alt="116" align=bottom border=0><img
    src=/images/letters2/101.gif width=11 height=16 alt="101"
    align=bottom border=0><img src=/images/letters2/109.gif
    width=14 height=16 alt="109" align=bottom
    border=0></a></center></td>
    <td width="17" nowrap><img src="/images/nav/sep.jpg"
    width="17" height="57"></td><td nowrap><a href=/?
    cat=servers><center><img src="/images/cats/servers.jpg"
    width="43" height="44" border=0 alt=servers><br><img
    src=/images/letters2/83.gif width=9 height=16 alt="83"
    align=bottom border=0><img src=/images/letters2/101.gif
    width=11 height=16 alt="101" align=bottom border=0><img
    src=/images/letters2/114.gif width=6 height=16 alt="114"
    align=bottom border=0><img src=/images/letters2/118.gif
    width=10 height=16 alt="118" align=bottom border=0><img
    src=/images/letters2/101.gif width=11 height=16 alt="101"
    align=bottom border=0><img src=/images/letters2/114.gif
    width=6 height=16 alt="114" align=bottom border=0><img
    src=/images/letters2/115.gif width=8 height=16 alt="115"
    align=bottom border=0></a></center></td>
    <td width="17" nowrap><img src="/images/nav/sep.jpg"
    width="17" height="57"></td><td nowrap><a href=/?
    cat=net><center><img src="/images/cats/net.jpg"
    width="43" height="44" border=0 alt=net><br><img
    src=/images/letters2/78.gif width=10 height=16 alt="78"
    align=bottom border=0><img src=/images/letters2/101.gif
    width=11 height=16 alt="101" align=bottom border=0><img
    src=/images/letters2/116.gif width=6 height=16 alt="116"
    align=bottom border=0><img src=/images/letters2/119.gif
    width=13 height=16 alt="119" align=bottom border=0><img
    src=/images/letters2/111.gif width=11 height=16 alt="111"
    align=bottom border=0><img src=/images/letters2/114.gif
    width=6 height=16 alt="114" align=bottom border=0><img
    src=/images/letters2/107.gif width=9 height=16 alt="107"
    align=bottom border=0><img src=/images/letters2/105.gif
    width=4 height=16 alt="105" align=bottom border=0><img
    src=/images/letters2/110.gif width=9 height=16 alt="110"
    align=bottom border=0><img src=/images/letters2/103.gif
    width=10 height=16 alt="103" align=bottom
    border=0></a></center></td>
    <td width="17" nowrap><img src="/images/nav/sep.jpg"
    width="17" height="57"></td><td nowrap><a href=/?
    cat=hardware><center><img
    src="/images/cats/hardware.jpg" width="43" height="44"
    border=0 alt=hardware><br><img src=/images/letters2/72.gif
    width=9 height=16 alt="72" align=bottom border=0><img
    src=/images/letters2/97.gif width=11 height=16 alt="97"
    align=bottom border=0><img src=/images/letters2/114.gif
    width=6 height=16 alt="114" align=bottom border=0><img
    src=/images/letters2/100.gif width=10 height=16 alt="100"
    align=bottom border=0><img src=/images/letters2/119.gif
    width=13 height=16 alt="119" align=bottom border=0><img
    src=/images/letters2/97.gif width=11 height=16 alt="97"
    align=bottom border=0><img src=/images/letters2/114.gif
    width=6 height=16 alt="114" align=bottom border=0><img
    src=/images/letters2/101.gif width=11 height=16 alt="101"
    align=bottom border=0></a></center></td>
    <td width="17" nowrap><img src="/images/nav/sep.jpg"
    width="17" height="57"></td><td nowrap><a href=/?
    cat=cluster><center><img src="/images/cats/cluster.jpg"
    width="43" height="44" border=0 alt=cluster><br><img
    src=/images/letters2/67.gif width=12 height=16 alt="67"
    align=bottom border=0><img src=/images/letters2/108.gif
    width=4 height=16 alt="108" align=bottom border=0><img
    src=/images/letters2/117.gif width=9 height=16 alt="117"
    align=bottom border=0><img src=/images/letters2/115.gif
    width=8 height=16 alt="115" align=bottom border=0><img
    src=/images/letters2/116.gif width=6 height=16 alt="116"
    align=bottom border=0><img src=/images/letters2/101.gif
    width=11 height=16 alt="101" align=bottom border=0><img
    src=/images/letters2/114.gif width=6 height=16 alt="114"
    align=bottom border=0></a></center></td>
    <td width="17" nowrap><img src="/images/nav/sep.jpg"
    width="17" height="57"></td><td nowrap><center><a href=/?
    cat=><img src="/images/cats/others.jpg" width="43"
    height="44" border=0 alt=><br><img
    src=/images/letters2/79.gif width=12 height=16 alt="79"
    align=bottom border=0><img src=/images/letters2/116.gif
    width=6 height=16 alt="116" align=bottom border=0><img
    src=/images/letters2/104.gif width=9 height=16 alt="104"
    align=bottom border=0><img src=/images/letters2/101.gif
    width=11 height=16 alt="101" align=bottom border=0><img
    src=/images/letters2/114.gif width=6 height=16 alt="114"
    align=bottom border=0><img src=/images/letters2/115.gif
    width=8 height=16 alt="115" align=bottom
    border=0></a></center></td>
    <td width="17" nowrap><img src="/images/nav/sep.jpg"
    width="17" height="57"></td><td width="100%"
    nowrap> </td>
    <td nowrap> </td>
    </tr>
    </table><table width="100%" border="0" cellspacing="0"
    cellpadding="0" background="/images/nav/bottom_bg.jpg"
    height="4">
    <tr>
    <td width="100%"><img src="/images/nav/bottom_left.jpg"
    width="3" height="4"></td>
    </tr>
    </table><table width="100%" border="0" cellspacing="0"
    cellpadding="0"
    background="/images/nav/bottom_shadow2.jpg"> <tr
    background="/images/nav/bottom_shadow2.jpg"> <td
    nowrap>
    <table border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td background="/images/tabs/bg.jpg"><img
    src="/images/tabs/left.jpg" width="12" height="21"
    nowrap></td>
    <td background="/images/tabs/bg.jpg" nowrap>
    <a href="/postgresql/">Module Index</a></td>
    <td background="/images/tabs/bg.jpg" nowrap><img
    src="/images/tabs/right.jpg" width="15" height="21"></td>
    </tr>
    <tr>
    <td nowrap><img src="/images/tabs/right_bottom.jpg"
    width="12" height="4"></td>
    <td background="/images/tabs/bottom.jpg"
    nowrap><img src="/images/tabs/bottom.jpg" width="17"
    height="4"></td>
    <td nowrap><img src="/images/tabs/left_bottom.jpg"
    width="15" height="4"></td> </tr>
    </table>

    </td> <td nowrap>
    <table border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td background="/images/tabs/bg.jpg"><img
    src="/images/tabs/left.jpg" width="12" height="21"
    nowrap></td>
    <td background="/images/tabs/bg.jpg" nowrap>
    <a onClick='window.open
    ("/help.cgi/postgresql/view_table", "help", "toolbar=no,menubar
    =no,scrollbars=yes,width=400,height=300,resizable=yes");
    return false'
    href="/help.cgi/postgresql/view_table">Help..</a></td>
    <td background="/images/tabs/bg.jpg" nowrap><img
    src="/images/tabs/right.jpg" width="15" height="21"></td>
    </tr>
    <tr>
    <td nowrap><img src="/images/tabs/right_bottom.jpg"
    width="12" height="4"></td>
    <td background="/images/tabs/bottom.jpg"
    nowrap><img src="/images/tabs/bottom.jpg" width="17"
    height="4"></td>
    <td nowrap><img src="/images/tabs/left_bottom.jpg"
    width="15" height="4"></td> </tr>
    </table>

    </td>
    <td nowrap width="100%"
    background="/images/nav/bottom_shadow2.jpg" valign="top">

    <table width="100%" border="0" cellspacing="0"
    cellpadding="0"
    background="/images/nav/bottom_shadow2.jpg">
    <tr>
    <td><img
    src="/unauthenticated/nav/bottom_shadow.jpg" width="43"
    height="9"></td>
    </tr>
    </table>

    </td>
    </tr>
    </table><p><table border=0 cellpadding=0 cellspacing=0
    width=95% align=center><tr><td><table border=0
    cellpadding=0 cellspacing=0 height=20><tr>
    <td bgcolor=#bae3ff><img src=/images/tabs/blue_left.jpg
    width=13 height=22 alt=""></td>
    <td bgcolor=#bae3ff> <b>Table Data</b> </td>
    <td bgcolor=#bae3ff><img src=/images/tabs/blue_right.jpg
    width=19 height=22 alt=""></td>
    </tr></table></td></tr></table><table border=0 width=95%
    align=center cellspacing=0 cellpadding=0><tr><td
    bgcolor=#ffffff>
    <table border=0 width=95% align=center cellspacing=0
    cellpadding=0><tr><td>
    <center><font size=+2>Table <tt>goal</tt> in database
    <tt>mydb-1</tt></font></center>
    <hr><p>
    <center>
    <font size=+1>Rows 1 to 25 of 64</font>
    <a href='view_table.cgi?db=mydb-
    1&table=goal&start=25'><img src=/images/right.gif border=0
    align=middle></a>
    </center>
    <form action=view_table.cgi method=post>
    <input type=hidden name=db value='mydb-1'>
    <input type=hidden name=table value='goal'>
    <input type=hidden name=start value='0'>
    <table border width=100%>
    <tr bgcolor=#7f7f7f>
    <td> </td>
    <td><b>id</b></td>
    <td><b>userid</b></td>
    <td><b>parentid</b></td>
    <td><b>description</b></td>
    <td><b>status</b></td>
    <td><b>longdescription</b></td>
    <td><b>category</b></td>
    <td><b>enddate</b></td>
    <td><b>demanding</b></td>
    <td><b>challenging</b></td>
    <td><b>successfactor</b></td>
    <td><b>timecontinuously</b></td>
    <td><b>timeinpercent</b></td>
    <td><b>timestartdate</b></td>
    <td><b>timeenddate</b></td>
    <td><b>extra1</b></td>
    <td><b>extra2</b></td>
    <td><b>extra3</b></td>
    <td><b>object_status</b></td>
    <td><b>object_generated</b></td>
    <td><b>object_last_update</b></td>
    <td><b>object_updated_by</b></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98823></td>
    <td width=10%>1</td>
    <td width=10%>3</td>
    <td width=10%>2</td>
    <td width=10%>DATAHEREDATAHERE</td>
    <td width=10%>0</td>
    <td width=10%>DATAHEREDATAHERE</td>
    <td width=10%>GC.choose</td>
    <td width=10%>2002-09-06 00:00:00+02</td>
    <td width=10%>3</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-07-06 00:00:00+02</td>
    <td width=10%>2002-07-06 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>10</td>
    <td width=10%>2002-07-06 19:05:22+02</td>
    <td width=10%>2002-07-07 15:18:39.728+02</td>
    <td width=10%>3</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98824></td>
    <td width=10%>2</td>
    <td width=10%>3</td>
    <td width=10%>3</td>
    <td width=10%>Messen</td>
    <td width=10%>1</td>
    <td width=10%>aaa</td>
    <td width=10%>GC.choose</td>
    <td width=10%>2002-10-06 00:00:00+02</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%>4</td>
    <td width=10%>1</td>
    <td width=10%>5</td>
    <td width=10%>2002-07-06 00:00:00+02</td>
    <td width=10%>2002-06-06 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>10</td>
    <td width=10%>2002-07-06 22:50:26+02</td>
    <td width=10%>2002-07-07 15:18:56.058+02</td>
    <td width=10%>3</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98828></td>
    <td width=10%>29</td>
    <td width=10%>8</td>
    <td width=10%><br></td>
    <td width=10%>DATAHEREDATAHERE</td>
    <td width=10%>2</td>
    <td width=10%>DATAHEREDATAHERE</td>
    <td width=10%>DATAHEREDATAHERE</td>
    <td width=10%>2003-04-30 00:00:00+02</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>3</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-12-15 00:00:00+01</td>
    <td width=10%>2003-04-30 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-08-28 15:40:36+02</td>
    <td width=10%>2003-01-08 12:25:18.397+01</td>
    <td width=10%>4</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98829></td>
    <td width=10%>19</td>
    <td width=10%>10</td>
    <td width=10%><br></td>
    <td width=10%>vghjvgbg</td>
    <td width=10%>0</td>
    <td width=10%>fhgjgj</td>
    <td width=10%>GC.choose</td>
    <td width=10%>2002-08-23 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-08-23 00:00:00+02</td>
    <td width=10%>2002-08-23 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>10</td>
    <td width=10%>2002-08-23 13:33:23+02</td>
    <td width=10%>2002-08-23 13:33:44.511+02</td>
    <td width=10%>10</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98830></td>
    <td width=10%>20</td>
    <td width=10%>10</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>0</td>
    <td width=10%><br></td>
    <td width=10%>GC.choose</td>
    <td width=10%>2002-08-24 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-08-24 00:00:00+02</td>
    <td width=10%>2002-08-24 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>10</td>
    <td width=10%>2002-08-24 14:07:07+02</td>
    <td width=10%>2002-08-24 14:07:18.725+02</td>
    <td width=10%>10</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98826></td>
    <td width=10%>3</td>
    <td width=10%>3</td>
    <td width=10%>8</td>
    <td width=10%><br></td>
    <td width=10%>2</td>
    <td width=10%>asdfghj</td>
    <td width=10%>GC.choose</td>
    <td width=10%>2002-07-07 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-07-07 00:00:00+02</td>
    <td width=10%>2002-07-07 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-07-07 15:33:47+02</td>
    <td width=10%>2003-04-01 09:04:12.536+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98833></td>
    <td width=10%>64</td>
    <td width=10%>4</td>
    <td width=10%>49</td>
    <td width=10%><br></td>
    <td width=10%>0</td>
    <td width=10%><br></td>
    <td width=10%>GC.choose</td>
    <td width=10%>2003-01-14 00:00:00+01</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2003-01-14 00:00:00+01</td>
    <td width=10%>2003-01-14 00:00:00+01</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2003-01-14 17:17:04.356+01</td>
    <td width=10%>2003-01-14 17:17:04.356+01</td>
    <td width=10%>4</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98834></td>
    <td width=10%>21</td>
    <td width=10%>10</td>
    <td width=10%><br></td>
    <td width=10%>mjvdnfjkv</td>
    <td width=10%>0</td>
    <td width=10%><br></td>
    <td width=10%>GC.choose</td>
    <td width=10%>2002-08-24 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-08-24 00:00:00+02</td>
    <td width=10%>2002-08-24 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>10</td>
    <td width=10%>2002-08-24 14:07:47+02</td>
    <td width=10%>2002-08-24 14:07:53.584+02</td>
    <td width=10%>10</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98825></td>
    <td width=10%>4</td>
    <td width=10%>3</td>
    <td width=10%>51</td>
    <td width=10%>DATAHEREDATAHERE</td>
    <td width=10%>1</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHEREDATAHEREDATAHERED
    ATAHEREDATAHERE</td>
    <td width=10%>GC.customerRelated</td>
    <td width=10%>2002-10-01 00:00:00+02</td>
    <td width=10%>1</td>
    <td width=10%>1</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%>5</td>
    <td width=10%>2002-07-07 00:00:00+02</td>
    <td width=10%>2002-08-27 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-07-07 17:23:10+02</td>
    <td width=10%>2003-04-01 09:35:26.698+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98845></td>
    <td width=10%>36</td>
    <td width=10%>13</td>
    <td width=10%>13</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHERE</td>
    <td width=10%>2</td>
    <td width=10%><br></td>
    <td width=10%>GC.choose</td>
    <td width=10%>2003-04-01 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-09-03 00:00:00+02</td>
    <td width=10%>2002-09-03 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-09-03 09:38:30+02</td>
    <td width=10%>2003-04-01 10:02:14.13+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98839></td>
    <td width=10%>57</td>
    <td width=10%>9</td>
    <td width=10%><br></td>
    <td width=10%>fasdfgfdg</td>
    <td width=10%>0</td>
    <td width=10%><br></td>
    <td width=10%>GC.choose</td>
    <td width=10%>2002-09-16 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-09-16 00:00:00+02</td>
    <td width=10%>2002-09-16 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>10</td>
    <td width=10%>2002-09-16 12:20:48+02</td>
    <td width=10%>2002-09-16 12:21:32.169+02</td>
    <td width=10%>9</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98840></td>
    <td width=10%>59</td>
    <td width=10%>18</td>
    <td width=10%><br></td>
    <td width=10%>1234567890</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row
    value=1234567890></td>
    <td width=10%>0</td>
    <td width=10%
    >12345678901234567890123456789012345678901234567890
    123456789012345678901234567890123456789012345678901
    234567890123456789012345678901234567890123456789012
    345678901234567890123456789012345678901234567890123
    456789012345678901234567890123456789012345678901234
    567890123456789012345678901234567890123456789012345
    678901234567890123456789012345678901234567890123456
    789012345678901234567890123456789012345678901234567
    890123456789012345678901234567890123456789012345678
    901234567890123456789012345678901234567890123456789
    012345678901234567890123456789012345678901234567890
    123456789012345678901234567890123456789012345678901
    234567890123456789012345678901234567890123456789012
    345678901234567890123456789012345678901234567890123
    456789012345678901234567890123456789012345678901234
    567890123456789012345678901234567890123456789012345
    678901234567890123456789012345678901234567890123456
    789012345678901234567890123456789012345678901234567
    890123456789012345678901234567890123456789012345678
    901234567890123456789012345678901234567890123456789
    012345678901234567890123456789012345678901234567890
    123456789012345678901234567890123456789012345678901
    234567890123456789012345678901234567890123456789012
    345678901234567890123456789012345678901234567890123
    456789012345678901234567890123456789012345678901234
    567890123456789012345678901234567890123456789012345
    678901234567890123456789012345678901234567890123456
    789012345678901234567890123456789012345678901234567
    890123456789012345678901234567890123456789012345678
    901234567890123456789012345678901234567890123456789
    012345678901234567890123456789012345678901234567890
    1234567890</td>
    <td width=10%>GC.choose</td>
    <td width=10%>2002-10-15 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-10-15 00:00:00+02</td>
    <td width=10%>2002-10-15 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>10</td>
    <td width=10%>2002-10-15 10:16:32+02</td>
    <td width=10%>2002-10-15 10:16:42.209+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98848></td>
    <td width=10%>11</td>
    <td width=10%>11</td>
    <td width=10%>24</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHERE</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>GC.choose</td>
    <td width=10%>2003-10-14 00:00:00+02</td>
    <td width=10%>2</td>
    <td width=10%>3</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-08-08 00:00:00+02</td>
    <td width=10%>2002-10-15 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-08-08 14:19:55+02</td>
    <td width=10%>2003-04-01 10:21:00.559+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98850></td>
    <td width=10%>41</td>
    <td width=10%>15</td>
    <td width=10%>26</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHEREDATAHEREDATAHERED
    ATAHEREDATAHERE</td>
    <td width=10%>GC.internalBusinessProcess</td>
    <td width=10%>2003-06-01 00:00:00+02</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-09-06 00:00:00+02</td>
    <td width=10%>2002-09-06 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-09-06 16:09:06+02</td>
    <td width=10%>2003-04-01 10:26:16.63+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98841></td>
    <td width=10%>31</td>
    <td width=10%>16</td>
    <td width=10%>26</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHERE</td>
    <td width=10%>GC.qualitatively</td>
    <td width=10%>2003-04-10 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-08-28 00:00:00+02</td>
    <td width=10%>2002-08-28 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-08-28 20:24:30+02</td>
    <td width=10%>2003-04-01 10:27:00.459+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98863></td>
    <td width=10%>22</td>
    <td width=10%>10</td>
    <td width=10%>47</td>
    <td width=10%>Gstehistory ist aktuell</td>
    <td width=10%>1</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHERE</td>
    <td width=10%>GC.customerRelated</td>
    <td width=10%>2003-04-14 00:00:00+02</td>
    <td width=10%>3</td>
    <td width=10%>3</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-08-24 00:00:00+02</td>
    <td width=10%>2002-08-24 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-08-24 14:10:31+02</td>
    <td width=10%>2003-04-01 09:15:54.838+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98862></td>
    <td width=10%>58</td>
    <td width=10%>17</td>
    <td width=10%>47</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHEREDATAHEREDATAHERED
    ATAHEREDATAHERE</td>
    <td width=10%>GC.customerRelated</td>
    <td width=10%>2003-04-16 00:00:00+02</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%>0</td>
    <td width=10%><br></td>
    <td width=10%>2002-09-12 00:00:00+02</td>
    <td width=10%>2002-04-16 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-09-16 13:26:43+02</td>
    <td width=10%>2003-04-01 09:16:40.135+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98857></td>
    <td width=10%>53</td>
    <td width=10%>12</td>
    <td width=10%>47</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHERE</td>
    <td width=10%>GC.customerRelated</td>
    <td width=10%>2004-01-30 00:00:00+01</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>0</td>
    <td width=10%>5</td>
    <td width=10%>2002-12-10 00:00:00+01</td>
    <td width=10%>2002-02-28 00:00:00+01</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>10</td>
    <td width=10%>2002-09-14 17:49:57+02</td>
    <td width=10%>2002-10-27 14:26:11.182+01</td>
    <td width=10%>4</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98854></td>
    <td width=10%>55</td>
    <td width=10%>12</td>
    <td width=10%>51</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE<
    /td>
    <td width=10%>GC.customerRelated</td>
    <td width=10%>2004-12-30 00:00:00+01</td>
    <td width=10%>1</td>
    <td width=10%>1</td>
    <td width=10%>3</td>
    <td width=10%>0</td>
    <td width=10%>1</td>
    <td width=10%>2002-12-10 00:00:00+01</td>
    <td width=10%>2004-12-30 00:00:00+01</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-09-14 18:18:33+02</td>
    <td width=10%>2003-04-01 09:34:36.277+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98858></td>
    <td width=10%>54</td>
    <td width=10%>12</td>
    <td width=10%>44</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHERE</td>
    <td width=10%>GC.customerRelated</td>
    <td width=10%>2003-04-15 00:00:00+02</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2003-01-15 00:00:00+01</td>
    <td width=10%>2003-03-30 00:00:00+01</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-09-14 18:05:35+02</td>
    <td width=10%>2003-04-01 09:40:04.517+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98878></td>
    <td width=10%>14</td>
    <td width=10%>17</td>
    <td width=10%>45</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHERE</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=a)
    DATAHEREDATAHEREDATAHEREDATAHEREDATAHERED
    ATAHERE></td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=b)
    DATAHEREDATAHEREDATAHEREDATAHERE></td>
    <td width=10%>GC.internalBusinessProcess</td>
    <td width=10%>2003-04-15 00:00:00+02</td>
    <td width=10%>1</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-09-01 00:00:00+02</td>
    <td width=10%>2003-04-15 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-08-08 14:31:11+02</td>
    <td width=10%>2003-04-01 09:45:09.809+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98876></td>
    <td width=10%>13</td>
    <td width=10%>12</td>
    <td width=10%>53</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE<
    /td>
    <td width=10%>GC.customerRelated</td>
    <td width=10%>2002-12-10 00:00:00+01</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-08-08 00:00:00+02</td>
    <td width=10%>2002-08-08 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-08-08 14:27:14+02</td>
    <td width=10%>2003-04-01 09:50:19.56+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98864></td>
    <td width=10%>24</td>
    <td width=10%>10</td>
    <td width=10%>25</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHERE</td>
    <td width=10%>1</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHERE</td>
    <td width=10%>GC.qualitatively</td>
    <td width=10%>2003-04-14 00:00:00+02</td>
    <td width=10%>1</td>
    <td width=10%>1</td>
    <td width=10%>2</td>
    <td width=10%>0</td>
    <td width=10%><br></td>
    <td width=10%>2002-12-10 00:00:00+01</td>
    <td width=10%>2003-04-14 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-08-24 14:32:57+02</td>
    <td width=10%>2003-04-01 10:22:17.077+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98872></td>
    <td width=10%>44</td>
    <td width=10%>6</td>
    <td width=10%>38</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHEREDATAHERE
    DATAHEREDATAHEREDATAHERE</td>
    <td width=10%>GC.finance</td>
    <td width=10%>2003-10-31 00:00:00+01</td>
    <td width=10%>1</td>
    <td width=10%>1</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-09-10 00:00:00+02</td>
    <td width=10%>2002-09-10 00:00:00+02</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-09-10 13:51:14+02</td>
    <td width=10%>2003-04-01 10:49:27.962+02</td>
    <td width=10%>18</td>
    </tr>
    <tr bgcolor=#b7b7b7>
    <td><input type=checkbox name=row value=98873></td>
    <td width=10%>43</td>
    <td width=10%>6</td>
    <td width=10%>38</td>
    <td width=10%>DATAHEREDATAHERE</td>
    <td width=10%>0</td>
    <td width=10%
    >DATAHEREDATAHEREDATAHEREDATAHERE</td>
    <td width=10%>GC.finance</td>
    <td width=10%>2003-10-31 00:00:00+01</td>
    <td width=10%>1</td>
    <td width=10%>1</td>
    <td width=10%>2</td>
    <td width=10%>1</td>
    <td width=10%><br></td>
    <td width=10%>2002-09-01 00:00:00+02</td>
    <td width=10%>2003-10-31 00:00:00+01</td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%><br></td>
    <td width=10%>1</td>
    <td width=10%>2002-09-10 13:41:10+02</td>
    <td width=10%>2003-04-01 10:53:03.546+02</td>
    <td width=10%>18</td>
    </tr>
    </table>
    <a href='' onClick='document.forms[0].row.checked = true; for
    (i=0; i<document.forms[0].row.length; i++) { document.forms
    [0].row[i].checked = true; } return false'>Select all</a> 
    <a href='' onClick='document.forms[0].row.checked = !
    document.forms[0].row.checked; for(i=0; i<document.forms
    [0].row.length; i++) { document.forms[0].row[i].checked = !
    document.forms[0].row[i].checked; } return false'>Invert
    selection</a><br>
    <table width=100%><tr>
    <td><input type=submit name=edit value='Edit selected
    rows'></td>
    <td align=middle><input type=submit name=new value='Add
    row'></td>
    <td align=right><input type=submit name=delete
    value='Delete selected rows'></td>
    </tr></table></form>
    <hr>
    </table></table><br>
    <table border=0 width=100% align=center cellspacing=0
    cellpadding=0 bgcolor=#6696bc><tr><td>
     <a href="edit_table.cgi?db=mydb-1&table=goal"><img
    alt="<-" align=middle border=0 src=/images/arrow.jpg></a>
     <a href="edit_table.cgi?db=mydb-
    1&table=goal">Return to field list</a>
    </td></tr></table>
    <br>
    </body></html>

     
  • Jamie Cameron

    Jamie Cameron - 2003-04-30

    Logged In: YES
    user_id=129364

    Do you have the DBI and DBD::mysql perl modules installed?
    They allow webmin to make a more reliable connection to the
    database, rather than parsing the output of the psql
    command, which as you can see does not always work ..

     

Log in to post a comment.

Auth0 Logo