日期:2014-05-17  浏览次数:21002 次

一个关于指定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

------解决方案--------------------
怎么起不到效果
又错误还是?
------解决方案--------------------
应该是你一楼的做法!