Hello, I have a temp table setup with a mediumblob in it. I am using a C
program to pull information out of the database. However, my problem is
that when the message is greater then around 10k it dies. If it is less
then 10k it works without any problems. I know other people have pulled
more then 10k from a mysql database without a problem, so I am wondering
if there some sort of trick. Or if there is a 10k limit on
mysql_fetch_row() or mysql_store_result when they are defined as
MYSQL_RES *resulst and MYSQL_ROW row. It is not crashing the server, but
instead it is overflowing in my program and crashing it. I can do the
query from the consol without any problems.
Any thoughts?
sprintf(sqlbuf, "SELECT message FROM temp_mail WHERE incomingid =
'%d'", msg_id);
if (mysql_real_query(&db, sqlbuf, strlen(sqlbuf)) != 0) {
fprintf(fp, "mysql error: %s\n", mysql_error(&db));
fflush(fp);
return 0;
}
if(!(result = mysql_store_result(&db))) return -1;
MYCOUNT = mysql_num_rows(result);
if(MYCOUNT > 0) {
row = mysql_fetch_row(result);
printf("%s", row[0]);
}
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
