"P Kishor" wrote... > On Sun, Oct 10, 2010 at 11:05 PM, jose isaias cabrera > <cabr...@wrc.xerox.com> wrote: >> >> Greetings. >> >> I would like some help with this scenario... DB name OpenJobs. >> >> id,pid,spid,notes >> 100, 24,32,'this is a test' >> 101, 24,32,'a different note' >> 102, 24,32,'yet, another different note' >> ... >> >> What I dould like to do is to update each of those notes by adding a >> string >> to the front of data contained in the notes. The final DB data would look >> like this: >> >> id,pid,spid,notes >> 100, 24,32,'string to add in front\r\nthis is a test' >> 101, 24,32,'string to add in front\r\na different note' >> 102, 24,32,'string to add in front\r\nyet, another different note' >> ... >> >> I have come up with this: >> >> UPDATE OpenJobs SET notes = 'string to add in front\r\n' || >> (SELECT notes from OpenJobs where spid = 32) WHERE spid = 32; >> > > UPDATE OpenJobs > SET notes = 'string to add in front\r\n' || notes > WHERE spid = 32;
That easy, huh? I knew it. thanks, josé >> But I don't think it's going to work. >> >> Any help would be greatly appreciated. >> >> thanks. >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > Puneet Kishor http://www.punkish.org > Carbon Model http://carbonmodel.org > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > ----------------------------------------------------------------------- > Assertions are politics; backing up assertions with evidence is science > ======================================================================= > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
