DB Connectivity through API 4.x

11-08-2019 03:37 PM
New Contributor II

I'm trying to connect and display db data in a report format through a asp files as follows -

function gwicrecord1(feature) {

// Add green arrow if the percent change is positive and a red arrow for negative percent change.
return ("<table>" +
"<tr valign='top'><td style='white-space:nowrap;'>Site Name</td><td>{site_name}</td></tr>" +
"<tr><td style='white-space:nowrap;'>Site Report</td><td><a target='_newwellwin' href='http://mbmggwic.mtech.edu/sqlserver/v11/reports/SiteSummary.asp?gwicid=${gwicid}&agency=mbmg&reqby=M&'>View</a></td></tr>" +
"<tr><td style='white-space:nowrap;'>Site Type</td><td style='white-space:nowrap;'>{site_type}</td></tr>" +
"<tr><td style='white-space:nowrap;'>Location</td><td style='white-space:nowrap;'>{township} {range} {section} {qsection}</td></tr>" +
"<tr><td style='white-space:nowrap;'>Water Levels</td><td>{swl_meas} <a target='_newwellwin' href='http://mbmggwic.mtech.edu/sqlserver/v11/reports/WellHydrograph.asp?gwicid=${gwicid}&agency=mbmg&reqby=M&'>Graph</a></td></tr>" +
"<tr><td style='white-space:nowrap;'>Samples</td><td>{samples}</td></tr>" +
"<tr><td style='white-space:nowrap;'>Field Visits</td><td>{field_visits}</td></tr>" +

The WellHYdrograph.asp is displaying right. But SiteSummary.asp is not able to show the data report. Instead it is throwing the following:

Server Error

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.

Am I doing anything wrong? Please help!

0 Kudos
1 Reply
MVP Esteemed Contributor

What is an example gwicid value?

0 Kudos