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

[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