**All** of the output on my site comes from the database. I have a languages table which can be completely maintained in my admin section. I do exactly like someone else mentioned a few posts ago. I load my languages into an application variable that's an array of structures. This makes everything so easy. When someone selects Spanish, I just set their session.useLanguage variable to 2 (Spanish is the database langID #2) and everywhere I output a bit of text it just comes right from that set of variables like this: <cfoutput> #application.language[session.useLanguage].welcomemessage# </cfoutput>
It really works out well and is incredibly easy to maintain and extend. --Ferg ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199659 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54