error sending email or showing messages in loop

sgis — Fri, 18 Jun 2010 14:09:56 GMT

I am trying to look through an activity grid to send email notifications to my clients. I loop through the grid and get the customer entity and use that to get a new field I added to my table called "NotificationEmail", I copy this into a local ActionResult and then generate a notification report and put the contents of NotificationEmail ActionResult into the MailTo field. The potential bugs are

1) If there is a semicolon in the email address then I get a 501 error stating that the email address is malformed and the email address it shows starts with the first semicolon in the address and goes to the character before the next semicolon or end. For example, if the email address is: site1@client1.com;manager1@site1.com;other1@site1.com, the error message would show ";other1@site1.co"

2)If I put a message box to display the NotificationEmail to me just before the SendEmail instruction, the email displays correctly, I do not get a 501 error message and the email sends just fine.

3)If I put in a message box inside the loop, the loop only executes one time. It does not reloop and the message does not display for each row in the grid.

Can anyone confirm this behavior and is there a work around. The message box preventing a loop from occuring makes development very difficult. The email address problem makes the system much less useable.

Stephen Gissendaner

Clean2Play, ll

(205) 447-7447

Min/Max and Join of Activity and Customer tables

sgis — Sun, 03 Jan 2010 20:13:12 GMT

Hello,

I am trying to create a report that shows every active customer and for each of those customers, shows the next service date and type and their last service date and type. What I want looks like:

Customer Last Service Next Service
cust123 11/23/09 interior 2/15/10 exterior

I am basing my report on the Customer table rather than the activity table so that if a customer does not have a service it shows up in the report.

I actually have two questions.

1) How do you do a join on the customer and activity tables so that I could show (and filter) all activities by each customer including showing that a customer has no activities.? I have looked in the forums and it appears that the way to do an SQL join is to use the detail report but when I create a detail report using "Activity" as the "data member"I get a report that shows all activity records repeated under each customer name. If I use Customer.Activity as the data member I get the exact same activty record one or more times under each customer. All I want is to show each customer's activities or lack of activities.

2) Can you display the info from one detail record based upon if it is the min or max of a certain field? For me, I want to show info from the record that has the Max(Activity.DueDateStart) where Activity.ActivityStatus = "Completed" within the context of each customer.

Can you help me or point me in the right direction to the documentation for the report generator. If I could just submit my own SQL statement and then write my report against the dataset my custom SQL produced would be great!

Search results by user ID 4282

error sending email or showing messages in loop

Min/Max and Join of Activity and Customer tables