Sql Scalar
This example returns the email address of a given user.
| Smartsite SXML |
Copy Code
|
|---|---|
{buffer.set(userName,Visitor1)}
{buffer.set(userMail,sql.scalar("select email from vwusers where loginname=? and not email is null",$userName,default=""))}
<a href="mailto:{buffer.get(userMail)}">{buffer.get(userName)}</a>
|
|
| Example Result |
Copy Code
|
|---|---|
<a href="mailto:noreply@smartsite.nl">Visitor1</a> |
|