[ic] divided 'option selects' when using combo select with databaselookup

[Elmar Meusel <elmar@schaf.de>]

Hi,

sorry for reposting my problem. After the first time Mike asked for more 
details,
which a gave him in a "personal answer" in this mailing list. He didn't 
answer yet,
maybe he's is to busy (what I could understand :-)) and that'd be okay. 
Anyway...
maybe there is someone else who could help me... I've searched the archives 
once more,
but did not found a solution. I added some config facts, maybe it's easier 
now to comprehend.

I have a products table with a column named "composers". The entries in 
this column
are often comma-seperated names like "Mozart, W.A." or "Bach, J.S." 
(without the quotes).
The products data are working fine within the shop, but while using the 
item edit page
of the Admin-area (where I am using  a combo select with a lookup on this 
column
"composers"), all presented entries of the "option selects" are divided 
after the comma
(value and display) in to pieces (two seperate selcects), so you can only 
select
"Mozart" or "W.A." or "Bach"...

In this page for entering a new or editing an existing item (Items -> 
create new item),
I have created an entry field for the composer with the following meta 
settings:

Table::Column      products::composer
Widget type        Combo Select
Width              30
Height             1
Label              Composer
Lookup Table       products
Lookup select      composer
Filter(s)          nullselect
pre_filter         nullselect

The data in the correlating db-field 'composer' look like

Bach, C.Ph.E.
Cadet, Chédeville
Charlwood, David
Ehlen, Margit

(Each line represents another record.)

The names are displayed correctly (Name,Surname) in every result.html or 
flypage.html
within the shop, but not in the admin-area. When the form for a new item is 
created
(based on the meta-data above), a database-lookup is made which presents 
the existing
composers as a "option select" list, but every combination of name and 
surname is
divided into seperate options like this

<OPTION VALUE="Bach">Bach
<OPTION VALUE="C.Ph.E.">C.Ph.E.
<OPTION VALUE="Cadet">Cadet
<OPTION VALUE="Chédeville">Chédeville
<OPTION VALUE="Charlwood">Charlwood
<OPTION VALUE="David">David
<OPTION VALUE="Ehlen">Ehlen
<OPTION VALUE="Margit">Margit

instead of

<OPTION VALUE="Bach, C.Ph.E.">Bach, C.Ph.E.
<OPTION VALUE="Cadet, Chédeville">Cadet, Chédeville
<OPTION VALUE="Charlwood, David">Charlwood, David
<OPTION VALUE="Ehlen, Margit">Ehlen, Margit

I've tried the 2nd version (like '<OPTION VALUE="Ehlen, Margit">Ehlen, 
Margit')
in pure HTML and it worked fine, so it should in interchange. I've also 
tried to
set the Database entries in quotes ("Charlwood, David"), but that didn't help.

I'm using Interchange 4.8.3 with MySQL 3.22.32 on Linux 2.2.14.

Thanks in advance for your help. BTW, Interchange is a real amazing product 
and
much better than what we had before (vshop). :-)

Regards
Elmar

_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users