Help!!

[Zelo]

I have database with ODBC. In mySQL i have field "rooms" with data "Flats || Houses". Is it possible to view only "Flats" in textbox1 and to view only "Houses" in textbox2 from field "rooms"? And is't possible to save data from 2 textboxes in 1 field in MySQL?

 

[boblarson]

First of all, you shouldn't be storing multiple data in the same field within the same record. You should have two fields, or two records, depending on the relationships of the data.

And, while technically it is possible to do what you are asking, it is not a simple process and it isn't anywhere near good database practice.

 

[Zelo]

I know. But it was old database with form on CMS. And there was two languages Lithuanian and English. And all data were stored in two languages in on field. I don't know why.

 

[Zelo]

i can concatenate two fields. and is very fine. for example text1||text2. it's possible to read string until this simbols and to trunc all simbols after text1?

 

[neileg]

The Instr() function will find the position of a given character. |You can use this with Left() and Right() to 'chop up' your data.