Re: [Treebase-devel] phylowidget issue

[William P. <wil...@ya...>]

On Oct 31, 2010, at 11:20 PM, Hilmar Lapp wrote:

> 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

Yeah, that should work. 

(though, note that I'm not positive that the problem is due to a missing ";" in the newickstring field -- the database that I have access to is a version that pre-dates the addition of these problem trees)

bp