Re: [sqlite] OSX path

2011-06-18 Thread Sven Utcke
Hello John, > As for "top-posting," In the corporate culture I come from, it is > considered the only way to do things (or at least one faction who > has the ear of the ops boss, believes this). Yes, I noticed that too. I can think of two reasons for doing things in this terribly inefficient way

Re: [sqlite] select (partly) url-encoded strings?

2011-06-17 Thread Sven Utcke
Hello Igor Tandetnik, > On 6/17/2011 6:11 PM, Sven Utcke wrote: > > Actually, the above would be awfully slow (as it can not use the > > index). It might be better to use an intermediate table (but of > > course still filled using urldecode()), what is the recommended >

Re: [sqlite] select (partly) url-encoded strings?

2011-06-17 Thread Sven Utcke
Hello Igor, > On 6/17/2011 5:36 PM, Sven Utcke wrote: > > I might see a name > > like "image 1 (modified%20(2)).jpg". Since I can not forsee which > > parts might have been encoded and which not, I therefore need to write > > something like: > >

[sqlite] select (partly) url-encoded strings?

2011-06-17 Thread Sven Utcke
Hi, let me introduce myself first: I'm new to this list (but not SQL), using sqlite3 mostly in order to write exporters from my face-recognition tool to some photo management software (F-Spot and Digikam, currently), but also some convenience functions (mostly for F-Spot). And that's actually whe