List:MySQL++« Previous MessageNext Message »
From:Alexis Rodriguez Castedo Date:March 18 2008 12:57am
Subject:Problem with DateTime
View as plain text  
Hi:

I have a ssqls structure including a member of type mysqlpp::DateTime, when I 
try to insert the structure into the table, I received the following error:

ERROR: Incorrect datetime value: 'NOW()' for column 'Submit' at row 1

the member of type mysqlpp::DateTime was initialized  with the default 
constructor that will convert to SQL "NOW()" on insertion into a query 
(according with the refman), but when I print a query string before execute the 
insert, appears 'NOW()' with single-quotes instead of NOW() without 
single-quotes. What is wrong?, thanks in advance,

Using mysql++ 3.0. Great product!!!!!

Best Regards,

Alex

----------------------------------------------------------------------
          _/        _/_/_/_/              Alexis Rodríguez Castedo
       _/  _/      _/      _/       Dirección Sistemas de Información
     _/     _/    _/ _/_/_/     alexis.rodriguez@stripped
   _/ _/_/ _/    _/    _/                office: +34+983 218010
 _/          _/ _/       _/                   fax: +34+983 218011
-----------------------------------------------------------------------
Casu consulto
echo 16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlb xq |dc

Thread
Problem with DateTimeAlexis Rodriguez Castedo18 Mar
  • Re: Problem with DateTimeWarren Young18 Mar
  • Re: Problem with DateTimeAlexis Rodriguez Castedo18 Mar
    • Re: Problem with DateTimeWarren Young18 Mar