UC知道ASP语言中update语句更新数字类型字段的问题
来源：百度知道 编辑：UC知道 时间：2024/09/20 23:49:10
用update语句更新数字类型字段时出现问题:chamber_phone字段总是更新为0。
我的部分代码如下：
=================================================================
dim new_chamber,new_phone,new_qq,new_mobile,new_intro
new_chamber=trim(request.form("chamber"))
new_phone=CLng(request.form("phone_number"))
new_qq=trim(request.form("qq"))
new_mobile=trim(request.form("mobile_phone"))
new_intro=trim(request.form("intro"))
if new_chamber<>chamber_number or new_phoner<>chamber_phone or new_qq<>qq or new_mobile<>mobile_phone or new_intro<>number_intro then
str="update classmate set chamber_number='"&new_chamber&"',chamber_phone="&new_phone&",QQ='"&new_qq&"',mobile_phone='"&new_mobile&"',number_intro='"&new_intro&"' where student_ID='"&id&"'"
db.execute(str)
==============
我的部分代码如下：
=================================================================
dim new_chamber,new_phone,new_qq,new_mobile,new_intro
new_chamber=trim(request.form("chamber"))
new_phone=CLng(request.form("phone_number"))
new_qq=trim(request.form("qq"))
new_mobile=trim(request.form("mobile_phone"))
new_intro=trim(request.form("intro"))
if new_chamber<>chamber_number or new_phoner<>chamber_phone or new_qq<>qq or new_mobile<>mobile_phone or new_intro<>number_intro then
str="update classmate set chamber_number='"&new_chamber&"',chamber_phone="&new_phone&",QQ='"&new_qq&"',mobile_phone='"&new_mobile&"',number_intro='"&new_intro&"' where student_ID='"&id&"'"
db.execute(str)
==============
new_phone=CLng(request.form("phone_number"))
这一行你直接给它值,不要用CLng()转换试试,
new_phone=request.form("phone_number")
电话号码里一般包含“-”，怎么能用长整型呢？
用varchar(20)就没问题了。