Re: [sqlite] LIKE problem

2004-05-15 Thread Sascha Kuehn
thanks all for the help. i got the error and i fixed it. sascha On 15. Mai 2004, at 23:23 Uhr, Ed Porter wrote: Hi Sascha, The query is doing exactly what you want it to do - it is looking for data that has: - a series of unknown bytes - a series of bytes representing "page"

Re: [sqlite] LIKE problem

2004-05-15 Thread Will Leshner
On May 15, 2004, at 12:32 PM, Sascha Kuehn wrote: i use mac os x 10.3 mysql version 2.8.13 i use the objective-c sqlite wrapper from Blackhole Media. i call the wrapper from an applescript i hope this helps Can you give the sqlite command-line tool a try. You've got a couple of layers in the middl

Re: [sqlite] LIKE problem

2004-05-15 Thread Sascha Kuehn
i use mac os x 10.3 mysql version 2.8.13 i use the objective-c sqlite wrapper from Blackhole Media. i call the wrapper from an applescript i hope this helps On 15. Mai 2004, at 21:26 Uhr, Tito Ciuro wrote: Sascha, no errors, everthing is fine. i just get no result :( Hum... If I change your SQL qu

Re: [sqlite] LIKE problem

2004-05-15 Thread Tito Ciuro
Sascha, no errors, everthing is fine. i just get no result :( Hum... If I change your SQL query to map my database, I get the expected rows. In my case I write the following: SELECT * FROM address WHERE last LIKE '%iur%' Works fine for me... Please give me more info: what OS are you using? SQLite

Re: [sqlite] LIKE problem

2004-05-15 Thread Sascha Kuehn
Sascha, On 15 may 2004, at 10:48, Sascha Kuehn wrote: here is my selectstatement: "SELECT * FROM WorkBook WHERE name LIKE '%page%'" the workbook table contains several rows where "name" contains "pageup" and i want to get only this rows. but the selectstatement doesn't work. can somebody help m

Re: [sqlite] LIKE problem

2004-05-15 Thread Tito Ciuro
Sascha, On 15 may 2004, at 10:48, Sascha Kuehn wrote: here is my selectstatement: "SELECT * FROM WorkBook WHERE name LIKE '%page%'" the workbook table contains several rows where "name" contains "pageup" and i want to get only this rows. but the selectstatement doesn't work. can somebody help m

[sqlite] LIKE problem

2004-05-15 Thread Sascha Kuehn
hi list, i'm new to SQLite and I have a problem with the LIKE command. here is my selectstatement: "SELECT * FROM WorkBook WHERE name LIKE '%page%'" the workbook table contains several rows where "name" contains "pageup" and i want to get only this rows. but the selectstatement doesn't work. can