gj
|
| Posted: 09/11/2002, 1:28 AM |
|
This code is in the help file of ccs.
Dim Mailer
Set Mailer = Server.CreateObject("Persits.MailSender")
Mailer.From = CCDLookUp("email", "employees", "emp_id=" &
CCToSQL(CCGetUserID,"Integer") , DBIntranetDB)
Mailer.FromName = CCDLookUp("emp_name", "employees", "emp_id=" &
CCToSQL(CCGetUserID,"Integer") , DBIntranetDB)
Mailer.AddAddress CCDLookUp("email", "employees", "emp_id=" &
CCToSQL(tasks.user_id_assign_to.Value,"Integer") , DBIntranetDB)
Mailer.Host = "mysmtphost.com"
Mailer.IsHTML = True
Mailer.Subject = "New task for you"
Mailer.Body = "A new task was assigned to you. "
Mailer.Send
set Mailer = Nothing
In this example are 3 separated queries with ccdlookup.
If you look at the perfomance this will not be a good example and i would
think that codestudio only advise people to use ccdlookup if you need one
field.
Maybe that codestudio can make a ccdlookuparray?
gr gj
|
|
|
 |
|
