Krata,
Friday, August 16, 2002, 5:10:20 PM, you wrote:
K> Hi,
K> i am using mysql c api to send some queries to mysql server which is on
K> another computer (100MBit almost next to the client)
K> in my code i am doing this
K> if (mysql_real_query(mysql,query,strlen(query)))
K> {
K> fprintf(stderr,"In query : \"%s\"\n",query);
K> fprintf(stderr,"Error occured : %s\n",mysql_error(mysql));
K> }
K> and this sometimes (e.g. 1 from 1.000.000 sends) do this :
K> In query : "insert into TR_ITEMS_TEMP
(PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX) values (-70,500,0,8052,2,8301)
K> "
K> Error occured : Unknown column 'QR_ID' in 'field list'
K> In query : "insert into TR_ITEMS_TEMP
(PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX) values (-70,500,0,8052,2,8301)
K> "
K> do someone know what should be the problem?
K> Server is Win2K and has latest mysql server installed client is the one
K> from RedHat 7.3 (3.23.49) (=`mysql_config --version`)
8-[ ]
I tested your example and it works nice...
Do you always get this error or you got it just once?
Does error occur if you execute query via mysql command line client
tool?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
