"insert into ipinfo (ip,time) values ('s','dsf')";
跟踪说insert语句错误?
是access数据库,id是自动编号,ip和time是文本,而另一个语句正常插入,没道理不行吧,就这么短的东西?
可能的错误是什么?
跟踪说insert语句错误?
是access数据库,id是自动编号,ip和time是文本,而另一个语句正常插入,没道理不行吧,就这么短的东西?
可能的错误是什么?
string time = DateTime.Now.ToLocalTime().ToString();
HttpRequest request = HttpContext.Current.Request; if (request.ServerVariables["HTTP_VIA"] != null)
{
ip = request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString().Split(',')[0].Trim();
}
else
{
ip = request.UserHostAddress;
}
con.Close();
con.Open();
//string ipstr = "INSERT INTO ipinfo (ip,time) values ('" + ip + "','" + time + "')";
string str = "insert into ipinfo (ip,time) values ('s','ds')";
OleDbCommand cdm = new OleDbCommand(str, con);
try
{
int num = cdm.ExecuteNonQuery();
}
catch (Exception ex)
{ }
con.Close();
这就是全部了,是在看不出那里错了,但换了表名字段名为什么就可以呢?
错误是insert into语句的语法错误
------
关键字...