Hello, I need to work with some bind functions in libdbi. And I will test all and put on dbi_test.c.
Before, a little test whit the code: #include <stdio.h> #include <dbi/dbi.h> int main() { dbi_conn conn; dbi_result result; dbi_inst instance; double threshold = 1; unsigned int idnumber; const char *fullname = (char *)malloc(sizeof(char) * 30); int error; dbi_initialize_r(NULL, &instance); conn = dbi_conn_new_r("pgsql", instance); dbi_conn_set_option(conn, "host", "127.0.0.1"); dbi_conn_set_option(conn, "port", "5432"); dbi_conn_set_option(conn, "username", "regress"); //dbi_conn_set_option(conn, "password", ""); dbi_conn_set_option(conn, "dbname", "libdbitest"); 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 id, name FROM authors " "WHERE hours_of_sleep > %0.2f", threshold); if (result) { while (dbi_result_next_row(result)) { error = dbi_result_bind_uint(result, "id", &idnumber); dbi_result_bind_string(result, "name", &fullname); printf("%i. %s\n", idnumber, fullname); } dbi_result_free(result); } dbi_conn_close(conn); } dbi_shutdown_r(instance); return 0; } In database: libdbitest=# select * from authors; id | name | hours_of_sleep ----+-------+---------------- 1 | joao | 2 2 | joao | 2 3 | joao | 20 40 | joao | 20 40 | jOO | 2 40 | Erika | 2 40 | Er | 2 (7 registros) The result of program: ./dbi_bind_test custom_functions went to 0x804bcb0 custom_functions went to 0x804d498 custom_functions went to 0x8051a88 134514196. 2. joao 3. joao 40. joao 40. jOO 40. Erika 40. Er Two questions: 1. Is correct the use of bind functions? 2. Why the first result is 134514196. ? Thanks. -- ----------------------------------------------------------- João Henrique Freitas - joaohf_at_gmail.com Campinas-SP-Brasil BSD051283 LPI 1 http://joaohf.pbwiki.com http://www.livejournal.com/users/joaohf/ ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users