UC知道向sql写不进数据
来源：百度知道 编辑：UC知道 时间：2024/05/28 17:32:19
我的ASP网站在本地调试没问题,传到服务器端之后,就向数据库增加不了新记录,就好像没有执行增加语句一样。
是ASP+MSSQL结构的。
程序是：
SQL = "Insert Into [pH_Company_Base] (Comid,Username,Password,CompanyName,Question,Answer,Licence,Industry,Properity,Set_Year,Set_Month,Set_Day,Workers,Reg_Currency,CurrencyType,Company_Memo,ContactPerson,Phone,PhoneKeep,CompanyFax,Email,EmailKeep,Locus_Area,Locus_City,Address,ZipCode,WebHome,RegDate,LastIp,LoginCount,LastDate,LastUpdate_Time,LogoKeep,Nc_Vip_Flag,ViewClicks,PublishCount,Nc_Vip_Clicks,Nc_Vip_Jobs,Flag,Nc_Video,Video_Flag,Websub) Values ('"&Comid&"','"&Username&"','"&Password&"','"&CompanyName&"','"&Question&"','"&Answer&"','"&Licence&"',"&Industry&","&Properity&","&Set_year&","&Set_month&","&Set_day&","&Workers&","&Reg_Currency&","&CurrencyType&",'"&Company_Memo
是ASP+MSSQL结构的。
程序是：
SQL = "Insert Into [pH_Company_Base] (Comid,Username,Password,CompanyName,Question,Answer,Licence,Industry,Properity,Set_Year,Set_Month,Set_Day,Workers,Reg_Currency,CurrencyType,Company_Memo,ContactPerson,Phone,PhoneKeep,CompanyFax,Email,EmailKeep,Locus_Area,Locus_City,Address,ZipCode,WebHome,RegDate,LastIp,LoginCount,LastDate,LastUpdate_Time,LogoKeep,Nc_Vip_Flag,ViewClicks,PublishCount,Nc_Vip_Clicks,Nc_Vip_Jobs,Flag,Nc_Video,Video_Flag,Websub) Values ('"&Comid&"','"&Username&"','"&Password&"','"&CompanyName&"','"&Question&"','"&Answer&"','"&Licence&"',"&Industry&","&Properity&","&Set_year&","&Set_month&","&Set_day&","&Workers&","&Reg_Currency&","&CurrencyType&",'"&Company_Memo
首先在语句出插入断点调试,把实例含数据的SQL语句拷贝到SQL查询器中试试能不能运行,若不能运行就是SQL语句错误,看错误报告修改即可,若SQL语句没错误,那就是asp代码Conn.Execute(SQL)没执行成功