Re: need possible solution to remove VALUES being quoted

[Grant Cox]

Try putting -! in front of the command, eg
$data = array( 'data' => '-!AES_ENCRYPT(value,key)' );

More detail on Daniel's blog (
http://cakebaker.42dh.com/2007/05/22/how-to-use-sql-functions-in-conditions-part-ii/
)

On Jul 28, 11:56 pm, rpeterson <[EMAIL PROTECTED]> wrote:
> Also, I am using Cake 1.2 latest, and here is the behavior for
> reference,http://bin.cakephp.org/view/166336900


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Re: need possible solution to remove VALUES being quoted

[rpeterson]

Also, I am using Cake 1.2 latest, and here is the behavior for
reference, http://bin.cakephp.org/view/166336900


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

need possible solution to remove VALUES being quoted

[rpeterson]

Hello Groupies,

I have created and AES encryption behavior to use MySQL AES_ENCRYPT
and AES_DECRYPT for an array of fields.  Everything is working except
that on the save I can't find a way to get Cake not to add quotes
around the values. So instead of getting the values with
AES_ENCRYPT(value,key) I am getting 'AES_ENCRYPT(value,key)'. I have
till Monday to resolve this because of deadlines on the project. Any
assistance would be greatfull.

~rpeterson


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---