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

rebol values in SQL statements.

 [1/3] from: c4pt41nz::slingshot::co::nz at: 14-Dec-2002 19:48

Hello list, Does anyone know a way to get around this restriction? : (from the documentation..) Because of ODBC restrictions, REBOL values cannot be used in SQL statements in the following ways: As WHERE values in SELECT statements As both elements in a comparison operation As both the first and second operands or the last operand of a BETWEEN operation As both expressions and the first value of an IN operation As the argument to the SET or AGGREGATE functions, which are SQL functions that return a single value from sets of values like SUM and COUNT Im trying to code some database stuff on windows, and I need to be able to use rebol variables in those situations. Any help is very appreciated. Cheers, Mike

 [2/3] from: ammon:addept:ws at: 14-Dec-2002 10:59

Hi, Not sure what you mean, but you might trying using something like 'compose to format your your query. If you could give an example of what you want then it is usually easier to help. Enjoy!! Ammon Johnson --- CIO Addept ------------------ ( 435-616-2322 -------- (ammon at

 [3/3] from: c4pt41nz:slingshot at: 15-Dec-2002 17:45

Yes, I fixed it , it was actually trivial to make something which puts together the query. Im just new to this.. thanks, Mike