Hi Kevin,

On Mon, Oct 29, 2012 at 8:08 PM, Kevin Bailey
<kbai...@freewayprojects.com>wrote:

> Hi,
>
> I have set up a second database to act as a copy (for training) of the
> live database.  I'm setting up a cron job to re-copy the live to the
> copy every night.
>
> What I would like to do is to change the background colour for all the
> users when they log in to the copy site.  I need to run SQL something like:
>
> UPDATE user_preferences SET stylesheet = 'ledger-yellow.css';
>
> Could someone please correct my SQL and check what I want to do?
>

 The correct SQL statement would be:

update user_preference set stylesheet = 'gnome.css';

and I must say that the Gnome stylesheet seems to work best. I have no idea
what the intent of the others is, but they all look the same to me: white
background with unchanged fonts.

HTH,

Erik.
------------------------------------------------------------------------------
The Windows 8 Center - In partnership with Sourceforge
Your idea - your app - 30 days.
Get started!
http://windows8center.sourceforge.net/
what-html-developers-need-to-know-about-coding-windows-8-metro-style-apps/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Reply via email to