Passing a Null Value

[zfisherdrums]

Branching off this post slightly. Are there any other ways to pass a NULL value to an object's method? I've tried empty strings and '0' to no avail.

[Kerros]

chr(0x00) would be null

[zfisherdrums]

Hello Kerros,

CHR( 0x00 ) would be a Null character. I believe that is different than a NULL value.

I gave it a college try on the code anyway and it didn't fly.

Thanks for the quick reply, though.

Zach...

[SmOke_N]

$obj.Nothing doesn't work? (Really no idea, but I believe I've seen it before in use somewhere... Just taking a stab)

Edited November 27, 2007 by SmOke_N

[zfisherdrums]

$obj.Nothing doesn't work? (Really no idea, but I believe I've seen it before in use somewhere... Just taking a stab)

Frayed Knot. I don't see any properties or enumerations that would return a NULL value either.

From the MDAC SDK:

To disconnect a Recordset, open it with a cursor location of adUseClient, and then set the ActiveConnection property equal to Nothing. (C++ users should set the ActiveConnection equal to NULL to disconnect.)

Zach... Edited November 27, 2007 by zfisherdrums

[big_daddy]

You need to use the "default" keyword and it will work.

[zfisherdrums]

Unless I'm implementing it incorrectly, I've tried using that and received the following message:

==> The requested action with this object has failed.:

$objRecordSet.ActiveConnection = Default

$objRecordSet.ActiveConnection = Default^ ERROR

Edited November 27, 2007 by zfisherdrums

[big_daddy]

Unless I'm implementing it incorrectly, I've tried using that and received the following message:

==> The requested action with this object has failed.:

$objRecordSet.ActiveConnection = Default

$objRecordSet.ActiveConnection = Default^ ERROR

Try...

$objRecordSet.ActiveConnection(Default)

[zfisherdrums]

Tried it and fried it.

I can definitely retrieve results from my data store without disconnecting the ActiveConnection.

But following the MS Support entry for setting Activeconnection = NULL is giving me a headache.

I'm going to go do some research. Thanks for continuing to help me out.

Zach...

[DaleHohm]

Also try:

$oAC = $objRecordSet.ActiveConnection

$oAC = ""

or

$oAC = $objRecordSet.ActiveConnection

$oAC = Default

Dale