[development] db_query and serialized arrays

[William Smith]

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 at 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 at 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
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20070903/fe146c6b/attachment.htm