List:General Discussion« Previous MessageNext Message »
From:Christos J. Pontikis Date:July 27 1999 9:01am
Subject:Do you believe in ghosts ???
View as plain text  
Hello everybody,

well, it seems not to be a big problem, but I cannot explain something
happened.......

I use a simple perl DBI script to insert values from WWW interface

  $vardate_ts=&currentdate_ts;
  $strOPERATION="Addnew record.";
  $strSQLaddnew="INSERT INTO $table_name ".
                "(food, calories, category, date_inserted) ".
       "VALUES ('$row_food', $row_calories, $row_category,'$vardate_ts')";
...............etc........................

(sub currentdate_ts calculates current date)

It was 00 09 26 in the morning and when as I was trying to insert a record,
date_inserted field (type=timestamp) remained 00000000000000

Today morning insert operates normally, as well as previous days... (!!!).
No changes in the script (I was sleeping all night....)

If you don't believe me, see it by yourself (food6, food7).......

mysql> select * from calorimeter1 order by food limit 0,10;
+-----+-------------------------------------+----------+----------+----------------+----------------+
| id  | food                                | calories | category | date_updated   |
date_inserted  |
+-----+-------------------------------------+----------+----------+----------------+----------------+
| 465 | food1                               |        1 |        1 | 19990727000926 |
00000000000000 |
| 466 | food2α                              |        1 |        2 | 19990727110704 |
00000000000000 |
| 464 | food3                               |        1 |        1 | 19990727001856 |
19990726224343 |
| 467 | food4                               |        1 |        1 | 19990727002319 |
00000000000000 |
| 468 | food5a                              |        1 |        1 | 19990727110547 |
00000000000000 |
| 469 | food6                               |        1 |        4 | 19990727112703 |
19990727112703 |
| 470 | food7                               |        1 |        1 | 19990727112937 |
19990727112937 |


.......etc.......................................

Regards

Christos
http://www.medisign.gr





Thread
Do you believe in ghosts ???Christos J. Pontikis27 Jul
  • Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Van27 Jul
  • Re: Do you believe in ghosts ???Sasha Pachev27 Jul
Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Christos J. Pontikis27 Jul
  • Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Van28 Jul
Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Christos J. Pontikis28 Jul
  • Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Van28 Jul