Displaying 2 results from an estimated 2 matches for "ccnum".
Did you mean:
cnum
2006 Mar 08
1
MSSQL error - 80004005 & Rails
...gin_name] = ''foo'', [lname] = ''bar'',
[hl_perclick_charged] = NULL, [hl_active] = 0, [zip] = '''', [address1] =
'''', [modDT] = NULL, [country] = NULL, [province] = '''', [password] =
''password'', [ccNum] = '''', [hearabout] = ''Foo Bar'', [last_logon] = NULL,
[site] = ''hk'', [creatDT] = ''2006-03-08 11:48:09'', [ccExpMonth] = NULL,
[email] = ''foo@foobar.com'' WHERE user_id = 10560.0
does anybody have any ideas how...
2005 Jul 11
0
anyone using ENCODE and DECODE in SQL in ActiveRecord?
I keep some sensitive information encoded using MySQL''s ENCODE and
DECODE commands in the database 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(''432143214...