(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Ampersand in lookup
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Ampersand in lookup (Read 506 times)
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
Ampersand in lookup
Mar 2nd, 2012 at 12:39am
Print Post Print Post  
Interesting little glitch.....

I have a lookup field that returns the name of my customer, etc. from a drop down list into another field.  If the customer info has a "&" in their name, it wont' return the value!
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Ampersand in lookup
Reply #1 - Mar 2nd, 2012 at 1:15am
Print Post Print Post  
PYou need to use a backslash in front of the ampersand.

Examples: Smith \& Wesson; macaroni \& cheese; Q\&A

See Inside Sesame, June 2005, page 6 for article on how to deal with & in drop down lists.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Ampersand in lookup
Reply #2 - Mar 2nd, 2012 at 2:59pm
Print Post Print Post  
It's not a glitch at all. The Ampersand is used in Search syntax as the 'and' operator and an XLookup is a search operation. As Bob stated you will need to escape it by using a backslash to search for a literal ampersand.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Rick_R
Full Member
***
Offline



Posts: 243
Joined: Jan 29th, 2010
Re: Ampersand in lookup
Reply #3 - Mar 2nd, 2012 at 8:17pm
Print Post Print Post  
Bob_Hansen wrote on Mar 2nd, 2012 at 1:15am:
Examples: Smith \& Wesson;


Brings to mind and interesting comment I heard recently:

The original "point-and-click" interface ... was a Smith & Wesson!  Grin
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge