---> select submissionId, formId from tbl_wrk_formSubmissions with (nolock) where ownerid = and ownertype = and linkid = and linktype = 'ISD' fieldAttributes = StructNew(); fieldAttributes.domainName = qmd_form.fieldDomain; fieldAttributes.partnerId = qryLinkedFormSubmission.submissionId; fieldAttributes.partnerType = "WFS"; fieldAttributes.category = qmd_form.fieldCategory; select data from qmd_fieldValues where type = 'FILE' select contentPath from qryContentFullPathLookup where ContentID in () select mainImageUrl, thumbImageUrl, docTitle from qryPhotoCollection where upper(mainIMageUrl) like '%.JPG' or upper(mainIMageUrl) like '%.GIF' union select mainImageUrl, thumbImageUrl, docTitle from qryPhotoCollectionForms where upper(mainIMageUrl) like '%.JPG' or upper(mainIMageUrl) like '%.GIF'
Close
  • #DocTitle#
    •