in asp code

cmd.parameters.append cmd.createparameter("@MsgContent",200,1,400)
200:varchar type
1:input
400: length

yes or no?

I want use a argument which it is a datetime type. what can i do?

Hi,
    here I am giving syntax..
  .Parameters.Append cmd.CreateParameter("EndDate",adDate, adParamInput, 8, "10/10/2004")


Here
EndDate : varaiable name that is there in tha database.
adDate: Type
adParamInput: input type
8 is the size
"10/10/2004" is the value.
similarly

.Parameters.Append cmd.CreateParameter("ID", adInteger, adParamInput, 4 ,1000)





Thanks
Suresh

if cmd.CreateParameter's option express with numeric
such as
cmd.CreateParmater("@sendTime",4,1,8) ???

Here are the values of all possible data types:

Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205

and here are the values for parameter direction:
Const adParamUnknown = 0
Const adParamInput = 1
Const adParamOutput = 2
Const adParamInputOutput = 3
Const adParamReturnValue = 4

leave out the size when adding date and int parameters

hth
Phil

thanks *_*