Je pense que avant 4.1 SUBSTRING() existait, mais par contre il n'acceptait apparemment pas le second paramètre en négatif.
http://dev.mysql.com/doc/refman/4.1/en/string-functions.html#function_substring Yannick Le dimanche 12 août 2007 à 21:43 +0200, Régis Houssin a écrit : > oui effectivement, apparement la fonction substr dans une requete mysql est > apparu à partir de la version 4.1 de mysql et tu utilises la 4.0 > > il faudrait trouver un substitut de cette commande > > Régis > > > > On Fri, 10 Aug 2007 17:22:30 +0200, [EMAIL PROTECTED] wrote: > > Bonjour, > > > > Je vous ennuie encore avec les pb de mise à jour. > > Ci-joint les messages : > > > > Erreur DB_ERROR_SYNTAX: update llx_boxes set box_order = > > concat('A0',box_order) where length(box_order) = 1 and > > substr(box_order,-1) in ('1','3','5','7','9'); > > 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 '(box_order,-1) in ('1','3','5','7','9')' at line 1 > > Request 657 sql='update llx_boxes set box_order = > > concat('B0',box_order) where length(box_order) = 1 and > > substr(box_order,-1) in ('0','2','4','6','8');' > > Erreur DB_ERROR_SYNTAX: update llx_boxes set box_order = > > concat('B0',box_order) where length(box_order) = 1 and > > substr(box_order,-1) in ('0','2','4','6','8'); > > 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 '(box_order,-1) in ('0','2','4','6','8')' at line 1 > > Request 658 sql='update llx_boxes set box_order = > > concat('A',box_order) where length(box_order) = 2 and > > substr(box_order,-1) in ('1','3','5','7','9');' > > Erreur DB_ERROR_SYNTAX: update llx_boxes set box_order = > > concat('A',box_order) where length(box_order) = 2 and > > substr(box_order,-1) in ('1','3','5','7','9'); > > 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 '(box_order,-1) in ('1','3','5','7','9')' at line 1 > > Request 659 sql='update llx_boxes set box_order = > > concat('B',box_order) where length(box_order) = 2 and > > substr(box_order,-1) in ('0','2','4','6','8');' > > Erreur DB_ERROR_SYNTAX: update llx_boxes set box_order = > > concat('B',box_order) where length(box_order) = 2 and > > substr(box_order,-1) in ('0','2','4','6','8'); > > 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 '(box_order,-1) in ('0','2','4','6','8')' at line 1 > > Exécution du script > > > > Ci-joint ma config : MySQL 4.0.24_Debian-10sarge2 > > > > Cordialement, > > > > Mathias > > > > > > > > > > _______________________________________________ > > Dolibarr-dev mailing list > > [email protected] > > http://lists.nongnu.org/mailman/listinfo/dolibarr-dev _______________________________________________ Dolibarr-dev mailing list [email protected] http://lists.nongnu.org/mailman/listinfo/dolibarr-dev
