thanks for the push in the right direction. :)
Shawn
Main Topics
Browse All TopicsI am redoing parts of a website and rather than having a different page per language I have set up a table tblMesseges with different languages in seperate columns.
My question is when would it be best for me to call these messages? Should I call them all at the beginning, meaning straight from the application.cfm file and when a person clicks on the language button to switch languages or should I have a query at the top of each page that calls the messages?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: srikanthmadishettiPosted on 2009-07-04 at 03:23:15ID: 24776509
I would sugest write a query and on the fly pass the langid to it.
For example :
<cfquery name='langmsgs" datasource ="yourdsn">
Select * from where langid = < which you will pass on the select of lang ->
</cfquery>
The query 'langmsgs contains the record of the language id which you pass
this query ill be written at one place which as you think can be applicaiton.cfm .