 |
|
select *
from df_webform, df_webformoption, df_webformfield, df_webformsiteinfo
where df_webform.navimage='#navimage#' AND
df_webformoption.siteref='#siteref#' AND
df_webform.ref=df_webformoption.formref AND
df_webformoption.fieldref=df_webformfield.ref AND
df_webformoption.siteref=df_webformsiteinfo.siteref AND
df_webformoption.formref=df_webformsiteinfo.formref
order by seq
#fieldname#: #Evaluate("FORM.#fieldname#")#
select *
from df_webform, df_webformcontent
where df_webform.navimage='#navimage#' AND
df_webform.ref=df_webformcontent.formref
select email
from customer, site
where site.ref='#siteref#' AND customer.ref=site.customerref
insert into df_webformsiteinfo (ref, siteref, formref, recipient, intro, responsemessage, subject)
values ('#createUUID()#', '#siteref#', '#getinfo.formref[1]#', '#email#', '#getinfo.intro[1]#', '#getinfo.responsemessage[1]#', '#getinfo.subject[1]#')
insert into df_webformoption (ref, siteref, formref, fieldref, mandatory, seq)
values ('#createUUID()#', '#siteref#', '#formref#', '#fieldref#', '#required#', #seq#)
select *
from df_webform, df_webformoption, df_webformfield, df_webformsiteinfo
where df_webform.navimage='#navimage#' AND
df_webformoption.siteref='#siteref#' AND
df_webform.ref=df_webformoption.formref AND
df_webformoption.fieldref=df_webformfield.ref AND
df_webformoption.siteref=df_webformsiteinfo.siteref AND
df_webformoption.formref=df_webformsiteinfo.formref
order by seq
#getforminfo.responsemessage[1]#
Sorry! We are unable to process your submission due to the following reason(s).
Please make the neccessary changes by clicking here.
*#arrayMessages[idx]#
#getforminfo.intro[1]#
All bold items are required before you can submit the form.
You must enter a valid email address or this message will not be sent.
|
|
|
