I should've looked deeper into the code .. it's a very complex query that is dynamically generated, and it looks as though the constructed values string is plugged in directly rather than using %s substitution. That explains it, I guess.
Thanks for the help
On 9/3/07, Henrique Recidive <recidive@gmail.com> wrote:
Hello,
take a look at how variable_set does this:
http://api.drupal.org/api/function/variable_set/5
Henrique
2007/9/3, William Smith <
william.darren@gmail.com>:
> Hi all -
>
> I have an sql query that needs to insert a serialized array as one of the
> columns. However, the serialized data never makes it properly into the DB,
> I think because db_query strips out the curly braces. Take the following
> serialized associative array:
>
> 'a:2:{s:10:"Cardiology";s:10:"Cardiology";s:11:"Dermatology";s:11:"Dermatology";}'
> This ends up being stored as
> 'a:2:s:10:"Cardiology";s:10:"Cardiology";s:11:Dermatology";s:11:Dermatology";'
> (no curly braces), and I am therefore unable to unserialize() it.
>
> What is the way around this, other than fudging it and taking my result as a
> string and manually pushing the curly braces into place before attempting to
> unserialize?
>
> Thanks,
> William
>
>