|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Problems with Access 2000 - text vs values
<i><b>Originally posted by : tim (timstark01@hotmail.com)</b></i><br /><br />I'm building a multilingual web site using Access. I've made a language input table that handles the multilingual aspect. The problem is: I can see the text in the tables but it appears in values on the web.<br /><br />For example: In the multilingual table I have translations, column1 = English, column2 = French ect... I can correct the situation by doing a query for each column. The problem is I have 460 language input columns. <br /><br />Is there an easy solution for pulling the text? It looks perfect in the table, but when brought to the web it changes to values. Thanks in advance!<br /><br />Tim
|
|
#2
|
|||
|
|||
|
If you could elaborate you problem then i can through some light
|
|
#3
|
|||
|
|||
|
First, what changes from text to numbers?
Second, how can you have 460 columns in a table? Not only is the more or less normal limit around 255 but also such a table would not make sense at all. When I make such a multi-lingual application I have: LabelName (i.e. where does the translation go), Language, Description (i.e. Translation text) One may add some more columns but basically 3 is enough |
|
#4
|
|||
|
|||
|
By the way, when it comes to performance:
It is much, much faster to read 100,000 lines from a 3 column table then to read 3 lines from a 100,000 columns table :-))) |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Problems with Access 2000 - text vs values |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|