Can you check the client version and server version from c api? you can copy & paste it from (ehem) http://www.geocities.com/jahan.geo/mysql_c_by_example.html
VY wrote:
Hi,
For some reason, all my sql queries fail with a 1064; These were all working under mysql-4.0 but had to upgrade to 4.1 so i could use nested subqueries....
i have attached a simple 10 line c-code as proof of concept. Obviously there is nothing wrong with the query...
#include <stdio.h>
#include <stdlib.h>
#include <unistd.h>
#include <string.h>
#include <mysql.h>
static MYSQL handle;
int main() {
char query[1500];
int c;
mysql_init(&handle);
if (!mysql_real_connect(&handle, "localhost",
"mysql", "mysql", "honey_db", 0, NULL, 0)) {
fprintf(stderr, "connect failed %s\n",
mysql_error(&handle));
exit(1);
}
sprintf(query, "select * from test");
printf("%s\n", query);
c = mysql_real_query(&handle, query,
strlen(query)+500);
if (c)
{
printf("query failed...%d %d\n", c,
mysql_errno(&handle));
printf(mysql_error(&handle));
}
}
The output is as follows (the first two lines are my debug output)
select * from test query failed...1 1064
You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1:
I have tried both FreeBSD mysql-standard-4.1.3-beta-unknown-freebsd4.7-i386
and the linux-4.1.3 rpm with identical results.
Please let me know what im doing wrong.... The table "test" exists in honey_db and is accessible by the mysql user.
Thanks!
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
--
Aftab Jahan Subedar CEO/Software Engineer Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http://www.SubedarTechnologies.com http://www.DhakaStockExchangeGame.com/ http://www.CEOBangladesh.com/ http://www.NYSEGame.com tel://+88027519050 EMail://[EMAIL PROTECTED] - Directly to my notebook
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
