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 ------------------ (www.addept.ws)
435-616-2322 -------- (ammon at addept.ws)
[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