前面的两个  conn.Execute  都能成功执行，  但是 最后一个  conn.Execute  始终无法插入记录，浏览器显示空白，有哪些可能呢？这个跟表列的“类型” 有关吗？ 这里面包括 “money"  "datetime"

代码如下：



  '第一个  conn.Execute
  conn.Execute("Update Member_User Set Money_Number=Money_Number-"&AllMonery&",Money_Consumption=Money_Consumption+"&AllMonery&" where user_name='"&trim(request.form("member_user"))&"'") '从会员账号扣款

  '第二个   conn.Execute
  shijian=now()
  dingdan=year(shijian)&month(shijian)&day(shijian)&hour(shijian)&minute(shijian)&second(shijian)
  MemberInfo_B=conn.execute("select ID,User_Name,Money_Number from Member_User where user_name='"&trim(request.form("member_user"))&"'") '获取会员信息
  conn.Execute("insert into Order_Record(Member_ID,Member_User,Order_no,Order_Action,Order_Note,Order_Money,A_Money_Number,Order_Time,State_num) values("&MemberInfo_B(0)&",'"&MemberInfo_B(1)&"','"&dingdan&"','- 扣款[消费]','主机名:"&request.Form("srv_name")&" 开通:1个月',"&AllMonery&","&MemberInfo_B(2)&",'"&shijian&"',1)") '存入财务记录


  '第三个  conn.Execute

  conn.Execute("insert into user_server(member_user,server_Name,server_price,srv_name,server_ip,server_room,server_cpu,server_memory,server_disk,server_bandwidth,user_beizhu,adm_beizhu,start_date,end_date) values('"&trim(request.form("member_user"))&"','"&trim(request.form("server_name"))&"',"&trim(request.form("server_price"))&",'"&trim(request.form("srv_name"))&"','"&trim(request.form("server_ip"))&"','"&trim(request.form("server_room"))&"','"&trim(request.Form("server_cpu"))&"','"&trim(request.form("server_memory"))&"','"&trim(request.form("server_disk"))&"','"&trim(request.form("server_bandwidth"))&"','"&trim(request.form("user_beizhu"))&"','"&trim(request.form("adm_beizhu"))&"','"&Sdate&"','"&edate&"')")
  Call Infobox("操作成功","user_server.asp")