On 1 Sep 2011, at 12:37am, teahou wrote:

> The closest I have come is to do it in parts, I came up with this:
> 
> UPDATE questions SET answer = REPLACE(answer, '<a href=''/FAQ/', '<a
> style="text-decoration: underline; color: blue"
> onclick="Ti.App.fireEvent(''openContent'', {kind: ''FAQ'', find: "' );
> 
> As you can see, this just does the first part, and forces me to do each
> category individually.  
> 
> I had thought to use a combination of substr/instr but the link locations
> vary, it could be at the beginning of the text, or it could start after 100
> characters.

Do it in software.   That's what programming languages are for.  10 seconds to 
take a backup copy of the database.  30 minutes to write the program and test 
it, 10 seconds to run it.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to