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 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]