I'd give ya 2 suggestions. 1) trim your form fields or 2) make the title field a menu with Ms. Mrs., Mr. as the choices then you won't have the problem to begin with
:) dave ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, June 15, 2003 3:54 AM Subject: Re[3]: how to ask for the correct title in cfif ? > Maybe, I just wrongly translated > it for understanding-reasons from the german word: anrede > which is not reserved :-) > It should be adresses I guess. > Uwe > > > > DL> isn't "title" a reserved word? > > DL>> ----- Original Message ----- > DL>> From: <[EMAIL PROTECTED]> > DL>> To: "CF-Talk" <[EMAIL PROTECTED]> > DL>> Sent: Saturday, June 14, 2003 3:10 PM > DL>> Subject: how to ask for the correct title in cfif ? > > > >>> Hi list, I am using the following > >>> term to start an eMailing > >>> to customers. > >>> > >>> Dear <cfif title EQ "Mrs">Mrs. <cfif degree NEQ "">#degree#</cfif></cfif> > >>> <cfif title EQ "Mr">Mr. <cfif degree NEQ > "">>>#degree#</cfif></cfif>#last_name#, > >>> > >>> >From time to time I see, that the field title > >>> isn't filled correct. Instead of "Mrs" there is "Mrss" > >>> or "Mrs " with a blank at the end. > >>> The cfif-statement doesn't work in this case. > >>> Is there an option to use a wild-card like: > >>> "Mrs*" or "Mr*" in the cfif statement ? > >>> > >>> Uwe > >>> > >>> > DL>> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
