Re: [sqlite] LIKE problem

[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 version?
Regards,
-- Tito
On 15 may 2004, at 15:14, Sascha Kuehn wrote:
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 me?
I don't see anything wrong with the query.
Check for the following:
1) Does the table WorkBook exist?
yes
2) If so, does the column exist?
yes
3) If so, are you sure there a rows where the column 'name' contain 
'page'?
yes
Check what sqlite_get_table() reports: what's the result code? Any 
errors in the error message string?
no errors, everthing is fine.
i just get no result :(

Regards,
-- Tito

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]