I *am* disturbed with CF because this new attribute validation is *breaking* code that worked before in 4.5. This validation is unnecessary and is better to be left for the mail server to handle. It is especially a hassle when you are passing the query parameter to the CFMAIL tag the query contains 6000 records! Now I have to make sure it has no invalid email addresses - it's enough to make you pull your hair out.
-Dustin ----- Original Message ----- From: "Dave Carabetta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 10:50 AM Subject: Re: CFMAIL TO param problems with large queries > >Oddly it seems that I am getting all the records but at the end there is > >what seems to be a blank email address. When I cfoutput the results it > >outputs the text [empty string] at the end. Seems that should be impossible > >with the LIKE email ='[EMAIL PROTECTED]' in the query . The query is ordered by > >email > >so > >I see this entry at the very end. I am disturbed that a blank email is > >being > >included in the query, but also disturbed that CF seems to be outputting > >the > >text [empty string] when it should just be blank! > > > > Don't be disturbed with CF, bet disturbed with the query. ;) > > You're AND-ing your NULL/blank string checks together instead of OR-ing > them. Try switching and see what happens with your query results. > > Also, you should just be able to do: > > SELECT emailaddress > FROM myTable > WHERE emailaddress IS NOT NULL > OR TRIM(emailaddress) != '' > > That should cover all instances of blank or NULL e-mail fields. I don't know > if there's a TRIM() function in SQL Server, so you may have to do > LTRIM(RTRIM(emailaddress)) to get the same effect (I'm on Oracle, so I just > don't know that answer). > > Regards, > Dave. > > _________________________________________________________________ > Add MSN 8 Internet Software to your existing Internet access and enjoy > patented spam protection and more. Sign up now! > http://join.msn.com/?page=dept/byoa > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138299 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm