0

UCCASS

UCCASS, yes my job still uses it and yes it is very active. Since I lost my previous entries and really do not want to recreate the query, I will paste it here for future reference:

Get users’ email addy for those who completed the survey:

select users.sid,users.email from completed_surveys
LEFT JOIN users on users.uid = completed_surveys.uid and users.sid = completed_surveys.sid
where completed_surveys.sid = (survey ID)

Get users’ email addy for those who did not complete for massive email bombardment:

select users.sid,users.email,
concat(concat(concat(“http://(your app web)/survey/survey.php?sid=
“,users.sid),”&invite_code=”),users.invite_code)
from users
LEFT JOIN completed_surveys on users.uid = completed_surveys.uid and
users.sid = completed_surveys.sid
where users.sid = (survey ID) and completed_surveys.uid is null

We will see if we will keep using the system but so far it has been a champ.

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *