DB Connectivity through API 4.x

BulbulMajumder — Fri, 08 Nov 2019 23:37:22 GMT

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>" +
"</table>");
}

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!

Re: DB Connectivity through API 4.x

RobertScheitlin__GISP — Mon, 25 Nov 2019 14:19:01 GMT

What is an example gwicid value?

topic DB Connectivity through API 4.x in ArcGIS JavaScript Maps SDK Questions

DB Connectivity through API 4.x

Server Error

500 - Internal server error.

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

Re: DB Connectivity through API 4.x