Ken
Shouldn't you have a time_t (unsigned long) for the
time return type (and a dbi_result_get_long or whatever
to extarct it)?
On Mon, 17 Nov 2008, Ken Ramsay wrote:
> Guys
>
> I am trying to get info from a mysql database that stores the date in a
> string format and return UTC format as well as a associated value. I can
> use the following select() statement OK to take care of that :
> mysql> select UNIX_TIMESTAMP(<Timestamp string>),<data
> fields> from <table>;
>
> This gives all the values in the table and the UTC timeformat
>
> So, next I built libdbi was able to run a simple db connection to test
> it all worked. I then moved on to try the above and got my values OK but
> I get '0''s for the UTC TIMESTAMP. Anyone any ideas why this doesn't
> work?
>
> Cheers
>
> Here's my src which compiles and runs OK but gives the partial output
> below.. Any ideas ( I have played with the printf statement already ;-)
> ?
>
>
> #include <stdio.h>
> #include </usr/local/include/dbi/dbi.h>
>
> int main() {
> dbi_conn conn;
> dbi_result result;
> unsigned int updateLatency;
> unsigned int time;
> const char *name;
>
> dbi_initialize(NULL);
> conn = dbi_conn_new("mysql");
>
> dbi_conn_set_option(conn, "host", "localhost");
> dbi_conn_set_option(conn, "username", "sqluser");
> dbi_conn_set_option(conn, "password", "");
> dbi_conn_set_option(conn, "dbname", "test");
> dbi_conn_set_option(conn, "encoding", "UTF-8");
>
> if (dbi_conn_connect(conn) < 0) {
> printf("Could not connect. Please check the option settings\n");
> }
> else {
> result = dbi_conn_queryf(conn, "select
> UNIX_TIMESTAMP(HIST_Timestamp),HIST_Node,updateLatency from TABLE");
>
> if (result) {
> while (dbi_result_next_row(result)) {
> name = dbi_result_get_string(result, "HIST_Node");
> time = dbi_result_get_uint(result,
> "UNIX_TIMESTAMP(HIST_Timestamp)");
> updateLatency = dbi_result_get_uint(result, "updateLatency");
> printf("%s %d %d\n",name,updateLatency,time);
> }
> dbi_result_free(result);
> }
> dbi_conn_close(conn);
> }
>
> dbi_shutdown();
>
> return 0;
> }
>
> Sample Output:
> chimds05 34 0
> chimds05 12 0
> chimds05 13 0
> chimds05 20 0
> chimds05 10 0
> chimds05 13 0
>
>
>
> This email was sent to you by Thomson Reuters, the global news and
> information company.
> Any views expressed in this message are those of the individual sender,
> except where the sender specifically states them to be the views of Thomson
> Reuters.
>
>
--
J.J. Green, Dept. Applied Mathematics, Hicks Bld.,
University of Sheffield, UK. +44 (0114) 222 3742
http://sview01.wiredworkplace.net/pub/jjg
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
libdbi-users mailing list
libdbi-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-users
