懂SQL的进来看看哦？ [复制链接]

SPt/$uYJ  
看看怎么回事？

2005 March 15 20:29:05:select minperpoint,pointadd from pointmethod where id='NORMAL' SPt/$uYJ  
2005 March 15 20:29:05:ODBC:[Microsoft][ODBC SQL Server Driver][SQL Server]将 varchar 值 'NORMAL' 转换为数据类型为 int 的列时发生语法错误。 SPt/$uYJ  
2005 March 15 20:29:05:Get pointpermin=1,nochargemin=0 SPt/$uYJ  
2005 March 15 20:29:05:select starttime,endtime from pointmethod where id='NODEDUCT' SPt/$uYJ  
2005 March 15 20:29:05:ODBC:[Microsoft][ODBC SQL Server Driver][SQL Server]将 varchar 值 'NODEDUCT' 转换为数据类型为 int 的列时发生语法错误。 SPt/$uYJ  
2005 March 15 20:29:05:Get NopayStart=?NopayEnd= SPt/$uYJ  
2005 March 15 20:29:05:select starttime,endtime,minperpoint from pointmethod where id='DAYLY' SPt/$uYJ  
2005 March 15 20:29:05:ODBC:[Microsoft][ODBC SQL Server Driver][SQL Server]将 varchar 值 'DAYLY' 转换为数据类型为 int 的列时发生语法错误。 SPt/$uYJ  
2005 March 15 20:29:05:Get DaylyStart=
,DaylyEnd=p???m???,PointDayly=1596872 SPt/$uYJ  
2005 March 15 20:29:05:select starttime,endtime,pointadd from pointmethod where id='SPECIAL' SPt/$uYJ  
2005 March 15 20:29:05:ODBC:[Microsoft][ODBC SQL Server Driver][SQL Server]将 varchar 值 'SPECIAL' 转换为数据类型为 int 的列时发生语法错误。 SPt/$uYJ  
2005 March 15 20:29:05:Get m_BonusStart=X?,m_BonusEnd=T?,PointAdd=2090009937 SPt/$uYJ  
2005 March 15 20:29:05:select endtime,minperpoint from pointmethod where id='DAYDEDUCT' SPt/$uYJ  
2005 March 15 20:29:05:ODBC:[Microsoft][ODBC SQL Server Driver][SQL Server]将 varchar 值 'DAYDEDUCT' 转换为数据类型为 int 的列时发生语法错误。 SPt/$uYJ  
2005 March 15 20:29:05:Get DayDeduct=00000001000000,DalyDeductPoint=1304644 SPt/$uYJ  
2005 March 15 20:29:05:select endtime,minperpoint from pointmethod where id='HALFDAYDEDUCT' SPt/$uYJ  
2005 March 15 20:29:05:ODBC:[Microsoft][ODBC SQL Server Driver][SQL Server]将 varchar 值 'HALFDAYDEDUCT' 转换为数据类型为 int 的列时发生语法错误。 SPt/$uYJ  
2005 March 15 20:29:05:Get HalfDayDeduct=00000000120000,HalfDalyDeductPoint=1596880 SPt/$uYJ  
2005 March 15 20:29:05:Get Ip table end.. SPt/$uYJ  
2005 March 15 20:33:03:socket_Listen Success at port:8765

varchar 是字符串 怎么可能转为int数字型捏

是不是数据库里的数据有问题...,有成功的4F吗?

不清楚了~

[em06]

数据源里问题应该是这样的.

是不是数据库连接有问题????

varchar可以是字符也可以是数字，你转换的那个列里有字符所以转换成数字就报错了

根据翻译得知：数据库与你的ODBC连接错误，请检查　具体问题可能在Ip设置上！

类型不同~