[REBOL] MySQL driver issue?
From: kpeters::otaksoft::com at: 25-Aug-2007 13:57
The query below fails:
"SELECT * FROM donations where DonationAmount > 10 order by DonationID"
** User Error: URL error: mysql://theuser:thepassword-192.168.1.14:3306/thedatabase?SELECT
* FROM donations where DonationAmount > 10 orde...
** Near: cursor: read rejoin [mysql-url "?" querystr]
while this one works:
"SELECT * FROM donations where DonationAmount = 10 order by DonationID"
DonationAmount happens to be a decimal 8.2 in this case
These queries work just fine from any MySQL client on all platforms.
It seems that including an operator like '>' or '<' is causing the problems. Escaping
issue? Re-read the docs but
am unsure what this might be....
Thanks,
Kai