Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 20th, 2004, 05:59 AM
Registered User
 
Join Date: Jun 2003
Location: karachi, , Pakistan.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to asifqua
Default Multi language web site

Hi all,
i want to design a multi language web site just like www.un.org . i wants that a user select the desire langauge and then the page should translate into that language autometically.

i have all the text in english. is it possible that all the text of the translat autometically into the particular langauge when a user select the desire language.i.e french , arabic ,chinees , spenish etc.

regards,
Asif Hameed
Reply With Quote
  #2 (permalink)  
Old September 20th, 2004, 06:19 AM
Friend of Wrox
Points: 1,288, Level: 14
Points: 1,288, Level: 14 Points: 1,288, Level: 14 Points: 1,288, Level: 14
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2004
Location: Stockholm, Sweden
Posts: 331
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to qazi_nomi
Default

Dear Asif there is I think no methode to translte the web pages and as for as this web site which you mention is concern in it each web page is separately build in each language.




Numan
--------------------------------------------------
Love is the most precious thing of this world. So find it and grab it!
Reply With Quote
  #3 (permalink)  
Old September 22nd, 2004, 06:51 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

You should have the content ready in different languages and store them all into database, that is well designed, and pull the data pertaining to that language based on user's selection on the web page, this is how all such multilingual websites be working.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #4 (permalink)  
Old September 30th, 2004, 09:15 AM
Authorized User
 
Join Date: Sep 2004
Location: , , .
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

here is one easy way to do the language switch thats the one I use and it works like a charm:

Create an ASP page and name it language.asp. Store it in the root of your Web site. Include the following code before the HTML tag on the page.

Code:
<%@ LANGUAGE="VBSCRIPT" %>
<%
sString = Request.ServerVariables("HTTP_REFERER")
sFullFileName = Mid (sString, Instr (sString, ".asp"))
iLen = Instr (sString, ".asp")-2
sFileName = Mid (sString, 1, iLen)
sExtension = Mid (sString, iLen+1, 1)
if (sExtension = "e") Then
sExtension = "f"
else
sExtension = "e"
end if
sNewFileName= sFileName & sExtension & sFullFileName
Response.Redirect sNewFileName
%>


Reply With Quote
  #5 (permalink)  
Old October 13th, 2004, 08:59 AM
Registered User
 
Join Date: Oct 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

netcrawler: how does your code work on a multi language file that has a directory structure like this:

- languages
| - en
| files
| - pt
| files
| ...

We have language files with the same constants defined and all that changes between them are the values of each constant, with it's own language specific value.

This multi-language feature, seams to be a real problem to do with ASP since dynamic includes are not possible, any help will be highly apprecitted. Thx.

Reply With Quote
  #6 (permalink)  
Old October 14th, 2004, 02:00 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

When one want to switch between different languages, where you have all content updated in different languages organised in the folder structure as mentioned in your post, you will have to just redirect to the equivalant page of the other language. That should do. But as I have read a lot on that, it is little difficult in terms of maintenance. Coding for such setup is easy, after which maintenance is a headache as one has to constantly update all versions of language contents in all such folders.

In netcrawler's suggested code, it should work this way. All the file names corresponding to English are prefixed with "e<FILENAME>.ASP". So when one request to change to that version of the page, it redirects to "e<FILENAME>.ASP"

As per my understanding, in your case, you should redirect to "en\<FILENAME.ASP" or "pt\<FILENAME.ASP". Should alter the code a bit, that was posted here.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #7 (permalink)  
Old January 13th, 2005, 12:49 PM
Authorized User
 
Join Date: Jun 2003
Location: Gent, , Belgium.
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Kabe
Default

Hi Vijay G

Is it possible to point me to some essays to read myself more about setting up a db for a multilingual website.

Cause I'm wrestling too with this for the first time, and just want to read some case studies.

My main question is what content do I put in a database and what not. There's a lot of static content which is stored in xml-files and there's other more dynamic content (menu for example) which I'll put in db.
If it's not much more effort to put all in db, why not, but what is the best way to take. For example a screen with a big table of 5 rows and 20 lines. How to store data shown onscreen in a table, with top headers and left column a number counter for each line.

You see, a lot of quetion I have, before starting up a databse design

Any suggestion, essays, documentation, ... ?

Thx a lot
Kabe
Reply With Quote
  #8 (permalink)  
Old January 18th, 2005, 12:52 AM
Friend of Wrox
 
Join Date: Dec 2004
Location: Chennai, Tamil nadu, India.
Posts: 307
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Vadivel Send a message via Yahoo to Vadivel
Default

Check out Microsoft's Web Font Wizard (popularly known as WEFT) and Bitstream.com. Almost some 4 years back I have used these tools for creating multilingual sites.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com
Reply With Quote
  #9 (permalink)  
Old September 25th, 2006, 10:43 PM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Check Out this website, it has an interesting explanation of diferent methods for multilanguage websites
http://www.indiawebdevelopers.com/te...ge_support.asp

Best Regards,
Andrea

Reply With Quote
  #10 (permalink)  
Old December 5th, 2006, 04:34 AM
Registered User
 
Join Date: Oct 2006
Location: Almora, uttaranchal, India.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi this is Rashmi working with php.Will u pls tell me how i can skip to the first page of my web-site.Actually we hev link in our home page but what i want is that if no click event is generated for the first page then autometically we will move to first page of our site after some time(ex. after 4-5 min)


Quote:
quote:Originally posted by happygv
 When one want to switch between different languages, where you have all content updated in different languages organised in the folder structure as mentioned in your post, you will have to just redirect to the equivalant page of the other language. That should do. But as I have read a lot on that, it is little difficult in terms of maintenance. Coding for such setup is easy, after which maintenance is a headache as one has to constantly update all versions of language contents in all such folders.

In netcrawler's suggested code, it should work this way. All the file names corresponding to English are prefixed with "e<FILENAME>.ASP". So when one request to change to that version of the page, it redirects to "e<FILENAME>.ASP"

As per my understanding, in your case, you should redirect to "en\<FILENAME.ASP" or "pt\<FILENAME.ASP". Should alter the code a bit, that was posted here.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi Language Database nabeelalkaff BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 December 26th, 2007 02:41 AM
Translate Web Site Language on FLY vivek_inos ASP.NET 2.0 Professional 1 May 10th, 2007 10:58 AM
Multi language scenario edgarw BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 May 7th, 2007 08:08 AM
Multi-language Lofa ASP.NET 1.0 and 1.1 Basics 2 October 25th, 2005 04:10 AM
Multi language web pages bruntcraig HTML Code Clinic 2 October 12th, 2003 05:19 PM



All times are GMT -4. The time now is 03:42 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.