Web Development

hopefully simple IE control question

26-Jun-03 4:41

This is caused from too many connections at the same time.

A workaround might be to use the OLEDB driver:

"yourConnectionName.Open "Provider=Microsoft.Jet.OLEDB.4.0;" &_<br />
<br />
"Data Source=E:\foldername\databasename.mdb;" &_<br />
<br />
"Persist Security Info=false"

But I would look into U/G to SQL Server. As a rule MS Access will allow 10 concurrent connections to the DB, sometimes it will throw an error, and sometimes not.

Also be sure that you are closing your connection within your code:

yourConnectionName.Close<br />
<br />
Set yourConnectionName = Nothing

HTH

Tony

MikeBeard26-Jun-03 3:45

MikeBeard

26-Jun-03 3:45

I'm new to using the IE control (MSHTML) and am not sure how to do something. I know it should be possible. Here it is:

If I have an object embedded in an HTML page and I display that page within the IE control, how do I get it programmatically? It has an ID and all of that.

<br />
<!-- DHTML Editing control Object. This will be the body object for the toolbars. --><br />
<object ID="tbContentElement" CLASS="tbContentElement" CLASSID="clsid:2D360201-FFF5-11D1-8D03-00A0C959BC0A" VIEWASTEXT><br />
  <param name=Scrollbars value=true><br />
</object><br />

How do I get programmatic access to the tbContentElement object?

Any help, tips, or pointers to articles or whatever are/will be greatly appreciated.

Thanks,
Mike

Re: hopefully simple IE control question

hkulten26-Jun-03 4:24

hkulten

26-Jun-03 4:24

You must use IHTMLDocument2 interface. You can find some help on msdn.microsoft.com :
http://msdn.microsoft.com/library/default.asp?url=/workshop/browser/mshtml/reference/reference.asp

example of function to retrieve the value of a tag in a html page :

CString YourApp::GetTagValue(LPDISPATCH lpDispatch, CString strTagId)
{
CString strVal = "";
IHTMLDocument2* pHTMLDocument2 = NULL;

if (lpDispatch == NULL)
return "";

HRESULT hr = lpDispatch->QueryInterface(IID_IHTMLDocument2, (LPVOID*)&pHTMLDocument2);
lpDispatch->Release();

if (hr != S_OK)
return "";

IHTMLElementCollection *pElementCollection = NULL;
hr = pHTMLDocument2->get_all(&pElementCollection);

if (hr != S_OK || pElementCollection == NULL)
return "";

long nElt = 0;
if (pElementCollection->get_length(&nElt) != S_OK)
return "";

for (int i=0; i<nelt; i++)
="" {
="" variant="" varindex,="" var2;
="" varindex.vt="VT_UINT;
" varindex.lval="i;
" variantinit(&var2);
=""
="" idispatch*="" pdisp="NULL;
" hr="pElementCollection-">item(varIndex, var2, &pDisp);

if (hr == S_OK && pDisp != NULL)
{
IHTMLElement* pElem = NULL;
hr = pDisp->QueryInterface(IID_IHTMLElement, (void**)&pElem);

if (hr == S_OK && pElem != NULL)
{
BSTR bstrId = 0, bstrVal = 0;
hr = pElem->get_id(&bstrId);
CString strId(bstrId);
strId.MakeLower();

// Oups, we find our tag !!!
if (strId.Find(strTagId) != -1 && strId != "")
{
// Retrieve all html code
pElem->get_innerHTML(&bstrVal);
strVal = CString(bstrVal);
}
pElem->Release();
}
pDisp->Release();
}
}
pElementCollection->Release();
return strVal;
}

you can use this function like this:

CString strValue = GetTagValue(m_web.GetDocument(), "myid");

With a object embedded in a html page, I think you must use the IHTMLObjectElement interface instead of the IHTMLElement interface.

This is not easy to play with the syntax of theses interfaces, but it works.... Good luck !!!

Wink | ;)

Re: hopefully simple IE control question

MikeBeard26-Jun-03 8:09

MikeBeard

26-Jun-03 8:09

Thanks! This will get me started.

MS Office extenions w/ ASP.NET

Nino_125-Jun-03 19:19

Re: MS Office extenions w/ ASP.NET

25-Jun-03 19:19

I have a client that needs to do Powerpoint presentations from his web site.

Does anyone know of any example of this using ASP.NET (C# or VB.NET).

Thanks

Tony

basementman26-Jun-03 4:03

Re: MS Office extenions w/ ASP.NET

26-Jun-03 4:03

Why not just put the ppt file out on the web site and add a link to this file? It will download the ppt and open Powerpoint (or viewer) to display the presentation.

onwards and upwards...

SimonS27-Jun-03 20:35

SimonS

27-Jun-03 20:35

Can't you just save a PPT as HTML?

Cheers,
Simon

"Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
animation mechanics in SVG (my first abstract photo)

get name? print name !

seccondbest24-Jun-03 11:00

seccondbest

24-Jun-03 11:00

on my first page i want to get a name and asign it to a variable:
exsample.....

please enter your name here .......

on submit we will go to next webpage

on the next page i want the name to be seen again,
exsample.....

this is where your name ...... could have apeared, if you would have filled it out on page one.

is there a way that java gets the name, assigns it to a variable
and than later use that variable to print the name again?

i have searched and searched tried many things but cant find it, i am totaly new to programming so if you know anything to help me out i will be thankfull

Re: get name? print name !

John Kuhn24-Jun-03 11:11

John Kuhn

24-Jun-03 11:11

There's an example Smile | :)

of this using cookies & JavaScript here on the JavaScript Source site.

Exam questions

boro1224-Jun-03 6:56

boro12

24-Jun-03 6:56

Check out "PocketPrep" from handango.com.
It has 90 questions based on the test spec. (070-316 and 070-306)

Re: Exam questions

-- NA --24-Jun-03 7:32

-- NA --

24-Jun-03 7:32

A tip: get out your flameproof suit Suspicious | :suss:

Paul

I have been afraid always. When you see something insurmountable ahead of you, say to yourself: "All right! I am afraid. Now that I've been properly afraid, let's go forward." That is the whole secret. - Jeanne d'Arc

modified 18-Jul-18 11:59am.

Re: Exam questions

SimonS27-Jun-03 20:38

SimonS

27-Jun-03 20:38

Paul van der Walt wrote:
A tip: get out your flameproof suit
Laugh | :laugh:

Some ppl just don't understand that "web dev" doesn't = arb test exams from MS that don't mean anything anyway.

Cheers,
Simon

"Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
animation mechanics in SVG (my first abstract photo)

Re: Exam questions

theJazzyBrain25-Jun-03 3:58

theJazzyBrain

25-Jun-03 3:58

hmmm....

Interesting....

Not a question or a suggestion....

Not an article proposal....

Not Web Developlment related....

hmmm.... what else?....

trying to advertise something here maybe.??....

Cmon CPians help me here....

Is this in anyway related to THIS SPECIFIC Message board?

Is there something that I didnt get?

WHICH PART OF
"Discussions on ASP / HTML/ DHTML / Javascript etc"
DIDNT HE UNDERSTAND ??...

...HMMM I REALLY WONDER!!...

|---------------|
| theJazzyBrain |
|---------------|

<select> with onchanging

jerry0davis24-Jun-03 5:33

jerry0davis

24-Jun-03 5:33

If use .

The problem is, I would like to know what the selection is BEFORE the drop down was dropped. anyone know if or how I can do this please?

Basically I would like ing="dosomething">.

I feel like I'm diagonally parked in a parallel universe

Jeremy Davis
http://www.astad.org
http://www.jvf.co.uk

Re: <select> with onchanging

basementman24-Jun-03 7:17

Re: <select> with onchanging

24-Jun-03 7:17

You can always create a property on the select to store the previous value and update it in your onchange handler. EX:

<script language=javascript><br />
<br />
function OnSelectChange() {<br />
var oElem = window.event.srcElement;<br />
var cOrigValue = oElem.LastValue;<br />
var cCurrValue = oElem.value;<br />
<br />
.. do whatever here...<br />
<br />
// and update the last value<br />
oElem.LastValue = cCurrValue;<br />
}<br />
<br />
</script><br />
<br />
<select name="MyDropdown" LastValue="" onchange="OnSelectChange()"><br />
  <option value="red">Red</option><br />
  <option value="white">White</option><br />
  <option value="blue">Blue</option><br />
</select>

onwards and upwards...

jerry0davis24-Jun-03 21:55

jerry0davis

24-Jun-03 21:55

Thanks. I'll give that a try.....

I know some events don't work in Netscape. Will this?

I feel like I'm diagonally parked in a parallel universe

Jeremy Davis
http://www.astad.org
http://www.jvf.co.uk

Re: <select> with onchanging

basementman25-Jun-03 4:10

25-Jun-03 4:10

Not sure about Netscape. We stopped developing for Netscape about 4 years ago. It is a HORRIBLE platform to develop real, functional business apps for.

onwards and upwards...

IE and NS

Brakanjan24-Jun-03 0:06

Brakanjan

24-Jun-03 0:06

Hi
I have code where I position a dot on a map. I use a lot of style="position:absolute; left: numberpx; top: numberpx" code, but problem is it doesn't work in Netscape.

Where can I found comparisons of the two browsers especially for this type of problem

tx

Re: IE and NS

basementman24-Jun-03 4:52

24-Jun-03 4:52

Get used to it. Not much works correctly on Netscape.

onwards and upwards...

Re: IE and NS

ZoogieZork24-Jun-03 14:36

ZoogieZork

24-Jun-03 14:36

What version of Netscape?

A good list of many known bugs in the CSS implementations of different browsers can be found here:
http://www.richinstyle.com/[^]

Unfortunately, it only covers up to IE5.5 and NS6.

- Mike

SSL Certs on web farms

Megan Forbes22-Jun-03 22:19

Megan Forbes

22-Jun-03 22:19

We are going to be moving from one live web server, to 3 forming a web farm in the next month or so. We'll be using SQL and cookies to track sessions, and so far the examples I've looked at look great. However, one thing I'm not too sure of it the Verisign certificates. Obviously I have contacted them for more info, and it's looking very interesting, but I was wondering if anyone has experience of this, and if so, what advice (do's / don'ts Smile | :)

) you give?

Thanks Smile | :)

To honor you, and your sick games, this smiley Poke tongue | ;-P

will now represent licking chocolate off candy - David Chamberlain

Nino_123-Jun-03 16:14

23-Jun-03 16:14

I would, if you can ! get your own certificate server (Netscape).

You can request your certs from the MMC within IIS (if you are using IIS) and go to town

The cipher strength can be whatever 40bit, 128bit etc.

This will insure the protection of the packets being routed and the whole nine yards.

My employer considred VeriSign but decided it was too much of a hassle, not to mention the overhead.

Tony

Rocky Moore23-Jun-03 22:38

Rocky Moore

23-Jun-03 22:38

Do you know of a good on-line tutorial on this subject. I have been planning on a SSL gatway on my web server but it is all new to me, have not done anything with SSL/HTTPS before.

Rocky Moore <><

Nino_124-Jun-03 15:16

24-Jun-03 15:16

Rocky,

I found this "how to" on technet:

Enable SSL for All Customers Who Interact with Your Web Site in Internet Information Services

And this one on Cisco:

Cisco IOS Public-Key Infrastructure:
Deployment Benefits and Features

Tony