[ic] Lookup_query for E-mail addresses

Bill Carr 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),'  
&lt;',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 '&lt;' with '<' I can't see  
the e-mail address in the select widget. I only see the name. If  use  
'&#60' the widget looks good but '&lt;' 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>"?

Bill Carr
Bottlenose - Wine & Spirits eBusiness Specialists

More information about the interchange-users mailing list