Displaying 1 result from an estimated 1 matches for "dobalina".
Did you mean:
tobalina
2005 Jul 11
0
anyone using ENCODE and DECODE in SQL in ActiveRecord?
...table.
-- example SQL:
SELECT *, DECODE(ccnumblob, ''salthere'') AS ccnum FROM customers WHERE id=2;
UPDATE customers SET ccnumblob = ENCODE(''4321432143214321'',
''salthere'') WHERE id=2;
INSERT INTO customers (name, ccnumblob) VALUES (''Bob Dobalina'',
ENCODE(''4321432143214321'', ''salthere''));
How, in that case, would I pass that DECODE and ENCODE commands into
the SQL? I don''t think a find_by_sql will do it.
Since transforming the encoded data out of that database table will be
essential...