jarv
04-29-2008, 06:55 PM
Item cannot be found in the collection corresponding to the requested name or ordinal.
/arcangels/rightframe.asp, line 60
Code for Line 60:
set rs = objconn.execute("SELECT * FROM Settings")
<%= rs("SideBarText")%>
I did a response.write and the SideBarText is being passed through from the form in the previous page!
it is also being updated:
SideBarText = Request.Form("SideBarText")
SQL1="UPDATE Settings SET TitleColor = '" & TitleColor & "', BackColor = '" & BackColor & "', LinkColor = '" & LinkColor & "', SideBarColor = '" & SideBarColor & "', SideBarTextColor = '" & SideBarTextColor & "', SideBarText = '" & SideBarText & "', WebsiteName = '" & WebsiteName & "', WebsiteSlogan = '" & WebsiteSlogan & "', TopHeader = '" & TopHeader & "', FootBG = '" & FootBG & "' WHERE settingsID ="& 1
the only problem is is that it is not showing in my page?!
/arcangels/rightframe.asp, line 60
Code for Line 60:
set rs = objconn.execute("SELECT * FROM Settings")
<%= rs("SideBarText")%>
I did a response.write and the SideBarText is being passed through from the form in the previous page!
it is also being updated:
SideBarText = Request.Form("SideBarText")
SQL1="UPDATE Settings SET TitleColor = '" & TitleColor & "', BackColor = '" & BackColor & "', LinkColor = '" & LinkColor & "', SideBarColor = '" & SideBarColor & "', SideBarTextColor = '" & SideBarTextColor & "', SideBarText = '" & SideBarText & "', WebsiteName = '" & WebsiteName & "', WebsiteSlogan = '" & WebsiteSlogan & "', TopHeader = '" & TopHeader & "', FootBG = '" & FootBG & "' WHERE settingsID ="& 1
the only problem is is that it is not showing in my page?!