Dear Collegues,
When I try to ad a record in a MySQL table I all the time get this error :
TMYSQLRECORDS:QUERYCURRENT(251)
Error MySQL/-1 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: TMYSQLRECORDS:QUERYCURRENT
Arguments: ( [ 1] = Type: C Val: SELECT * FROM org WHERE )
Does anybody know why this happens ? It looks like after WHERE there is some
text missing.
Thanx !
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
MySQL error
-
Lars Machiels
- Mensajes: 2
- Registrado: Jue Ene 29, 2009 3:47 pm
MySQL error
Lars,
> When I try to ad a record in a MySQL table I all the time get this error :
>
> TMYSQLRECORDS:QUERYCURRENT(251)
> Error MySQL/-1 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: TMYSQLRECORDS:QUERYCURRENT
> Arguments: ( [ 1] = Type: C Val: SELECT * FROM org WHERE )
>
> Does anybody know why this happens ? It looks like after WHERE there is
> some text missing.
Perhaps you are using a fieldname which is a reserved word in MySQL. Please,
show your table description.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
> When I try to ad a record in a MySQL table I all the time get this error :
>
> TMYSQLRECORDS:QUERYCURRENT(251)
> Error MySQL/-1 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: TMYSQLRECORDS:QUERYCURRENT
> Arguments: ( [ 1] = Type: C Val: SELECT * FROM org WHERE )
>
> Does anybody know why this happens ? It looks like after WHERE there is
> some text missing.
Perhaps you are using a fieldname which is a reserved word in MySQL. Please,
show your table description.
--
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info