Web Development

Dynamically Updating/Filtering List Box's

13-Dec-03 4:06

No.

Even if you could, your page is stored on the client machine in the temporary internet folders. Even if you found a way to stop that, the user could simply save the file to their disk or leech it.

regards,
Paul Watson
Bluegrass
South Africa

Brian Welsch wrote:
"blah blah blah, maybe a potato?" while translating my Afrikaans.

Crikey! ain't life grand?

Einstein says...

Re: Disable view source

Not Active13-Dec-03 7:59

Not Active

13-Dec-03 7:59

Thanks Paul. As with anything there would always be a way around it. I was only looking for a way to prevent lesser beings from easly viewing the source.

DEWright_CA12-Dec-03 8:46

DEWright_CA

12-Dec-03 8:46

I am trying to create a 3 tiered set of look-up field. I have 3 tables that call to Client - Project and Work-Order Tables. Client is just my client name, project has client number and project number and project description, then Work-Order refers to the project-number ID and has a workorder description field.

I want to be able to select in listbox 1 my client, then have listbox 2 be filtered with only projects that have that clients ID, then the same with the third listbox it will return only workorders that contain the ID for the item selected in the second list box.

Here is my rough layout for my JScript/ASP Data backend.

Clnt_Sel lists Clnt_ID and Clnt_Desc
Proj_Sel lists Clnt_Lnk, Proj_ID and Proj_Desc
WO_Sel lists Proj_Lnk, WO_ID and WO_Desc

Your insights would be greatly appreciated!! Thanks Big Grin | :-D

David E.Wright
URS Corporation, Denver Downtown Operations

Re: Dynamically Updating/Filtering List Box's

Torsten Mauz14-Dec-03 23:41

Torsten Mauz

14-Dec-03 23:41

ok here's a quick demo of what I think you want to achieve. This example should be fairly easy to make database driven (just create the javascript arrays through the backend). If you need any more advice with this then just give me a shout.

note: I have not tested this in NS, but it should be pretty straighforward to update (don't have time right now to do a cross-browser version).

ps: sorry for the porky code Smile | :)

<body onload="init();">

<script language="Javascript">
function Client(clientID, clientName)
{
	this.id = clientID;
	this.name = clientName;
}

function Project(projectID, projectName, clientID)
{
	this.id = projectID;
	this.name = projectName;
	this.clientID = clientID;
}

function Work(workID, projectID, workDescription)
{
	this.id = workID;
	this.projectID = projectID;
	this.description = workDescription; 
}

var arrClients = new Array();
var arrProjects = new Array();
var arrWork = new Array();

arrClients[0] = new Client(1, 'Company abc');
arrClients[1] = new Client(2, 'XYZ Ltd.');

arrProjects[0] = new Project(1, 'Website', 1);
arrProjects[1] = new Project(2, 'Intranet', 1);
arrProjects[2] = new Project(3, 'Report viewer', 2);
arrProjects[3] = new Project(4, 'Spreadsheet generator', 2);

arrWork[0] = new Work(1, 1, 'Database Design & Implementation');
arrWork[1] = new Work(2, 1, 'HTML Templates draft');
arrWork[2] = new Work(3, 2, 'Implement NTFS security');
arrWork[3] = new Work(4, 3, 'Implement Crystal reports functionality');
arrWork[4] = new Work(5, 3, 'Create graphing module');
arrWork[5] = new Work(6, 4, 'Submit for final budget approval');

function init()
{
	frmLists.sClient.options.length = 0;
	
	for(var i = 0; i < arrClients.length; i++)
	{
		frmLists.sClient.options.length += 1;
		frmLists.sClient.options[i].value = arrClients[i].id;
		frmLists.sClient.options[i].text = arrClients[i].name;
	}
	
	updateProjects();
}


function updateProjects()
{
	var clientID;
	var idx = 0;
	
	clientID = arrClients[frmLists.sClient.selectedIndex].id;
	frmLists.sProject.options.length = 0;
	
	for(var i = 0; i < arrProjects.length; i++)
	{
		if(arrProjects[i].clientID == clientID)
		{
			frmLists.sProject.options.length += 1;
			frmLists.sProject.options[idx].value = arrProjects[i].id;
			frmLists.sProject.options[idx].text = arrProjects[i].name;
			if(idx == 0)
				frmLists.sProject.options[idx].selected = true;
			idx++;
		}
	}
	
	updateWork();
}

function updateWork()
{
	var projectID;
	var idx = 0;
	
	projectID = frmLists.sProject.options[frmLists.sProject.selectedIndex].value;
	
	frmLists.sWork.options.length = 0;
	
	for(var i = 0; i < arrWork.length; i++)
	{
		if(arrWork[i].projectID == projectID)
		{
			frmLists.sWork.options.length += 1;
			frmLists.sWork.options[idx].value = arrWork[i].id;
			frmLists.sWork.options[idx].text = arrWork[i].description;
			idx++;
		}
	}
}
</script>

<form name="frmLists" action="whatever.asp" method="post">
	<select name="sClient" onchange="updateProjects();">
	</select>
	
	<br/>
	
	<select name="sProject" onchange="updateWork();">
	</select>
	
	<br/>
	
	<select name="sWork">
	</select>
	
	<br/>
</form>

</body>

Performance of various web-delivery systems?

Jeremy Kimball12-Dec-03 7:27

Jeremy Kimball

12-Dec-03 7:27

Anyone out there know of any "fair" performance benchmarks comparing the like of ASP, ASP.NET, JSP, JServlets, etc? Trying to come up with some numbers for a presentation...

Thanks,

Jeremy Kimball

RSS

allia12-Dec-03 0:53

12-Dec-03 0:53

Does anybody know how to generate an RSS feed? As I understand it, the xml file generated is static. It is not a dynamic script. i.e., that it is generated once and then available for read by feeders. Is this true? Would I generate it each time a 'latest update' has occured? Does anyone have a sample script that generates RSS?

Paul Watson12-Dec-03 2:06

12-Dec-03 2:06

There is no rule that says the feed need be dynamic or static. Much like any other file available over the net it can be either. Depends on your requirements.

There are as many ways of making an RSS feed as there are ways to make a webpage.

Here are two methods; Create a valid RSS 2.0 document using XmlTextWriter and Google to RSS.

regards,
Paul Watson
Bluegrass
South Africa

Brian Welsch wrote:
"blah blah blah, maybe a potato?" while translating my Afrikaans.

Crikey! ain't life grand?

Einstein says...

allia12-Dec-03 3:30

12-Dec-03 3:30

Thanks,

If I was to make an RSS of the 'latest updates'. How would the dynamic rule work? When I first thought of it, it seemed like only when I press the RSS icon the file is generated - but that can't be true. It has to be generated before hand so that you can use feeders to read the data....

So when will be the right time to export the 'latest update' rss feed?

Thanks in advance.

Paul Watson12-Dec-03 3:44

12-Dec-03 3:44

You naturally don't want your RSS file being re-generated everytime someone hits it, rather you only want it re-generating on update to content on your website.

So I would put the RSS updater code in the same block as the code that saves/updates your website. That way the RSS is only updated when the site updates.

regards,
Paul Watson
Bluegrass
South Africa

Brian Welsch wrote:
"blah blah blah, maybe a potato?" while translating my Afrikaans.

Crikey! ain't life grand?

Einstein says...

allia12-Dec-03 8:03

12-Dec-03 8:03

Thanks, you have been lots of help. You have ensured my understanding.
Also, thank you for the link to the RSS article - I didn't notice it before.

I live to code.

allia13-Dec-03 8:10

Problem writing from global.asa to database

13-Dec-03 8:10

Something doesn't sit right...
I noticed the RSS on codeproject and on other sites as well. It seems that it is not a static file, but instead it is generated on demand. The file is of '.asp' or '.aspx' extension. I figured it should be '.xml'. Am I wrong?

What is the prefered method by RSS feeders?

Also,
Weird thing - I can't view the source of the RSS page on codeproject.

K3na11-Dec-03 22:23

K3na

11-Dec-03 22:23

I need to update a database table with the time the user logs out of my site/when their session ends.
I've been using a global.asa file with the following Session_OnEnd code, but it doesnt seem to be working for me........ can anybody help?

Sub Session_OnEnd
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=....."

query = "UPDATE User_LogTime SET Logout_Time = "now()" WHERE SID="&Session.SessionID&"

conn.Execute(query)
conn.Close
set conn = Nothing
End Sub

Roger Wright11-Dec-03 22:41

Roger Wright

11-Dec-03 22:41

I suspect that you need to create a command object to do this..

"Your village called -
They're missing their idiot."

K3na11-Dec-03 22:47

K3na

11-Dec-03 22:47

Thanks Roger but I'm new to this whole .asa thing. Could you explain what you mean ???

Thanks

Roger Wright12-Dec-03 5:03

Roger Wright

12-Dec-03 5:03

An ADO Command object returns a recordset when you call its Execute method. Since you're new at this (as I am) I suppose you could use some resources. One of my favorites is W3Schools.com[^], where you'll find free tutorials on just about anything web related.

Reviewing the code, it may not be the best answer to use a Command for this; your approach, while new to me, looks like it should work fine. You may have to reformat the result of Now() though. What database are you using?

"Your village called -
They're missing their idiot."

Running an .exe from my web page.

kimamundsen13-Dec-03 9:14

kimamundsen

13-Dec-03 9:14

Hi, I am pretty new to this too. But are actually doing the same as you do (maybe), but in C#. Sorry I don't get this to work either.

What I have explored, is that.. the sesion-variables seems to be cleared _before_ the end-session-event is ran...Anybody correct me is this is wrong.

What I did to solve the problem were making a object that I put into the session-variables and that writes info to the database when it terminates. This seems to work at me.

One last thing. It may take 20 minutes before the session ends, depending on the timeout configurations. Default is that 20 minutes. So session-end seems not to be executed right after quitting the browser..

= = = = = = = = = = = = =
Kim Amunsen
Norwegean University of Technology & Science

Major: Artificial Intelligence

Odd apache error

keegan11-Dec-03 19:09

keegan

11-Dec-03 19:09

Well, i wrote a parser for my logs in apache, and this error has occured over 3000 times in the past 2 weeks:

No directory () for Hostname www.thekeegster.com

does anyone know what this means? I've been googling, but i haven't found anything. Its clogging up my errorlog, its amazing how many occurences there are of it.

I'm runnin apache 1.3 on Linux

*.*
cin >> knowledge;

d00_ape11-Dec-03 6:17

d00_ape

11-Dec-03 6:17

Is there possible to make a compiled .exe to be executed when a user enter my webpage.
Of course it is possible, but what is the best way?
I know about ActiveX but don’t want to recode my dialogproject to such a component.
I’ve read a little about making CAB files but don’t know where to start.

APe

Re: Running an .exe from my web page.

Paul Watson11-Dec-03 21:22