以下是实例,查询news表中所有tsing发表的新闻 ------------------------------------------------------
( x7 Y; A2 h$ G! n+ u" J et conn = Server.CreateObject("Adodb.Connection")
; k+ |9 t4 g+ e" v# w/ K6 [6 p conn.ConnectionString = connString
# ^' l' L. A! @& ` conn.open()$ U/ @, y7 c/ T9 v$ T
set mycmd = Server.CreateObject("ADODB.Command")
( ?8 Z1 X, A* } mycmd.ActiveConnection=conn" L. U0 T$ X7 w5 {8 H
mycmd.CommandText=sql
; Y3 F+ z5 R" T! g( D mycmd.Prepared = true
# m. s3 S$ H& P/ [9 m7 v6 c1 |( @ set mypar = mycmd.CreateParameter("temp",129,1,50,"tsing")
! ~) _9 m& c. Q/ N4 l mycmd.Parameters.Append mypar9 a! j: `% A0 r. c( b
set myrs = mycmd.Execute+ d4 r' u: O* K+ U
与上面基本相同不同的地方法是asp在对参数的表达上面不同
, k6 a% V7 x3 ^ 129为adChar,1就是指示输入参数(是其实是默认值)0 q/ u: D8 L4 Q; H
大家请参阅MICROSOFT的ADOVB.Inc:
) {4 X' t2 d3 L. s0 F" { ’---- ParameterDirectionEnum Values ----
( c5 V# J1 D& `/ l$ {1 B. K) S+ [/ i Const adParamUnknown = 0" ?) J2 n9 t/ r3 _
Const adParamInput = 1. O" H$ {# m9 z
Const adParamOutput = 2
4 P9 d0 E$ G8 [8 M Const adParamInputOutput = 3
2 ?6 r: m9 d1 f% q9 d/ g) H Const adParamReturnValue = 4; U n' M4 B$ s; L7 T. a
’---- DataTypeEnum Values ----
. s' a0 m# m& Y1 _- } Const adEmpty = 0
5 \ Y) F/ A+ y' Q1 U8 v2 G% r Const adTinyInt = 16
- z8 W3 h4 e/ p+ ]- |+ G7 y Const adSmallInt = 2$ \! m+ ^! P+ b% R% u! c
Const adInteger = 3
& E' M: H8 Q3 ? J( Q Const adBigInt = 20
+ S, n- q/ L% r9 v4 a Const adUnsignedTinyInt = 17
* r, N- V$ Z, }4 {9 O1 m Const adUnsignedSmallInt = 18
) d' |6 n; l. {6 s/ K3 N5 }4 V Const adUnsignedInt = 19
- u# M7 j% R2 S* l2 x: i( k" G5 h) k0 ] P) }* b
Const adUnsignedBigInt = 21 |