Click to See Complete Forum and Search --> : ASP!!! Help me please!!!
6259420
12-19-2002, 08:03 PM
Hello... I own a business with many workers and they have webpages of their own assigned to them that display updates. Certain parts of them I would like to change daily, but there are so many workers, it almost takes that whole day to do it! Is there an any quicker way using ASP??? Please reply ASAP!!!
Thanks a lot...
You could make a Content Management system. Just make some tables in a (simple) Access database. Put some collums in the table:
'iD' 'Date' 'text' 'make_by' etc......
Create an Admin page, where some users can access and edit the database tables. On every page where you want the quick input, make just 1 make-up and just put in some tags like:
<%
Connection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\root\database\content_management.mdb;" & _
"User Id=;" & _
"Password="
Set database1 = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT TOP 1 tblFront.*,tblAlert.* From tbl_First_page Order by tbl_First_page.ID DESC;"
database1.CursorType = 2
database1.LockType = 3
database1.Open SQL, Connection
%>
Some HTML text followd by the text in requesting from your database...: <%=database1("text")%>