当前位置: 代码迷 >> ASP >> 求解语句的写法,好心人进解决方案
  详细解决方案

求解语句的写法,好心人进解决方案

热度:82   发布时间:2012-03-09 21:42:54.0
求解语句的写法,好心人进
<%
Dim   c_id,S,StrTime_Name,real_id

Randomize   Timer
S                             =   Int((8999)   *   Rnd   +   1000)
Str                         =   Asc(Hex(S))

Print_DateTime   =   Now()
Time_Name             =   MakeFileName(Print_DateTime)
real_id                 =   "a "   &   Time_Name   &   Str  

c_id                       =   Cint(Request( "Select_cid "))
response.write   c_id
Article_Title     =   Request( "Article_Title ")
      Doc_Content   =   trim(Request.form( "cnWords "))  
      Doc_Content   =   Replace(Doc_Content, " <script ", " <sscript ")  
      Doc_Content   =   Replace(Doc_Content, "/script> ", "/scripts> ")
      Doc_Content   =   Replace(Doc_Content, "/script   > ", "/scripts> ")
RealLink               =   Request( "RealLink ")
'-------------------------------这一段有问题
Href_Add               =   "Content.asp?id=&   real_id   & "
'-------------------------------
AddUser                 =   Session( "Admin_UserName ")
AddTime                 =now()

Call   Find_UpClass()
Call   Add_Content

Function   Find_UpClass()
      Call   Open_Conn()
'-------------------------------这一段有问题
      Sql1= "Select   id,menuname     From   Menu_Unlimited   a   Where   exists(Select   *   From   Menu_Unlimited   b   Where   b.p_id   =   a.id   and   b.id   =   "&   c_id   & ") "
'-------------------------------
      Set   Rs1=server.CreateObject( "adodb.recordset ")
      Rs1.open   sql1,Conn,1,1
End   Function

Function   Add_Content
      Call   Open_Conn()
      Call   Find_UpClass()
'-------------------------------这一段有问题,提示“类型不匹配:   'Rs1 '”
      Sql2= "Insert   into   ContentTable   (p_id,p_name,c_id,c_name,Article_Title,Article_Content,Href_Add,AddUser,AddTime,RealLink,real_id)   values   ( "&   Rs1( "id ")   & ", "&   Rs1( "menuname ")   & ", ' "&   c_id   & " ', ' "&   c_name   & " ', ' "&   Article_Title   & " ', ' "&   Doc_Content   & " ', ' "&   Href_Add   & " ', ' "&   AddUser   & " ', ' "&   AddTime   & " ', ' "&   RealLink   & " ', ' "&   real_id   & " ') "
'-------------------------------
      Set   Rs2=server.CreateObject( "adodb.recordset ")
  相关解决方案