From: Dan Nelson
Date: May 28 2004 6:38pm
Subject: Re: mysql_qury returns -1!
List-Archive: http://lists.mysql.com/mysql/166362
Message-Id: <20040528183824.GD4375@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 28), Bono, Saroj AA R62 said:
> Non zero indicates an error but the possible values are (from
> errmsg.h) Return Values Zero if the query was successful. Non-zero if
> an error occurred.
>  
> Errors
> CR_COMMANDS_OUT_OF_SYNC 
> Commands were executed in an improper order. 
> CR_SERVER_GONE_ERROR 
> The MySQL server has gone away. 
> CR_SERVER_LOST 
> The connection to the server was lost during the query. 
> CR_UNKNOWN_ERROR 
> An unknown error occurred. 
> 
> which have values in th erange 2000 to 2027. So its not teeling me
> what made the sql_query fail. The database of course doesnt get
> created, but I cant even see why it failed.........since my return
> val from mysql_query is -1.

Call mysql_error() or mysql_errno().

http://dev.mysql.com/doc/mysql/en/C_API_functions.html

-- 
	Dan Nelson
	dnelson@stripped