girish_327
Posts: 108
|
| Posted: 06/25/2011, 10:20 PM |
|
Hello All,
I have editable grid for members database.
Administrator Accept the Membership through check box.
When I select multiple Members Active Check box and Update I would like to send Email to individual members. Please help me how do I get each members ID and send them email
THANKS IN ADVANCE
Girish 
_________________
Girish Baraskar
Web Designer/Developer
http://www.agnisdesigners.com
http://www.eindianpaintings.com
http://www.realestatekolhapur.com |
 |
 |
jjrjr2
Posts: 131
|
| Posted: 06/25/2011, 11:40 PM |
|
Hi
Try adding a hidden field to your editable grid that has the e-mail address of the member.
Then in either the on validate or after update event check the value of the checkbox and if selected send an e-mail to the e-mail address in the hidden field.
Does that make sense???
John
Oh BTW if that checkbox value is saved in your database.. U might have to do some code so e-mails are not re-sent to already accepted members...
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
Real Web Development At: http://RealWebDevelopment.us |
|
|
|
girish_327
Posts: 108
|
| Posted: 06/25/2011, 11:53 PM |
|
As per your instruction I did the same thing but it sends only one email but actually I checked couple of items.
_________________
Girish Baraskar
Web Designer/Developer
http://www.agnisdesigners.com
http://www.eindianpaintings.com
http://www.realestatekolhapur.com |
|
|
|
jjrjr2
Posts: 131
|
| Posted: 06/27/2011, 3:11 AM |
|
What event did U place your code in???
Editable grids are strange in some respects.
U just gotta use an event where every record is processed.
Also U gotta be sure your checked component is available as well.
Try a little debugging code to find the right spot to put your email code.
John
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
Real Web Development At: http://RealWebDevelopment.us |
|
|
|
girish_327
Posts: 108
|
| Posted: 06/27/2011, 3:17 AM |
|
I have placed in after update Event.
if($profile->active->GetValue()==1)
{
$mobile = CCDLookup("mobile","member", "member_id=".$profile->member_id->GetValue(),$DBxxxx);
/*//////////////// SMS START ///////////////////*/
/*//////////////// SMS END ///////////////////*/
}
_________________
Girish Baraskar
Web Designer/Developer
http://www.agnisdesigners.com
http://www.eindianpaintings.com
http://www.realestatekolhapur.com |
|
|
|
jjrjr2
Posts: 131
|
| Posted: 06/27/2011, 12:18 PM |
|
Again, as I suggested....
Find an event that is being fired for each row being updated.
Put some debug code into a different event.. IE: validate row. update row. before update.... till you find an event that fires for each row. (You can always look at the main script code to find one as well.)
I rarely use editable grids but I do remember that not all events fire for each row.
BTW be sure you do not inappropriately send emails if U use events like on validate. etc...
Have fun...
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
Real Web Development At: http://RealWebDevelopment.us |
|
|
|
girish_327
Posts: 108
|
| Posted: 06/27/2011, 11:23 PM |
|
Hello John,
Thanks for your help. I used AfterExecuteUpdate Event to send email / SMS to my Activatated Users.
AfterExecuteUpdate
_________________
Girish Baraskar
Web Designer/Developer
http://www.agnisdesigners.com
http://www.eindianpaintings.com
http://www.realestatekolhapur.com |
|
|
|
