Calling only the process of entering parameters. (ASP, ORACLE)

xiaoxiao2021-04-01  229

<% @ Language = "JavaScript"%> <% response.contenttype = "text / xml"; response.expires = -1; var conn = server.createObject ("adoDb.connection"; conn.open ("sczb" , "SCZB", "SCZB"); VAR Comm = Server.createObject ("AdoDb.command"); Var = Server.createObject ("AdoDb.Recordset"); conn.cursorLocation = 3;

Var finishtime, yy, mm, bm, gd; yy = request ("yy"); mm = request ("mm"); bm = request ("bm"); gd = request ("gd"); finishtime = mm "/" yy;

comm.CommandText = "HZBB_RWWCB_QUERY"; comm.CommandType = 4; var para1 = comm.CreateParameter ( "finishtime", 200,1,50, finishtime); comm.Parameters.Append (para1); var para2 = comm.CreateParameter ( "BM", 200, 1, 50, bm); comm.Parameters.Append (Para2); var para3 = comm.createParameter ("GD", 200, 1, 50, gd); Comm .Parameters.Append (PARA3) Comm .ctiveConnection = conn; rs = comm.execute;

. . . .

转载请注明原文地址:https://www.9cbs.com/read-131291.html

New Post(0)