Would this be a cached query you're looping then?? Seems that this would
take up a lot of memory in the initial query if you had a lot of content...
How would this compare to including static htm files that had been written
in the CMS (i.e. having a static file per language per page) -- anyone?
----- Original Message -----
From: "Allan Cliff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 11:48 AM
Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site
<CFLOOP QUERY="q_GetTexts">
<CFSET "application.T#textid#L#Languageid#" = Text>
</CFLOOP>
Single loop only.
----- Original Message -----
From: Damian Watson
To: [EMAIL PROTECTED]
Sent: Monday, October 06, 2003 12:40 PM
Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site
> Then Burn into application memory T1234L1 as variables in a double loop
That's kinda gone over my head... what does this mean? How would do you do
it?
Cheers :)
----- Original Message -----
From: "Allan Cliff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 11:36 AM
Subject: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site
I personally was going to have all the texts in 1 table related by textid,
languageid, text,
Then Burn into application memory T1234L1 as variables in a double loop
and
then read them from the page depending on a cookie. (if set)
T1234L#Languageid# on each page.
----- Original Message -----
From: Damian Watson
To: [EMAIL PROTECTED]
Sent: Monday, October 06, 2003 12:26 PM
Subject: [cfmail] Re: [ cf-dev ] Multi-language site
I've just been doing similar... I have different tables for each
language.
The site administrators can edit these in the CMS -- they are set up on
a
permissions basis to access content in certain languages.
When a user visits the site a session variable is set up called
session.lang
defaulted to "" which retrieves content from a table "tableName" -- then
if
they choose Swedish for example it is set to "sv_" -- this will then
retrieve content from sv_tableName through dynamic query.
This is handy in this instance as there is a pile of textual content on
this
site. Have other people done this or are there more suitable methods as
I
have several languages to go yet!
d
----- Original Message -----
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 11:05 AM
Subject: RE: [ cf-dev ] Multi-language site
> We personally use tables for this, and load them into Mem.....if you
need
> any info....please get in touch.
>
> -----Original Message-----
> From: Allan Cliff [mailto:[EMAIL PROTECTED]
> Sent: 06 October 2003 10:55
> To: CF - List
> Subject: [ cf-dev ] Multi-language site
>
>
> We are thinking of making a site multilanguage. Has anyone any
experience
on
> this?
>
> I did something a long time ago and i was planning to have a text
table
and
> a language table.
> Then to either send all the texts into the application scope and read
them
> from cf memory or call the db on every page?
>
> I suppose it would depend on the size of the texts etc.
>
> Anyone got any hands on experience. We are talking about a site with
more
> than 2 million hits per month.
>
> Thanks
>
> Allan
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
