Per
|
| Posted: 08/29/2002, 12:29 PM |
|
Hi Nicole,
Thanks for your answers. Could you possibly provides these lines of code in php?
1. to include user's relevant information into mail body in addition to field value you should look up this information and concatenate it with the variable where mail message is stored. Use CCS CCDlookUP() function. E.g.:
ASP
user_name = CCDLookUp("user_name", "users_table", "user_id=" CCToSQL(form_name.user_id_field.Value, ccsInteger))
message_body = message_body & user_name
' send mail code generated by CCS goes here
...
.Subject = "Notification"
.Body = message_body
.BodyFormat = 0
...
2. you can let user enter only picture number and retrieve other field parts in the form Before Insert/Before Update events. Again I suppose that you need CCDLookUP() function to get value from another table. After that you can create full field value. E.g.:
form_name.image_field_name.Value = "images/" & lookedup_number & "_" & form_name.image_field_name.Value
|
|
|
 |
Nicole
|
| Posted: 08/30/2002, 2:01 AM |
|
Per,
here is PHP code:
1.
global $form_name;
global $DBconnection_name;
$user_name = CCDLookUp("user_name", "users_table", "user_id=" $DBconnection_name->ToSQL($form_name->user_id_field->Value, ccsInteger), $DBconnection_name);
$message_body .= $user_name;
//send mail code goes here
...
$subject = "Notification";
$message = $message_body;
...
2.
global $form_name;
$form_name->field_name->SetValue("images/". $lookedup_nunber. "_". $form_name->field_name->Value);
Also the ASP code should be:
user_name = CCDLookUp("user_name", "users_table", "user_id=" CCToSQL(form_name.user_id_field.Value, ccsInteger), DBconnection_name)
|
|
|
|
|
