Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers

Webmaster Forum / ColdFusion / Getting Started / September 2005



Tip: Looking for answers? Try searching our database.

mid function

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
newcf - 29 Sep 2005 19:40 GMT
The email address is not alway in order.  Users are not alway have all three
emails address, some time one, or two.  It dosen't matter howmay  email address
they have, all I need is just find the email which contains domain @os.com.  
Here is the example data I have and here are my two questions:

1) How would I output only the email have domain @os.com
2) If #1 is impossible to do it, then would I output all three emails and
sperate them by common (,) I tried the code below but I can't make it work.  
Please help -thanks
******************************************************

<cfset email ="als@es.com: la.l.smi@escom: aa.l.smith@os.com added to E-mail
(subjectAltName) for.......>
<cfset fieldValue2 = mid(find('added','email',2),1,1)>
<cfoutput>#fieldValue2#</cfoutput>
Dan Bracuk - 29 Sep 2005 20:37 GMT
If in a query

where email like '%@os.com'

If in cold fusion
if(right(email, 7) is "@os.com")
do something
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.