Web Development

Acessing ActiveX Component / Library not registered

1-Jun-05 9:50

No, thank god! neither your computer nor anyone else's would be safe if there was!
Phil

Florian Storck1-Jun-05 4:20

Florian Storck

1-Jun-05 4:20

Hi there,

I've some problems accessing my ActiveX control from a VBScript/JScript. The control can be successfully initialized an acessed via the <object> tag.
The problem is, that I've to retrieve additional objects/interfaces from the control, which are all defined in the typelib embedded in the control. This likes somehow like this:

var ObjInst = new Object;

    // returns another IDispatch interface of an internal object
    ObjInst = Control.GetInstance();

    // creates a "Library not registered" error
    ObjInst.Method();

Because everythings working fine from CPP/VB when compiling, I would like to know, whether I have to register the typelib somehow in the html code or somewhere else, or whatever may cause this error. I can view the typelib in the OLE viewer supplied with visual studio, so the registration can't be that faulty in my opinion. My thaughts were, that acessing a reference to a IDispatch interface should be generally no problem in JScript/VBScript.

Thanks for any suggestions.

Florian

Stored Procedures

Brendan Vogt31-May-05 20:28

Brendan Vogt

31-May-05 20:28

Hi,

I'm still struggling to send null values to a stored procedure.

I have a textbox which doesn't require a value. If the textbox is empty, then it must pass a null value to the stored procedure, and I still have not found a solution. Once all validation has been done I add the value of the textbox to a strDialCode variable.

This is how I add my textbox to the CreateParameter method

objCmd.Parameters.Append objCmd.CreateParameter("@ContactDialCode", adWChar,
adParamInput, Len(strDialCode), strDialCode)

And here is my stored procedure, or part of it...

CREATE Procedure sp_InsertContact
(
@ContactDialCode nvarchar(10) = NULL
)

INSERT INTO tblContact
(
ContactDialCode
)
VALUES
(
@ContactDialCode
)

GO

I really hope someone can help me on this because I have been struggling for a couple of weeks on this.

Cheers.
Brendan

Christian Graus31-May-05 21:03

31-May-05 21:03

In C#, it's DbNull.Value - is there an ADO equivelant ?

I didn't think you could have default values in a stored procedure ?

Christian Graus - Microsoft MVP - C++

Brendan Vogt31-May-05 21:10

Brendan Vogt

31-May-05 21:10

I think you can pass a NULL to a stored procedure, but when I leave the length property blank, or out, then I also get an error. So if I can find a way to pass this, then I think it should work.

I have seen other stored procedures where they also use = NULL.

Can you maybe send me the CreateParameter string for adding s null value in C#? Maybe I can follow from that. Do they also require a length firld?

Please guys, help me out on this? I am new to stored procedures.

NeverHeardOfMe1-Jun-05 9:57

1-Jun-05 9:57

I don't care what the purists say, my advice is to avoid null values like the plague! Define all the db fields you can as NOT NULL and do whatever you have to fit in with it. In your example, for a ContactDialCode, siomply store an empty string instead. A plague upon NULLS!
cheers
Phil

Christian Graus1-Jun-05 11:37

1-Jun-05 11:37

ROTFL - at least you know this is a religious discussion. Sometimes, NULL has a real meaning ( for example, no string has been entered, as opposed to an empty string was entered ).

I believe it's a decision that's up to the consience of the individual churchgoer, but there are definately times when NULL is a meaningful value.

Christian Graus - Microsoft MVP - C++

NeverHeardOfMe1-Jun-05 13:32

Update HTML programmatically

1-Jun-05 13:32

yes, I know.... but since when did reason ever get in the way of reigion? Nullify NULLs, I say! (And as for the egghead who decided to use apostrophe's as string delimiters in SQL...;P)
Big Grin | :-D

Phil

asp

Anonymous31-May-05 17:52

Anonymous

31-May-05 17:52

how can i refesh the form/document (like f5 key) through the coding in asp

Re: asp

Anonymous31-May-05 18:21

Anonymous

31-May-05 18:21

ASP is a server technology. You can't refresh the users screen from the server. However, you perform a location.refresh() in javascript.

Re: asp

Vasudevan Deepak Kumar10-Jun-05 0:07

Vasudevan Deepak Kumar

10-Jun-05 0:07

You need to emit a client side JavaScript code to achieve this.

<Script Language="JavaScript"><br />
  self.location.reload(); //refreshes the current window page<br />
</Script>

Deepak Kumar Vasudevan
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/

frycdf31-May-05 9:21

frycdf

31-May-05 9:21

I have the need to insert a snippet of HTML into about 400 separate web pages. The first possibility is obviously to just open each file (different domains and accounts) paste the code and save (via MS FP).

Being the lazy person I am, I was hoping to someohow programmatically (ASP, VB etc) build something that can update those pages all at once (given the appropriate page name and login creds).

Any ideas?

TIA...

Christian Graus31-May-05 12:21

31-May-05 12:21

You want to write code that logs in to a remote web server, changes the HTML and then saves it ? No, that won't work. You'd need to FTP to the server to do that.

If your pages are XHTML, then an XSLT would be able to update all the pages for you.

Christian Graus - Microsoft MVP - C++

frycdf1-Jun-05 4:31

frycdf

1-Jun-05 4:31

Actually, I was planning on doing it via FTP and just wanted to find the best way/tool/method to programmatically update the file once I have it downloaded.

In other words, my program will grab the FTP address, login, download the file and then somehow modify it and put it back.

NeverHeardOfMe1-Jun-05 10:13

1-Jun-05 10:13

If you have write permission on the server, you could write an ASP.NET page that reads the files one by one, one line at a time, and writes them out to a temp file, inserting the required extra code along the way. Then rename the temp file as the original. Move on to next file. This kind of assumes the change is the same for all files, and there is some way of telling the script where to insert the new bits (eg, after the body tag)

This is not that hard to do. Examine the system.IO class for file functions, and the StreamReader and StreamWriter objects.

cheers
Phil

Christian Graus1-Jun-05 11:15