Simon Slavin-3 wrote:
>
>
> 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, ' 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
>
>
I don't know any. Well, i know some VB but i wouldn't even know where to
begin. I guess I will look into it unless there are some other replys....
--
View this message in context:
http://old.nabble.com/sql-function-to-change-multiple-links-within-a-DB-tp32376393p32376446.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
