[REBOL] Re: MySQL driver issue?
From: tim-johnsons:web at: 25-Aug-2007 16:54
On Saturday 25 August 2007, Kai Peters wrote:
> 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....
Hi Kai:
I don't use that method. I know that you will be hearing from DocKimbel or
someone else soon with insights. In the meantime, if you just need to get
up and running I could suggest another method:
;; factor out a port and open it
db: open mysql://theuser:thepassword-192.168.1.14:3306/thedatabase
insert db "SELECT * FROM donations where DonationAmount > 10 order by
DonationID" ;; string wrapped by my mailer
print db
;; try that and see if you get an error
Tim