Re: [Treebase-devel] phylowidget issue

[Hilmar L. <hl...@ne...>]

On Oct 29, 2010, at 11:28 AM, William Piel wrote:

> The temporary solution for this particular study is to go through  
> records where phylotree_id is between 9407 and 9414 and check that  
> the string stored in the newickstring field ends in a ";".  I would  
> do this with Navicat, but I don't have access to the production  
> database.

Bill - shouldn't this be an SQL script that goes through the whole  
database? I.e., why is this more complicated than  UPDATE phylotree  
SET newickstring = newickstring || ';' WHERE STRPOS(newickstring,';')  
< LENGTH(newickstring)

	-hilmar

-- 
===========================================================
: Hilmar Lapp  -:- Durham, NC -:- informatics.nescent.org :
===========================================================