mysql: tampered query error
am 20.10.2005 16:43:53 von enzo.arlatiI have mysql rev 4.1.12 running on win2000.
A program, build with c++builder 6 and mdac, with several thread, each
thread create it' own database connection and run it's own query.
It's happen that sometimes I get an error for some query which are correct,
if I retry it I run it sucessfully.
The error reported seems to refer to some other query or error or are
tampered with abnormal extra info.
see the example belowe.
I didn't understand what kind of problem I hav.
Does someone experctise similar problem ?
Reagrds, Enzo Arlati
[19/10/2005 15.47.03] [NewMyQuery](line=228) (SQL=SELECT messaggio,
operatore, priorita FROM stato_messaggi WHERE nome_nodo like 'P1302007'
and codice_msg like '' ) ERRORE 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 ''W' at line 1
[20/10/2005 15.16.57] [NewMyQuery](line=228) (SQL= select
max(data_prossimo_invio) max_data_prossimo_invio from coda_messaggi where
nome_nodo = 'P1301002' and codice_msg = 'W1' and data_prossimo_invio <
current_timestamp and ( data_prossimo_invio > data_ultimo_invio ) )
ERRORE 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
'WHERE nome_nodo like 'P1302013' AND codice_msg like 'W1' AND inviato =
0data_p' at line 1
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org