Passing Data Parameters through ASP

[paulnew2000]

I have successfully passed userid and password for my SQL Server logon through a script, but I'm not able to get this to work.

I called Seagate but they were very little help, though very courteous.

This is my current attempt:
===
Set session("ParamCollection&quot = session("oRpt&quot.ParameterFields
Set oParam = session("ParamCollection&quot.Item(1)
Call oParam.ClearCurrentValueAndRange
Call oParam.AddCurrentValue(CDate(#1999/10/01 #))
Set oParam = session("ParamCollection&quot.Item(2)
Call oParam.AddCurrentValue(CDate(#1999/12/01 #))
===

 

[dcm]

PaulNew2000: Why not use 1 paramater defined as a range. You could then use ClearCurrentValueAndRange and AddCurrentRange passing both responses comma separated. David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[Dougo]

set StoredProcParamCollection = Session("oRpt&quot.ParameterFields

' - get the specific Store Procedure Parameter
' Create a variable and point it to the specific stored procedure
' that we want to work on

Set StoredProcParam1 = StoredProcParamCollection.item(1)
Set StoredProcParam2 = StoredProcParamCollection.item(2)
Set StoredProcParam3 = StoredProcParamCollection.item(3)
Set StoredProcParam4 = StoredProcParamCollection.item(4)

' - save the new value to the Stored Proc Param
' Create a variable and store the new value for the Stored Procedure
' in it

ParamValue1 = "27" 'CustomerID
ParamValue2 = "10" 'ProductID
ParamValue3 = "11/01/1999" 'Start Date
ParamValue4 = "12/15/1999" 'Stop Date

' Save the new value for the Stored Procedure in the Store Procedure
' Always use a string param... it seems to work the best. for some reason
' it does not matter what the param is actually defined as in the SQL procedure
' so use it this way until you run into a problem....
StoredProcParam1.SetCurrentValue cstr(ParamValue1), 12 '12 means a string param
StoredProcParam2.SetCurrentValue cstr(ParamValue2), 12 '12 means a string param
StoredProcParam3.SetCurrentValue cstr(ParamValue3), 12 '12 means a string param
StoredProcParam4.SetCurrentValue cstr(ParamValue4), 12 '12 means a string param