List:MySQL++« Previous MessageNext Message »
From:Simon Pickles Date:November 3 2010 1:56pm
Subject:Re: SSQLS and timestamps
View as plain text  

On 02/11/2010 17:43, Adrian Cornish wrote:
> #include<mysql++.h>
> #include<ssqls.h>
>
> sql_create_6( event_log,
>                 1, 6, // COMPCOUNT, SETCOUNT
>                 mysqlpp::sql_datetime, time,
>                 mysqlpp::sql_int_unsigned, id,
>                 mysqlpp::sql_int_unsigned, type,
>                 mysqlpp::sql_int, sidx,
>                 mysqlpp::sql_int, sidz,
>                 mysqlpp::sql_character_varying, detail )
> int main()
> {
>     mysqlpp::Connection conn;
>     conn.connect("test", "localhost", "adrianc");
>     mysqlpp::Query query=conn.query();
>
>     event_log row(mysqlpp::DateTime::now(), 1, 2, 3, 4, "a test string");
>     query.insert(row);
>     query.exec();
>
>     return 0;
> }

Hi Adrian/Warren,

Here's the output:

mysql> select * from event_log;
+---------------------+----+------+------+------+---------------+
| time                | id | type | sidx | sidz | detail        |
+---------------------+----+------+------+------+---------------+
| 0000-00-00 00:00:00 |  1 |    2 |    3 |    4 | a test string |
+---------------------+----+------+------+------+---------------+
1 row in set (0.01 sec)

Platform:
Ubuntu Jaunty 9.04
MySQL 5.0.75-0ubuntu10.5 (Ubuntu)
mysqlpp 3.0.9

I will build 3.1.0 and try again

Thanks

Simon


Thread
SSQLS and timestampsSimon Pickles2 Nov
  • Re: SSQLS and timestampsAdrian Cornish2 Nov
    • Re: SSQLS and timestampsSimon Pickles2 Nov
      • Re: SSQLS and timestampsAdrian Cornish2 Nov
        • Re: SSQLS and timestampsSimon Pickles3 Nov
          • Re: SSQLS and timestampsSimon Pickles4 Nov
    • Re: SSQLS and timestampsWarren Young2 Nov