Hi, Has anyone used the HitList element to connect to a database and query two tables? Do you need a HitList element for both tables. The following sql statement tests successful in Edit Database Query, but when I attempt to preview the page, a PrepareTemplateVariantElement Error#0 is returned (works when querying one table): SELECT vwDemographic.DemographicID, vwDemographic.ResultSubmissionID, vwDemographic.MunicipalityValue, vwDemographic.LocationAddress, vwDemographic.SectionNo, vwDemographic.BlockNo, vwDemographic.LotNo, vwDemographic.Latitude, vwDemographic.Longitude, vwDemographic.SamplingPoint, vwDemographic.WellPermitNo, vwDemographic.IsTreatedSampleString, vwTestResult. DemographicID, vwTestResult.AnalyteName, vwTestResult.MethodCode from vwDemographic, vwTestResult WHERE vwDemographic.MunicipalityValue = '135689' AND vwDemographic.ProjectValue = 'Town' ORDER BY vwDemographic.MunicipalityValue, vwDemographic.SectionNo, vwDemographic.BlockNo, vwDemographic.LotNo
-- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/reddot-cms-users. For more options, visit https://groups.google.com/groups/opt_out.
