[ic] Lookup_query for E-mail addresses
bill at bottlenose-wine.com
Thu Jun 28 14:53:50 EDT 2007
I'm using the table_editor and one of my widgets allows the user to
select an e-mail address like using the following format:
Bill Carr <bill at bottlenose-wine.com>
I'm using the select widget.
My lookup_query is like this:
SELECT CONCAT(CONCAT_WS(' ',fname,lname),'
<',user,'@',domain,'>') FROM users u WHERE domain='__STOREID__'
Problem is lookup_query does not like the ';'. It thinks I'm sending
more then one lookup query. If I replace '<' with '<' I can't see
the e-mail address in the select widget. I only see the name. If use
'<' the widget looks good but '<' is what is stored in my DB
and the current choice is not selected for existing values.
Any ideas of how I can use lookup_query for building a select widget
for e-mail addresses of the form "Bill Carr <bill at bottlenose-wine.com>"?
Bottlenose - Wine & Spirits eBusiness Specialists
More information about the interchange-users