Web Development

13-Jul-04 3:26

Hi, I'm suing ASP and connect to Access database. When I submit the data from an HTML form to the database it display the following error message: cannot update database or object read only. Does anybody know about the source of this problem? why it display this message?

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

DHTML and MFC

CodeBrain13-Jul-04 0:43

13-Jul-04 0:43

I am developing a MFC (VC++ 6) application which should be able to display some dynamic HTML content.
The HTML page has some static elements and some dynamic elements so I want to use DHTML.
I want to use a static HTML template and let my MFC application fill in the dynamic content. To display the HTML page I will use the IE browser component (or the MFC wrapper from Gary R. Wheeler http://www.codeproject.com/miscctrl/simplebrowserformfc.asp)

The problem which I have is: how can I access the dynamic HTML content (DOM) of my template and fill in my content using MFC.
Is there a DOM/DHTML parser?
I found a lot of information in the internet and in the MSDN library, but I could not find a good startig point.
Can anyone give me some hints or direct me into the correct direction? At least a starting point would help me a lot.

Thanks in advance.

Andrew Quinn AUS13-Jul-04 22:26

Andrew Quinn AUS

13-Jul-04 22:26

Hi,

So are you saying that you want to Navigate() to your static HTML page (template) and then you want to start populating the contents of the page using MFC?

Andy

CodeBrain14-Jul-04 4:08

14-Jul-04 4:08

Thanks for your answer Andy, it's exactly what you say.

Today I have found a solution. I can get a IHTMLDocument pointer. So I have access to the HTML code.

But that leads me to another question. How can I insert an image into the HTML code which is in memory and not on HD.
Must I save the image to a file in order to insert it into the HTML document or is there an other way?

Andrew Quinn AUS14-Jul-04 5:22

Andrew Quinn AUS

14-Jul-04 5:22

Hi,

Yes indeed IHTMLDocumentPtr is the starting point into the DOM.

One thing that will help in the long run is to import the HTML type library - thus getting Visual Studio to generate wrappers around the numerous interfaces and methods. It wraps using smart pointers - so no QueryInterface/Releases to take care of.

e.g. insert the following into either your header/implementation file

#import "C:\Windows\system32\mshtml.tlb" no_auto_exclude

This will generate two files, mshtml.tlh and mshtml.tli, in your project directory. The first is a header file, the next the implementation. With this done, here is a simple DHTML process from within MFC to get an element from the page...

void CWebDlg::OnDocumentCompleteExplorer1(LPDISPATCH pDisp, VARIANT FAR* URL) 
{
	USES_CONVERSION;

	MSHTML::IHTMLDocument2Ptr spDoc(m_ctlWeb1.GetDocument()); // This is the WebBrowser control
	if (spDoc)
	{
		MSHTML::IHTMLDocument3Ptr spDoc3 = spDoc;
		if (spDoc3)
		{
			MSHTML::IHTMLElementPtr spElem2 = spDoc3->getElementById(_bstr_t("idSpan1"));
			if (spElem2)
			{
				CString strText = W2T(spElem2->innerText);
				spElem2->innerText = _bstr_t("Hello There");
			}
		}

	}
}

See how we can easily get the different interfaces of the object. The wrapper is doing the QI under the covers when we do a simple assignment. Plus the smart pointer will release that reference once the object goes out of scope.

You can also easily create elements at will, e.g. here we create a BGSOUND element and append it to the DOM document.

MSHTML::IHTMLDocument2Ptr spDoc(m_ctlWeb1.GetDocument());
if (spDoc)
{
	MSHTML::IHTMLElementPtr spElem = spDoc->createElement(_T("BGSOUND"));
	if (spElem)
	{
		MSHTML::IHTMLBGsoundPtr spBG = spElem;
		if (spBG)
		{
			CString strURL = _T("http://xyzxyz/snd/newalert.wav");
			spBG->put_src((bstr_t)strURL);

			MSHTML::IHTMLDOMNodePtr spBody = spDoc->body;
			MSHTML::IHTMLDOMNodePtr spNode2Add = spBG;

			// append new element to BODY
			spBody->appendChild(spNode2Add);
		}
	}
}

To answer your question about inserting an image - I not too sure, something at the back of my mind does ring a bell about embedding IMG data in an HTML page. I'll see if I can find out. But for now I would think about saving the image to the file-system and then referencing the IMG src tag to the location.

If you have any questions about DHTML or using MFC to generate DHTML I'll be happy to answer them.

Hope this helps,
Andy

CodeBrain15-Jul-04 4:00

15-Jul-04 4:00

Thanks for the detailed answer. I think now I have the starting point I need.
But do I need the wrappers if I don't add new HTML elements? My plan is to change existing HTML elements only.
So If I get a pointer like IHTMLElement and change the properties of the object that should be no problem?

The MSHTML documentation in the MSDN library seems also to be very good.

Thanks for your help. Smile | :)

Andrew Quinn AUS15-Jul-04 4:25

Andrew Quinn AUS

15-Jul-04 4:25

Hi,

I would always use the wrappers as it will ease the time and readablity of your code. As an example, here is some code without the use of the wrappers:

IUnknown* lpUnk = m_pSite->GetObjectUnknown();
if ( lpUnk != NULL )
{
	HRESULT hr;

	IHTMLDocument2* pHTMLDocument2;
	hr = lpUnk->QueryInterface(IID_IHTMLDocument2, (void **)&pHTMLDocument2);
	if ( SUCCEEDED( hr ) )
	{
		BSTR bstrColor = SysAllocString( buff );
		VARIANT varColor;
		varColor.vt = VT_BSTR;
		varColor.bstrVal = bstrColor;
		hr = pHTMLDocument2-> put_bgColor( varColor );
		pHTMLDocument2->Release();
	}
}

and now the same code with the use of the wrappers:

MSHTML::IHTMLDocument2Ptr spDoc(m_pSite->GetObjectUnknown());
if (spDoc)
{
	spDoc->bgColor = bstr_t("#ffffff");
}

As you can see it is substantially cleaner. And this was a simple example.

You can also call any Javascript functions (from MFC) that are in the HTML page (I can show you how if you need to)
And also, you can implement an event handler at the MFC side such that, for example, an onclick HTML event will cause the web browser control to call into your application.

Hope this helps,
Andy

CodeBrain15-Jul-04 7:15

E-mail address around the world

15-Jul-04 7:15

Thanks again Smile | :)

I will try the wrappers. Since I only want to do some basic things I will not use JavaScript.

The simple browser wrapper for the MS Web Browser control which I use is very good. It already offers message handlers. So this should be easy.

You helped me a lot. Big Grin | :-D

java/tomcat 5.0

zedic12-Jul-04 23:40

zedic

12-Jul-04 23:40

I'm a newb.... & would like to know a way to run web apps outside the default web container location of tomcat 5.0 in windows 2000....running IIS...

crystal reports problem

Member 120813911-Jul-04 22:27

Member 1208139

11-Jul-04 22:27

I have two tables in MSSQL, say a,b , now I am creating a report in crystal with ado having two aliases as ado,ado_1, now ado fields are tagged in report header and ado_1 fields are tagged in details, there is a common field in both ado and ado_1 whic is used for linking, now when i link from ado to ado_1 I can see all the fields of ado, but not of ado_1 in detail, and if i change the link from ado_1 to ado i can see all the fields of ado_1 but not of ado, no complex struc exist, it a plain report
kindly help

vikash

Mekong River10-Jul-04 6:34

10-Jul-04 6:34

Hi, I have question to ask all of you. Do you have any method to know all of an e-mail address of each person around the world?

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

Colin Angus Mackay - Guarding his email address10-Jul-04 6:58

Colin Angus Mackay - Guarding his email address

10-Jul-04 6:58

Is this a serious question? Why do you want this information anyway?

The only reason I could think that anyone would want this information is to spam lots of people (well, everybody by the looks of it). SPAM is one of the major irritations of the internet and its perpetuation should be strongly discouraged at every level.

To answer your question: No, you cannot know the "e-mail address of each person around the world". Many people go to great lengths to guard their address and maintain their privacy. You should respect that.

Mekong River10-Jul-04 23:32

10-Jul-04 23:32

The reason that I want to know about e-mail address because most of my friend when finish the university are go to work in a difference places without let me know even their telephone number. We ask the university many time but it seem no result. I just want to know if their is a software or webpage when I type my friend name, it will display an e-mail address to contact them (if they register the name ex: hotmail, yahoo).

I know that personal privacy must be respect, but I don't want to know the other personal privacy even my friend. I just want to know the way to contact them.

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

Colin Angus Mackay - Not quite convinced14-Jul-04 20:39

Colin Angus Mackay - Not quite convinced

14-Jul-04 20:39

Unless they have registered somewhere then no. Also, if they have not given you their contact details I would question their level of commitment as friends.

Google for your friend's name, they may have posted their email address somewhere, or have some other way of contacting them. Websites like friends reunited (not available yet in Norway or Cambodia) allow people to post details of where they went to school and for a nominal fee you can contact each other through the site.

Mekong River17-Jul-04 4:14

17-Jul-04 4:14

Thank you very much, I have some idea about it. I use google to search but there is no result. All of us are best freind, I need to wait from the university if there are any result.

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

alex.barylski10-Jul-04 17:24

alex.barylski

10-Jul-04 17:24

Not unless your Professor Xavier and you know how to work that cerybro mind reading machine

How do I print my voice mail?