Web Development

Is it impossible to specify height of tables with 100%?

14-Dec-03 10:13

I struck a dead end. I am looking for an elegant replacement for the ASP.NET DateTime.Now.ToString("r")); method. It returns an RSS date in the right format required by the RSS 2.0 specification.

The format is as follows: Thu, 11 Dec 2003 05:00:00 GMT
Does any one know of such a function in ASP/VBScript?

If all fails, I would need to strip the date with DatePart ...
Thanks in advance.

kimamundsen13-Dec-03 15:59

kimamundsen

13-Dec-03 15:59

Is it impossible to specify a table that spans the whole screen? Seems to me that the only browser that really accepts tables specified with height in a percentage is Internet Explorer.. it appears different in Netscape and Opera........

Am i correct?

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

Major: Artificial Intelligence

Re: Is it impossible to specify height of tables with 100%?

ZoogieZork13-Dec-03 20:14

ZoogieZork

13-Dec-03 20:14

You may be running into the problem that in more standards-compliant browsers, the height of the <body> element may not be the height of the viewable page area. Try adding html,body { height: 100% } to your stylesheet.

- Mike

Reaching another WebForm in an another Frame?

kimamundsen13-Dec-03 9:17

kimamundsen

13-Dec-03 9:17

Is there possible for me to reach the Page-object of an another webform that exists in an another frame?

And how do I refresh a page in an another frame by using Response.Redirect(..)?

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

Major: Artificial Intelligence

Re: Reaching another WebForm in an another Frame?

Colin Angus Mackay13-Dec-03 9:43

Colin Angus Mackay

13-Dec-03 9:43

kimamundsen wrote:
Is there possible for me to reach the Page-object of an another webform that exists in an another frame?

With great difficulty. You'd have to be rendering both pages at the same time. In ASP.NET what happens is that a request arrives at the server and the appropriate page is instantiated, your code does all it needs to and the page is transmitted to the client and destroyed. The server has no knowledge of any pages other than the ones that it is currently processing. From a user's point of view he/she may be working on the same page but to the server they are all just requests to generate new pages - It doesn't see them as the same page.

kimamundsen wrote:
And how do I refresh a page in an another frame by using Response.Redirect(..)?

You'd be better looking for a javaScript solution to that.

Sorry that I have not been much help.

--Colin Mackay--

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

Enumerators in .NET: See how to customise foreach loops with C#

Disable view source

Not Active12-Dec-03 9:19

Not Active

12-Dec-03 9:19

I know how to prevent the context menu from showing up but is there a way to just prevent a view source. From the context menu and the view menu?

Re: Disable view source

Paul Watson13-Dec-03 4:06

Paul Watson

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.

Dynamically Updating/Filtering List Box's

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

Paul Watson

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

Paul Watson

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