I hope someone can help me with this one. I need encryption for personal memos.
This statement worked at one time but now generates an error. Here is the statment:
INSERT INTO personal_memo SET PM_PI_ID='1',PM_PD_ID='1',PM_Meeting_Date='2008-10-20',PM_FollowUp_Date='2008-10-31',PM_Subject=VALUES(ENCODE('test for encryption','test')),PM_Memo=VALUES(ENCODE('Some information ','test')),PM_Shareable='Y',PM_LU_Date='2008-10-20 03:19:20',PM_LU_ID='1',PM_ST_ID='1'
The error using SQL in phpMyAdmin is:
Error
SQL query:
INSERT INTO personal_memo
SET PM_PI_ID = '1',
PM_PD_ID = '1',
PM_Meeting_Date = '2008-10-20',
PM_FollowUp_Date = '2008-10-31',
PM_Subject = VALUES (
ENCODE( 'test for encryption', 'test' )
), PM_Memo =
VALUES (
ENCODE( '10/20/2008 ', 'test' )
), PM_Shareable = 'Y', PM_LU_Date = '2008-10-20 03:19:20', PM_LU_ID = '1', PM_ST_ID = '1'
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENCODE('test for encryption','test')),PM_Memo=VALUES(ENCODE('Some information ','test'' at line 1
TIA,
Dick Deeds
