[ic] truncated (divided) 'option selects' when using combo select with database lookup

[Elmar Meusel]

Hi Mike,

Thanks a lot for your answer.

Unfortunately my problem does not occur while using the products data 
within the shop (that works fine), but while using the item edit page of 
the Admin-area. 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.

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

Regards
Elmar


>Quoting Elmar Meusel (elmar@schaf.de):
> >
> > Hello,
> >
> > here's my problem: 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). In the
> > new-item form I want to use a combo select with a lookup on this
> > column, but all presented entries of the "option selects" are
> > truncated after the comma (value and display), so you can only select
> > "Mozart" or "Bach".
> >
> > Is it possible to display the whole names including the commas within
> > the option selcects? I've tried to set the database entries in quotes,
> > but that didn't help. I looked in the mailling lists and the docs, but
> > did not found any help... (maybe I'm too blind... :-))
> >
> > I'm using Interchange 4.8.3 with MySQL 3.22.32 on Linux 2.2.14.
> >
>
>You would have to give an example of your option selects. If you are
>doing something like:
>
>[accessories type=select passed="[item-data products composers]"]
>
>then you are going to have a problem with something like
>
>         Mozart, W.A., Bach, J.S.
>
>for there is nothing to differentiate things. But if you do:
>
>         Mozart, W.A.;Bach, J.S.
>
>and
>
>[accessories
>         type=select
>         passed="[item-data products composers]"
>         delimiter=";"
>         ]
>
>that should work.
>
>Alternatively, but not as elegantly in my opinion, you could use the current
>setup and change the data to:
>
>     Mozart&#44 W.A., Bach&#44 J.S.