WebSite X5Help Center

 
Sinisa B.
Sinisa B.
User

Database viewer - column names (labels)  en

Autor: Sinisa B.
Visitado 59, Followers 0, Compartido 0  

Hi All,

I am filling the database via a form (OPTION: send to database).
I am using the DATABASE VIEWER object to show the collected data.

Due to the FORM field rules, the database field name cannot contain SPACE (cannot use two or more words as a field name). Thus in the table view of the DATABASE VIEWER, the column name (aka column label) is shown as SINGLE WORD without spaces between words (see below).


I know that in PHPMyAdmin I can change the names of the columns of the database table and thus have two or more words in a column, but then I cannot fill in the data via the form because it will add columns of different names (no space names).

I also know that I can directly enter data using the DATABASE VIEWER and that the above (form) problem could be avoided, but I have to enter data via the form for legal reasons!

So, my question is:
Is there a way to use FORM (send to database option) to fill the database so that in the Database Viewer column names (column labels) could have two or more words separated by a space?
I would like to avoid the underscore "_" charater as a separator...

Thank you in advance for your help!

Publicado en
3 RESPUESTAS
 ‪ KolAsim ‪ ‪
 ‪ KolAsim ‪ ‪
Moderator

(It > En)  ...if you can't find any other solutions, and just to improve the visual appearance on the monitor, if you post the link to the page in question, some of my dynamic JavaScript code could be considered; otherwise, ignore my post, as if I hadn't said anything...

.

ciao

.

Leer más
Publicado en de  ‪ KolAsim ‪ ‪
Daniel W.
Daniel W.
User
Usuario del mes DE

The words could be visually separated by the character _

Serijki_Broj_Racunala

Windows_Lozinka

Windows_Pin

Leer más
Publicado en de Daniel W.
 ‪ KolAsim ‪ ‪
 ‪ KolAsim ‪ ‪
Moderator

... he wanted to avoid it because it was unsightly, ... but it is possible to use the underscore "_" to separate words, and then with my EXTRA(!) code show the normal words, without the hyphen...

.

ciao

.

Leer más
Publicado en de  ‪ KolAsim ‪ ‪