Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

[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