[REBOL] Re: MySQL driver issue?
From: kpeters::otaksoft::com at: 25-Aug-2007 19:50
Tim ~
tested a bit more based on your suggestion and here's what I get:
print send-sql db "select * from donations where donationamount > 50" works just fine
print read join mysql://theuser:thepassword-192.168.1.14:3306/thedatabase? "SELECT *
from donations where donationamount > 50" fails
** User Error: URL error: mysql://theuser:thepassword-192.168.1.14:3306/thedatabase?
"SELECT * from donations where donationamount > 50
** Near: print read join mysql://theuser:thepassword-192.168.1.14:3306/thedatabase? "SELECT
* from donations > ...
I had emailed DocKimbel about another error I get when using the shortcut command from
above: On one of my tables a simple query for
... LastName = '%ee%' ... returns a bunch of unrelated records - all other queries for
other character combinations seem to work just fine.
Kai
On Sat, 25 Aug 2007 16:54:11 -0800, Tim Johnson wrote: