How to retrieve integer in C prog?

[Andy Jackman]

Hi,
I'm new to mySql. I've got a table with an integer field defined like
this:
l_start_wait int(9) not null
I inserted a value into the table using mysql command line client with:
Insert into tbl_wait_list values(12345678);

When I use mysql_fetch_row() to retrieve the column values I am
surprised to see
that mysql_fetch_lengths() returns a length of 8 rather than 4 and
row[0] seems to
point to bytes containing ascii characters "12345678" rather than being
a pointer
to an int.

I've searched the manual and google but apart from occasional references
to blob
data most examples seem to assume that all data is ascii.

What I'd like to be able to do is something like this: int i =
(cast)row[0];

Please tell me what I'm doing wrong - or is this a limitation?
Thanks,
Andy.

Here's my code fragment if it helps:

int checkWaitList(MYSQL *aDb)
{
// aDb connection is already open
MYSQL_RES *rsResult;
MYSQL_ROW row;
char pszSql[256];
int lStartTime;
unsigned long *lengths;

strcpy(pszSql, "SELECT l_start_wait FROM tbl_wait_list");
mysql_query(aDb,pszSql);
rsResult = mysql_use_result(aDb);

if (row = mysql_fetch_row(rsResult)) {
lengths = mysql_fetch_lengths(rsResult);
sprintf(pszSql, ">>%d, %12.12s<<\r\n", lengths[0], row[0]);
// Prints >>8, 12345678<<
return -1;
}
else {
return 0;
}
}


mysql_query(aDb,pszSql);
rsResult = mysql_use_result(aDb);

if (row = mysql_fetch_row(rsResult)) {
lengths = mysql_fetch_lengths(rsResult);
// Found a row
tsOut("Found: " );
tsOut("\r\n");
//lStartTime = *(int *)row[1];
sprintf(pszSql, ">>%ud, %12.12s<<\r\n", lengths[0], row[0]);

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw