April 11, 2002 at 9:48 am
I have been asked to look into converting our company website content into various different languages.
I understand I can create the web content in the different languages using SQL and call them up using ASP.
When experimenting with this I can get it to work fine except for losing the formating of the text i.e. paragraphs, indents etc.
I am currently using Varchar & have tried Txt fields without any success.
Can anybody offer any suggestions....
April 15, 2002 at 2:40 am
Could you explain a little more of what you're trying to do.
Returning data to an ASP client offer many oppurtunities for formatting and eye-candy. You will almost certainly have to embed some HTML into your data as it goes to the page. Or you might want to return your data usiong XML and have XSL format it for you on the page.
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
April 15, 2002 at 5:51 am
I agree that embedding formatting in the data is a bad idea, just hard to avoid it sometimes. A lot of standard formatting gets thrown away by the browser, you may need to replace carriage return/line feed pairs with a <P> tag, etc. XML/XSL is definitely the way to go if you can manage it, seems like XSL has a fairly steep learning curve.
Andy
April 15, 2002 at 7:46 am
Ah yes XSL can be a steep hill to climb, but then the view from the top is well worth the effort. In any case you may not have to 'climb every mountain'. There are some excellent Tomes (books) on XML and SQL Server interaction including Ken Henderson's Guru's Guide and you may well find the clues you need in one or other of these
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply