function showMsg(){
var objdbConn = new ActiveXObject("ADODB.Connection");
var strdsn = "Driver={SQL Server};SERVER=;UID=;PWD=;DATABASE=";
objdbConn.Open(strdsn);
var objrs = new ActiveXObject("ADODB.Recordset");
var temp = $("#FMouldNo").val();
var temp1 = $("#FName").val();
var temp2 = $("#FMacNo").val();
if($.trim(temp1)==''&&$.trim(temp)==''&&$.trim(temp2)==''){
objrs.Open("select fitemid as 序号,FMouldNo as 模号,FName as 品名,FMeterial as 原料,FColor as 颜色,FMacNo as 机台编号,FMacSpec as 机台规格 from t_MouldStandard",objdbConn,1,3);
var trStr = '';
while (!objrs.EOF){
id = objrs.Fields("序号").Value;
trStr += '<tr>';
trStr += '<td>' + objrs.Fields("模号").Value + '</td>';
trStr += '<td>' + objrs.Fields("品名").Value + '</td>';
trStr += '<td>' + objrs.Fields("原料").Value + '</td>';
trStr += '<td>' + objrs.Fields("颜色").Value + '</td>';
trStr += '<td>' + objrs.Fields("机台编号").Value + '</td>';
trStr += '<td>' + objrs.Fields("机台规格").Value + '</td>';
trStr += '<td>' + '<input type="button" value="修改" onclick="update(id)">' + '</td>';
trStr += '</tr>';
objrs.moveNext();
}
$("#t").html(trStr);
}else if(temp!="" || temp1!="" || temp2!=""){
objrs.Open("select fitemid as 序号,FMouldNo as 模号,FName as 品名,FMeterial as 原料,FColor as 颜色,FMacNo as 机台编号,FMacSpec as 机台规格 from t_MouldStandard where FMouldNo like '%"+temp+"%' and FName like '%"+temp1+"%' and FMacNo like '%"+temp2+"%'",objdbConn,1,3);
var str = '';
while (!objrs.EOF){
id = objrs.Fields("序号").Value;
str += '<tr>';
str += '<td>' + objrs.Fields("模号").Value + '</td>';
str += '<td>' + objrs.Fields("品名").Value + '</td>';
str += '<td>' + objrs.Fields("原料").Value + '</td>';
str += '<td>' + objrs.Fields("颜色").Value + '</td>';
str += '<td>' + objrs.Fields("机台编号").Value + '</td>';
str += '<td>' + objrs.Fields("机台规格").Value + '</td>';
str += '<td>' + '<input type="button" value="修改" onclick="update(id)">' + '</td>';
alert(id);
str += '</tr>';
objrs.moveNext();
}
$("#t").html(str);
}
objrs.close();
objrs = null;
objdbConn.close();
objdbConn = null;
}
function update(id){
alert(id);
//objrs.Open();
window.open('UpdateInfo.asp');
}
uodate函数里面获取不到id,请教各位大神怎样才能把对应修改的数据id传到update里