Re: [Dolibarr-dev] erreur cvs

[Yannick Warnier]

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, address@hidden 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
> > address@hidden
> > http://lists.nongnu.org/mailman/listinfo/dolibarr-dev