Alpha Documentation



Example 1 - simple


Example 2 - evaluate_string example


dim vcountry as c                = e.datasubmitted.country

dim vfax as c                        = e.datasubmitted.fax

dim vcomment as c                 = e.datasubmitted.comment

dim msg as c

msg = <<%txt%


Contact_from...: {vapp_name}

Contact_origin.: {vapp_url}

Sent_at .......: {now()}

Contact_ID.....: {alltrim(str(vcontactid))}

---------------------------------------------

Company........: {vcompany}

Email..........: {vemailaddress}

Firstname......: {vfname}

Lastname.......: {vlname}

Telephone......: {vtelephone}

Timestamp......: {now() + crlf(2)}

Message........: {vcomment}

{crlf(2)}

%txt%


email_smtp_open(ps,smtp_server,smtp_port,smtp_uname,smtp_pwd)


msg = evaluate_string(msg)

'msg now contains the text with all variables resolved


Example 3 - SQL Query


vsql = <<%txt%

select month(date_created) as mo,year(date_created) as yr, count(*) as cnt

from blog

WHERE date_created <> ""

GROUP BY month(date_created),year(date_created)

ORDER BY date_created desc

%txt%