how do we trace who update the values?

[samkry]

Hi..
my DW pages require user to logon with login user server behaviors, and every
table has coulmn called updatedby..
so if user updating the values in dreamweaver page I able to trace them thru a
updated by clolumn,
so how do I do that.. to trace who's user manipulating data in my db??

[CarlGrint]

When you use the Dreamweaver login behaviour it creates a Session called
MM_Username, which you can use in a Hidden field to insert into your record
along with the other details.
If you would like to use the User's ID, then you can either create an
Additional Session to pass the UserID or place a recordset on each page,
filtered by Session MM_Username and then grab the UserID from the recordset.

I have a tutorial on creating additional sessions =
[url]http://www.cgw3.co.uk/tutorials/tutorial.asp?TutorialID=37&CategoryID=3[/url]

Also I wrote a tutorial on dmxzone
[url]http://www.dmxzone.com/showDetail.asp?TypeId=28&NewsId=7645[/url] which contains so
help in this area.



Originally posted by: samkry
Hi..
my DW pages require user to logon with login user server behaviors, and every
table has coulmn called updatedby..
so if user updating the values in dreamweaver page I able to trace them thru a
updated by clolumn,
so how do I do that.. to trace who's user manipulating data in my db??

[samkry]

Ok.
When user success to log on it will direct to the main page, so in my main
page there is a link to insert pages
so how do I insert the values together with username who logon to the pages...
my insert page will have textfield and so far have no problem to inserting the
values but I still cannot insert username in...
I use hidden field and it so far I only now how to put the defualt values not
dynamic values which is username

sorry can't open the page since it was block by our proxy server

[CarlGrint]

Couple of ways, if you simply want to use the Session, enter
<%=Session("MM_Username")%> in the Value field, or if you have a recordset,
select the lightning symbol in the HIdden field properities and select the
column field you want to enter as the value.

Originally posted by: samkry
Ok.
When user success to log on it will direct to the main page, so in my main
page there is a link to insert pages
so how do I insert the values together with username who logon to the pages...
my insert page will have textfield and so far have no problem to inserting the
values but I still cannot insert username in...
I use hidden field and it so far I only now how to put the defualt values not
dynamic values which is username

sorry can't open the page since it was block by our proxy server

[samkry]

Hi..
I'm using the recordset and put the values in hidden field column but when I
preview the page it giving me an ie error..

below is the page

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/FTI.asp" -->
<%
var Recordset1__MMColParam = "1";
if (String(Request.QueryString("mm_username")) != "undefined" &&
String(Request.QueryString("mm_username")) != "") {
Recordset1__MMColParam = String(Request.QueryString("mm_username"));
}
%>


still blur and sorry for the dumbness

[CarlGrint]

Its not a URL variable its a Session, called MM_Username, thus your recordset
will fail.

Change the filter type to Session, and it should work ok, always a good idea
to place a Show IF around the value anyway, so the errors do not occur.


Originally posted by: samkry
Hi..
I'm using the recordset and put the values in hidden field column but when I
preview the page it giving me an ie error..

below is the page

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/FTI.asp" -->
<%
var Recordset1__MMColParam = "1";
if (String(Request.QueryString("mm_username")) != "undefined" &&
String(Request.QueryString("mm_username")) != "") {
Recordset1__MMColParam = String(Request.QueryString("mm_username"));
}
%>


still blur and sorry for the dumbness

[samkry]

Yep,
it's ok now.. but when I submitted the insert form it's only inserted the
values for the values fill in the textfield and not for values in hidden field
again is my DW scripts

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/FTI.asp" -->
<%
// *** Edit Operations: declare variables

// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
MM_editAction += "?" + Request.QueryString;
}

// boolean to abort record edit
var MM_abortEdit = false;

// query string to execute
var MM_editQuery = "";
%>
<%
// *** Insert Record: set variables

if (String(Request("MM_insert")) == "form1") {

var MM_editConnection = MM_FTI_STRING;
var MM_editTable = "dbo.logesn";
var MM_editRedirectUrl = "";
var MM_fieldsStr = "textfield|value|hiddenField|value";
var MM_columnsStr = "hexesn|',none,''|updatedby|',none,''";

// create the MM_fields and MM_columns arrays
var MM_fields = MM_fieldsStr.split("|");
var MM_columns = MM_columnsStr.split("|");

// set the form values
for (var i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = String(Request.Form(MM_fields));
}

// append the query string to the redirect URL
if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count >
0) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") +
Request.QueryString;
}
}
%>
<%
// *** Insert Record: construct a sql insert statement and execute it

if (String(Request("MM_insert")) != "undefined") {

// create the sql insert statement
var MM_tableValues = "", MM_dbValues = "";
for (var i=0; i+1 < MM_fields.length; i+=2) {
var formVal = MM_fields[i+1];
var MM_typesArray = MM_columns[i+1].split(",");
var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
if (formVal == "" || formVal == "undefined") {
formVal = emptyVal;
} else {
if (altVal != "") {
formVal = altVal;
} else if (delim == "'") { // escape quotes
formVal = "'" + formVal.replace(/'/g,"''") + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_tableValues += ((i != 0) ? "," : "") + MM_columns;
MM_dbValues += ((i != 0) ? "," : "") + formVal;
}
MM_editQuery = "insert into " + MM_editTable + " (" + MM_tableValues + ")
values (" + MM_dbValues + ")";

if (!MM_abortEdit) {
// execute the insert
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();

if (MM_editRedirectUrl) {
Response.Redirect(MM_editRedirectUrl);
}
}

}
%>
<%
var Recordset1__MMColParam = "1";
if (String(Session("mm_username")) != "undefined" &&
String(Session("mm_username")) != "") {
Recordset1__MMColParam = String(Session("mm_username"));
}
%>

<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_FTI_STRING;
Recordset1.Source = "SELECT * FROM dbo.Employee WHERE Firstname = '"+
Recordset1__MMColParam.replace(/'/g, "''") + "'";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>

[samkry]

Yes..
The page now successfull inserted and the values for updated by columns also inserted

thanks..