一个关于指定ID提交的奇怪问题!!!!
请问高手~~
我这个已经有改成能按指定ID提交到数据库~~
但是就是总不行~请问是什么问题呢?
sql= "select * from MB_Info where id= "&(id)
这句起不到效果~~~请高手帮我看下~`
<%
id = CInt(Request.QueryString( "ID "))
dim rs
dim formsize,formdata,bncrlf,divider,datastart,dataend,mydata
formsize=request.totalbytes
formdata=request.binaryread(formsize)
bncrlf=chrB(13) & chrB(10)
divider=leftB(formdata,clng(instrb(formdata,bncrlf))-1)
datastart=instrb(formdata,bncrlf & bncrlf)+4
dataend=instrb(datastart+1,formdata,divider)-datastart
mydata=midb(formdata,datastart,dataend)
%>
<!--#include file= "conn.asp "-->
<%
sql= "select * from MB_Info where id= "&(id)
set rs=conn.execute(sql)
id=rs( "id ")
Set rs = Server.CreateObject( "ADODB.Recordset ")
rs.Open "MB_Info ",conn,3,2
rs.addnew
rs( "big ").appendchunk mydata
rs.update
set rs=nothing
set conn=nothing
%>
------解决方案--------------------sql= "select * from MB_Info where id= "&id
------解决方案--------------------怎么起不到效果
又错误还是?
------解决方案--------------------应该是你一楼的做法!