Hi,
When i use the mysqlclient to view some data from the table KLASSEN i get
some strange partially missing data.
like this:
select DISTINCTROW * from KLASSEN where KlasseID='Y_FILTER' order by
Kenmerk;
+----------+---------+--------------------------+
| KlasseID | Kenmerk | Omschrijving |
+----------+---------+--------------------------+
|ILTER | 1 | Figuurnummer Alkmaar
|ILTER | 2 | Figuurnummer Hoboken
|TER | 3 | Figuurnummer ERIKS
|| 4 | Materiaal huis
|Y_FILTER | 5 | Materiaalkwaliteit huis
|Y_FILTER | 6 | Materiaal filterelement
| 7 | Fabrikant
|TER | 8 | Codering fabrikant
|ILTER | 9 | Afmeting aansluiting
|ER | 10 | Uitw buisdiameter
| 11 | Aansluiting 1
| 12 | Aansluiting 2
|R | 13 | Druktrap artikel
|| 14 | Druktrap flens
|ER | 15 | Beschermingswijze
|ILTER | 16 | Materiaal afdichting
| 17 | Incl aftapper
| 18 | Incl element
|ER | 19 | Inbouwlengte [mm]
| 20 | Maaswijdte
+----------+---------+--------------------------+
20 rows in set (0.00 sec)
While it should be like this :
select DISTINCTROW * from KLASSEN where KlasseID='Y_FILTER' order by
Kenmerk;
+----------+---------+--------------------------+
| KlasseID | Kenmerk | Omschrijving |
+----------+---------+--------------------------+
| Y_FILTER | 1 | Figuurnummer Alkmaar
| Y_FILTER | 2 | Figuurnummer Hoboken
| Y_FILTER | 3 | Figuurnummer ERIKS
| Y_FILTER | 4 | Materiaal huis
| Y_FILTER | 5 | Materiaalkwaliteit huis
| Y_FILTER | 6 | Materiaal filterelement
| Y_FILTER | 7 | Fabrikant
| Y_FILTER | 8 | Codering fabrikant
| Y_FILTER | 9 | Afmeting aansluiting
| Y_FILTER | 10 | Uitw buisdiameter
| Y_FILTER | 11 | Aansluiting 1
| Y_FILTER | 12 | Aansluiting 2
| Y_FILTER | 13 | Druktrap artikel
| Y_FILTER | 14 | Druktrap flens
| Y_FILTER | 15 | Beschermingswijze
| Y_FILTER | 16 | Materiaal afdichting
| Y_FILTER | 17 | Incl aftapper
| Y_FILTER | 18 | Incl element
| Y_FILTER | 19 | Inbouwlengte [mm]
| Y_FILTER | 20 | Maaswijdte
+----------+---------+--------------------------+
Describe KLASSEN :
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| KlasseID | varchar(64) | | | | |
| Kenmerk | int(11) | | MUL | 0 | |
| Omschrijving | varchar(64) | | | | |
+--------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
When i do the query from a PHP script i get the correct data though !?
How can i solve this? and what is the cause? OR what have we done wrong?
Kind regards,
Gerry
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
