[thelist] CF Question: Permutation of right(string, count)

Oliver Lineham oliver at lineham.co.nz
Mon Jan 8 19:23:26 CST 2001

At 15:23 8/01/2001 -0600, you wrote:


cripes, everyone's doing it these days.  ;)

On a db-backed site you'll find there's a bunch of settings you'll want the 
administrator to be able to set (for example, the "From" name to put on 
emails generated by the website).

One way of handling this is with a db table called something like 
"settings". This one table will hold all site settings.  It's just three 
columns: settingid, settingkey, settingvalue.  (The settingkey should be 
indexed, and unique - in fact, you could make it the primary key and do 
away with settingid)

The admin interface simply modifies these records.

I suggest you either cache the query, or store the data in application 
variables. For example, in Cold Fusion your application initialiser might 
retrieve all the settings records, and loop through each one copying it to 
an application.settings structure.


np: cowboy junkies - sweet jane

  phone +64 21 210-7845       http://www.vibe.co.nz/
  po box 10-492              wellington, new zealand

More information about the thelist mailing list