How to get data from database in html page created in web dev module

General Discussion
22

Do a google search for “This site can’t be reached” you may get a lot of tips for the likely cause.

Can you also please send me a screen shot of your error with the URL visible

23

Hopefully this is what you’re looking for:
I created a webdev Python resource:
image

	ds = system.dataset.toPyDataSet(system.dataset.toDataSet(["col1","col2","col3"],[['a','b','c'],['d','e','f'],['g','h','i'] ]))
	htmlText= "<html><body>"

	if len(ds)> 0:
		htmlText+= "<table><tr>"
		# set up the table header
		for colHdr in system.dataset.getColumnHeaders(ds):
			htmlText+= "<th>%s</th>"%(colHdr)
		htmlText+= "</tr>"
		
		#parse the dataset into an html structure
		for row in ds:
			htmlText+= "<tr>"
			for col in row:
				htmlText+="<td>%s</td>"%col
			htmlText+="</tr>"
		
		
		# done with the rows
		htmlText+="</table>"
	
	htmlText+="</body></html>"	
	return {'html': htmlText}

accessing the url: http://localhost:8088/system/webdev/projname/webdev_resource_name

results in a webpage:
image