OLD ASP ... how to set a ADO param to Null

[Stewart Rogers]

I am doing a loop in which the Date field is sometimes
null

How do I update a Stored Proc parameter to null

I am looking for something like:

Cmd.Parameter("@NewDate").value = null

Thanks in advance,

Stewart Rogers

[Manohar Kamath [MVP]]

You can just leave the field out, without setting it to anything. The
following article might answer your question:

[url]http://www.vbrad.com/source/src_null_params_sp.htm[/url]

--
Manohar Kamath
Editor, .netWire
[url]www.dotnetwire.com[/url]


"Stewart Rogers" <[email protected]> wrote in message
news:1c5cb01c4527f$d5ebc860$[email protected]..

> I am doing a loop in which the Date field is sometimes
> null
>
> How do I update a Stored Proc parameter to null
>
> I am looking for something like:
>
> Cmd.Parameter("@NewDate").value = null
>
> Thanks in advance,
>
> Stewart Rogers

[Bob Barrows [MVP]]

Stewart Rogers wrote:

> I am doing a loop in which the Date field is sometimes
> null
>
> How do I update a Stored Proc parameter to null
>
> I am looking for something like:
>
> Cmd.Parameter("@NewDate").value = null
>

If you are not using a variable, then you don't have to do anything.

if <date supplied> then
Cmd.Parameter("@NewDate").value = #6/15/2004#
End if

However, if you are doing something like this:

Cmd.Parameter("@NewDate").value = datevariable

Then you need to set datevariable to null before setting the parameter
value:

if <no date supplied> then
datevariable = null
End if
Cmd.Parameter("@NewDate").value = datevariable

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.