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