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"
= a series of unknown bytes.
The data string "pageup" satisfies the last two requirements but not
the
first. Therefore you do not return a row. Solution = use "LIKE 'page%'
At 09:14 PM 5/15/04 +0200, you 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]
Sincerely,
Ed Porter
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
