UC知道ASP插入语句
来源：百度知道 编辑：UC知道 时间：2024/06/07 18:53:26
<%
dim sortname,brand,PhotoUrl,pattern,style,size,color,texture,provider,price,summarize,contact
sortname=replace(trim(request.form("sortname")),"'","")
brand=replace(trim(request.form("brand")),"'","")
PhotoUrl=replace(trim(request.form("PhotoUrl")),"'","")
pattern=replace(trim(request.form("pattern")),"'","")
style=replace(trim(request.form("style")),"'","")
size=replace(trim(request.form("size")),"'","")
color=replace(trim(request.form("color")),"'","")
texture=replace(trim(request.form("texture")),"'","")
uprovider=replace(trim(request.form("provider")),"'","")
price=replace(trim(request.form("price")
dim sortname,brand,PhotoUrl,pattern,style,size,color,texture,provider,price,summarize,contact
sortname=replace(trim(request.form("sortname")),"'","")
brand=replace(trim(request.form("brand")),"'","")
PhotoUrl=replace(trim(request.form("PhotoUrl")),"'","")
pattern=replace(trim(request.form("pattern")),"'","")
style=replace(trim(request.form("style")),"'","")
size=replace(trim(request.form("size")),"'","")
color=replace(trim(request.form("color")),"'","")
texture=replace(trim(request.form("texture")),"'","")
uprovider=replace(trim(request.form("provider")),"'","")
price=replace(trim(request.form("price")
sql="insert into costume(sortname,brand,PhotoUrl,pattern,style,size,color,texture,provider,price,summarize,contact) values('"+sortname+"','"+brand+"','"+PhotoUrl+"','"+pattern+"','"+style+"','"+size+"','"+color+"','"+texture+"','"+provider+"','"+price+"','"+summarize+"','"+contact+"')"
response.write sql
response.end()
conn.execute sql
conn.close
set conn=nothing
response.redirect "DownAddSave.asp"
%>
改成这样之后，把网页执行结果发过来看看。
而且列名中含有sql server的保留关键字size，你最好在size改成[size]
那恐怕是你数据库有些字段是数字型的或者其他，反正不全是字符型的，导致插入失败。如果是sqlserver，你可以用查询分析器试着执行。
uprovider=replace(trim(request.form("provider")),"'","")
改为
provider=replace(trim(request.form("provid