Sign in to follow this  
Followers 0
zfisherdrums

Passing a Null Value

10 posts in this topic




chr(0x00) would be null


Kerros===============================================================How to learn scripting: Figure out enough to be dangerous, then ask for assistance.

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

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

Edited by SmOke_N

Common sense plays a role in the basics of understanding AutoIt... If you're lacking in that, do us all a favor, and step away from the computer.

Share this post


Link to post
Share on other sites

#5 ·  Posted (edited)

$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 by zfisherdrums

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

#7 ·  Posted (edited)

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 by zfisherdrums

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

Also try:

$oAC = $objRecordSet.ActiveConnection

$oAC = ""

or

$oAC = $objRecordSet.ActiveConnection

$oAC = Default

Dale


Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl

MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model

Automate input type=file (Related)

Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded  Better Better?

IE.au3 issues with Vista - Workarounds

SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead?

Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0