#12002/10/16 10:55:26
我用UD编的一个程序,通过提取表ORDERS里的DJBH来更新Session("OrderID"),以下是源代码,那个位高手帮我看看啊!
<%
var UC_OrderIdSessionVar = "OrderID";
if (Session(UC_OrderIdSessionVar)==null) {
// Get a unique OrderID number and save to session.
var UC_tableName = "ORDERS";
var UC_fieldName = "DJBH";
var tmp = "ADODB.Recordset";
UC_rsId = Server.CreateObject(tmp);
UC_rsId.ActiveConnection = "dsn=USERS;";
UC_rsId.Source = "select " + UC_fieldName + " from " + UC_tableName;
UC_rsId.CursorType = ; // adOpenForwardOnly
UC_rsId.CursorLocation = 2; // adUseServer
UC_rsId.LockType = 2; // adLockPessimistic
UC_rsId.Open();
Session(UC_OrderIdSessionVar) = parseInt(UC_rsId.Fields(UC_fieldName).value);
UC_rsId.Fields(UC_fieldName).value = Session(UC_OrderIdSessionVar) + 1;
UC_rsId.Update();
UC_rsId.Close();
UC_rsId = null;
}
%>