Re: [sqlite] SQL error: no such function: replace

2009-02-26 Thread BareFeet
Hi Ben, > Unfortunately though I don't have the option of updating it, since I > am > using it on a very widespread set of machines which I don't have root > privileges on... You don't necessarily have to install the newer SQLite at system level. You could incorporate it into your app or inst

Re: [sqlite] SQL error: no such function: replace

2009-02-25 Thread Igor Tandetnik
BenJones12345 wrote: > Ah... its version 3.3.5 > > Unfortunately though I don't have the option of updating it, since I > am using it on a very widespread set of machines which I don't have > root privileges on... > > Is there another way I can achieve the same effect without this > function? If

Re: [sqlite] SQL error: no such function: replace

2009-02-24 Thread BenJones12345
Ah... its version 3.3.5 Unfortunately though I don't have the option of updating it, since I am using it on a very widespread set of machines which I don't have root privileges on... Is there another way I can achieve the same effect without this function? Thankyou both for your awesomely fast

Re: [sqlite] SQL error: no such function: replace

2009-02-24 Thread John Machin
On 25/02/2009 1:13 PM, BenJones12345 wrote: > Hi all > > I'm very much a beginner with sqlite3 and and I'm completely stumped with > using the replace function. > > What I have is a field (TheOldField) with values like: > > HM1 > HP4 > HM3 > HM2 > > and I need to replace all "P" with "+" and al

Re: [sqlite] SQL error: no such function: replace

2009-02-24 Thread P Kishor
On Tue, Feb 24, 2009 at 8:13 PM, BenJones12345 wrote: > > Hi all > > I'm very much a beginner with sqlite3 and and I'm completely stumped with > using the replace function. > > What I have is a field (TheOldField) with values like: > > HM1 > HP4 > HM3 > HM2 > > and I need to replace all "P" with "

[sqlite] SQL error: no such function: replace

2009-02-24 Thread BenJones12345
Hi all I'm very much a beginner with sqlite3 and and I'm completely stumped with using the replace function. What I have is a field (TheOldField) with values like: HM1 HP4 HM3 HM2 and I need to replace all "P" with "+" and all "M" with "-", and put the result into a new field (TheNewField). A