Re: [Phpwiki-talk] DBAUTH_PREF_INSERT

[John S. <jst...@gm...>]

Hi Thomas,
It was meant to allow for you to configure the INSERT clause for the backen=
d
DB you use. This was the for Oracle. Since Oracle does not have a REPLACE
clause (MySQL specific), I used this to to do an initial INSERT for user
prefs. Without it, user prefs were never saved or updated. See my Rant ;)
Regards

On 10/13/05, Thomas Harding <tho...@la...> wrote:
>
> Hello,
> I've just updated my cvs repository.
>
> In config/config-dist.ini, I see :
> ; DBAUTH_PREF_INSERT =3D "INSERT INTO pref SET prefs=3D'$pref_blob',
> userid=3D'$userid'"
>
> This is not compatible with Postgresql !
>
> The good statement for _all_ SQL SGBDRs is :
> DBAUTH_PREF_INSERT =3D "INSERT INTO pref (prefs,userid) VALUES
> ('$pref_blob','$userid')"
>
> While config-dist.ini is used by the configurator, it will be wise to
> correct this :)
>
> Greetings,
> --
> Thomas Harding
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>