Member Avatar for ArtistScope

"Name redefined" means that it has been dimmed more than once.

There is simpler coding than Dreamweaver methods for accessing database records:

SQL = "SELECT * FROM Products Where Products.ID = " & strProductID & " Order by Products.ID"
	Set rsSet = dbConnection.Execute(SQL)	
	if NOT rsSet.EOF then
		strTitle = rsSet("SiteName").value
		strCompany = rsSet("Company").value
		strAddress = rsSet("Address").value
		strContact = rsSet("Contact").value
		strPhone = rsSet("Phone").value
	end if
	rsSet.Close
	Set rsSet = Nothing
Edited by Ezzaral because: Added code tags. Please use them to format all code that you post.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.