On Friday 04 February 2005 03:31 pm, John Trammell wrote: > In my version of MySQL (4.1.9), your sample code generates an error: > > mysql> select decode(encode("foo")); > ERROR 1064 (42000): 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 '))' at line 1
your right, i was mistaken.. I use: select des_decrypt(des_encrypt("foo")); which works fine.. I am not sure what version he is using, but that should have worked. Jeff
pgp7spCyw8ane.pgp
Description: PGP signature