Web Development

Replacing image with browser refresh

24-Jan-03 8:24

can anyone speed me up here so I can avoid spending too much time digging up too much?

QUESTION 1:
I know in ASP.NET you can load data from SQL server into a DataSet, then have the dataset to format the data in XML. You can pre-load a static xsd file from disk to validate your XML doc.

Here's a code snippet from learnxmlws.com:

Dim schemaCache As MSXML2.XMLSchemaCache40
Set schemaCache = New MSXML2.XMLSchemaCache40
schemaCache.Add "", "C:\myschema.xsd"

Dim doc As MSXML2.DOMDocument40
Set doc = New MSXML2.DOMDocument40
set doc.schemas = schemaCache

Question is, how can you then load a static xsl schema from disk and load the XML to screen? Can you quote the APIs and some URL which I can read up on?

QUESTION 2:
some pages are already written in ASP, can I have a form written in ASP that POST/GET parameters to an aspx page? Vice Versa? From aspx to asp? I'm rather new to ASP.NET and have only tried out a few things.

QUESTION 3:
How can you do what I mentioned in QUESTION 1 but in VBScript/classical ASP?

Thanks a bunch.

norm

aprilneedshelp24-Jan-03 6:39

aprilneedshelp

24-Jan-03 6:39

I used to have a small code snippet (I believe it was javascript) that allowed me to have a page pull up a different image each time the page was loaded. The images were kept in a specified folder and each time the page was refreshed or revisited a different photo would show up. I have searched for days and can't find anything anywhere!! OMG | :OMG:

Does anyone have this code or something similar?

I am looking because I have a small client who has photos of office staff and drivers from 3 offices that all need to be displayed but they are not worthy of their own page.

Help!

Re: Replacing image with browser refresh

DFU₂₃28-Jan-03 4:34

DFU₂₃

28-Jan-03 4:34

If the list if images is not going to change (or at least not going to change much) then this should be easy to accomplish with some simple JavaScript.

I am making an assumption that you are familiar with JavaScript and will be able to run on your own with the following code snippets. If not, then let me know.

var arrOfPics = new Array(10);    // Create an array
arrOfPics[0] = "images/Joe.jpg";  // and populate it ...
arrOfPics[1] = "images/Sue.jpg";
arrOfPics[2] = "images/John.jpg";
arrOfPics[3] = "images/Peter.jpg";
arrOfPics[4] = "images/Paul.jpg";
arrOfPics[5] = "images/Mary.jpg";
arrOfPics[6] = "images/Eddy.jpg";
arrOfPics[7] = "images/Jason.jpg";
arrOfPics[8] = "images/Wanda.jpg";
arrOfPics[9] = "images/Albert.jpg";

Once you have created an array of the location to the pictures you possibly want to display all you need to do is randomly choose one and write the HTML to display the image. The easiest way that I can think do that is to do something like the following:

<script>
document.write("<img src=" + arrOfPics[Math.floor(Math.random()*10)] + ">");
</script>

That should do it ... of course you could create a Server-Side script (if that is an option) that could do basically the same thing, but you mentioned JavaScript and that makes plenty of sense for something like this.

Every time this page is loaded a new random image will be selected from the array to be displayed.

Java Menu's and Postbacks

tirbine23-Jan-03 17:17

tirbine

23-Jan-03 17:17

I need help. I have javascript menu's running on my site and they work fine up until I do a postbacka nd then the javascript doesn't run. I know that MS put out a patch for this but sometimes it works and sometimes it doesn't. Is there a way to make suree that on every postback to the page that the javascript will load? I know that if I hit refresh that the menu's will reload while maintaining the state of the page but I can't excatly tell the user to refresh the page if the menu's don't work. Or does someone know where I can get a menu system (referrably top down) that will not be effected by postbacks?
To view the pages go to http://www.tirbine.com/tirbinewebsite
Mad | :mad:

Thanks

Matthew

Can JavaScript include file have relative URL

Kevin McFarlane23-Jan-03 1:24

Kevin McFarlane

23-Jan-03 1:24

Hello,

I would like to write:

Whenever I do this I end up with something like "Error: Object Expected" later on in my HTML file. the same happens if I use an absolute URL.

However, when I put my include file in the same folder and write:

<script src="testinclude.js" language="javascript">

there is no problem.

Can include files only be in the same folder as the pages that reference them, or have I got the wrong syntax?

Kevin

Re: Can JavaScript include file have relative URL

DFU₂₃28-Jan-03 4:50

DFU₂₃

28-Jan-03 4:50

Ah, the joy of debugging JavaScript. First, are you sure that the error you are getting is due to the JS file not being included into you page? (i.e. the object that you are trying to create is within the JS file)

If your answer is yes to the above question then we need to look at how the file is being referenced. My first instinct is that for some reason it did not like traversing up a level in the file structure with the use of the ".." however, after testing it locally here on my machine that should not be the case.

The file that you are trying to include should be accessible as long as it is accessible to the web (for example, can you open or download the JS file from your web browser?).

If you could, please give a scenario of your file structure to help solve this issue. And, if possible, a URL (if publicly accessible).

Re: Can JavaScript include file have relative URL

Kevin McFarlane28-Jan-03 5:16

Kevin McFarlane

28-Jan-03 5:16

I've now solved the problem. I had placed my file in a directory called "scripts" and ASP (or IIS) didn't like that!

Kevin

Re: Can JavaScript include file have relative URL

DFU₂₃28-Jan-03 5:18

DFU₂₃

28-Jan-03 5:18

Congratz on solving the issue ... I wouldn't have thought of that one.

rename html file to asp file - problem

devvvy22-Jan-03 23:22

Re: rename html file to asp file - problem

22-Jan-03 23:22

Hi, i have this html file (it's bug free) which i subsequently renamed to an asp file. NO change to the content - just renaming the file extension from html to asp. But IIS failed to display the asp file. The clue it offers is too general - "HTTP Internal Server Error 500"

I am pretty clueless since the html file loaded WITHOUT a problem.

Anyway, here's the code, I hope someone can point me to the right direction:

<SCRIPT TYPE="text/javascript">

var rollOverArr=new Array();
function setrollover(OverImgSrc,pageImageName)
{
if (! document.images)return;
if (pageImageName == null)
pageImageName = document.images[document.images.length-1].name;
rollOverArr[pageImageName]=new Object;
rollOverArr[pageImageName].overImg = new Image;
rollOverArr[pageImageName].overImg.src=OverImgSrc;
}

function rollover(pageImageName)
{
if (! document.images)return;
if (! rollOverArr[pageImageName])return;
if (! rollOverArr[pageImageName].outImg)
{
rollOverArr[pageImageName].outImg = new Image;
rollOverArr[pageImageName].outImg.src = document.images[pageImageName].src;
}
document.images[pageImageName].src=rollOverArr[pageImageName].overImg.src;
}

function rollout(pageImageName)
{
if (! document.images)return;
if (! rollOverArr[pageImageName])return;
document.images[pageImageName].src=rollOverArr[pageImageName].outImg.src;
}
//-->
</SCRIPT>

<SCRIPT TYPE="text/javascript">

</SCRIPT>

<html>

<head>
<TITLE>Message Board</TITLE>
</head>

<body bgcolor="rgb(255,255,255)">

<p align="left">
<b>
<font size=5 face=AerialNarrow color="DodgerBlue">
   <!-- " "=no breaking space>
Some Message Board
</font>
</b>
</p>

<table cellpadding=10 cellspacing=10>

<tr>
<!-- Menu here ------------------------------------------------------------- >
<td align="left">

<!-- Message Board Sub Menu >
<table>
<col>
<col align=left>
<col style="color:blue">
<col width=200>

<!-- Administrators' Message Board>
<tr>
<td>
<a href="http://www.msn.com" OnMouseOver="rollover('admin_pics')" OnMouseOut="rollout('admin_pics')">
<img
src="Admin_mouse_out.bmp"
name="admin_pics"
alt="Administrators' Message Board" border=0
height=32 width=207
</a>

</td>
</tr>

<!-- Employee Message Board>
<tr>
<td>
<a href="http://www.msn.com" OnMouseOver="rollover('employee_pics')" OnMouseOut="rollout('employee_pics')">
<img
src="employee_mouse_out.bmp"
name="employee_pics"
alt="Employees' Message Board" border=0
height=32 width=207
</a>
</td>
</tr>

<!-- Registered Users' Message Board>
<tr>
<td>
<a href="http://www.msn.com" OnMouseOver="rollover('reg_user_pics')" OnMouseOut="rollout('reg_user_pics')">
<img
src="reg_user_mouse_out.bmp"
name="reg_user_pics"
alt="Registered Users' Message Board." border=0
height=32 width=207
</a>
</td>
</tr>
</table>

<br>
<br>

<!-- Login and registration sub menu >
<table>
<!-- Login: login.asp>
<tr>
<td>
<a href="http://www.msn.com" OnMouseOver="rollover('login_pics')" OnMouseOut="rollout('login_pics')">
<img
src="login_mouse_out.bmp"
name="login_pics"
alt="Login." border=0
height=32 width=207
</a>
</td>
</tr>

<!-- New user registrations: register.asp>
<tr>
<td>
<a href="http://www.msn.com" OnMouseOver="rollover('register_pics')" OnMouseOut="rollout('register_pics')">
<img
src="register_mouse_out.bmp"
name="register_pics"
alt="New user registerations." border=0
height=32 width=207
</a>
</td>
</tr>

</table>

<br>
<br>

<!-- Message board function sub menu >
<table>

<!-- Search Message Boards>
<tr>
<td>
<a href="http://www.msn.com" OnMouseOver="rollover('search_boards_pics')" OnMouseOut="rollout('search_boards_pics')">
<img
src="search_boards_mouse_out.bmp"
name="search_boards_pics"
alt="Search Message Boards." border=0
height=32 width=207
</a>
</td>
</tr>

<!-- Enter new thread to message board: new_thread.asp>
<tr>
<td>
<a href="http://www.msn.com" OnMouseOver="rollover('new_thread_pics')" OnMouseOut="rollout('new_thread_pics')">
<img
src="new_thread_mouse_out.bmp"
name="new_thread_pics"
alt="Enter new thread to message board." border=0
height=32 width=207
</a>
</td>
</tr>

</table>

<br>
<br>

<!-- HOME>
<table>
<tr>
<td>
<a href="http://www.msn.com" OnMouseOver="rollover('home_pics')" OnMouseOut="rollout('home_pics')">
<img
src="home_mouse_out.bmp"
name="home_pics"
alt="Home." border=0
height=32 width=207
</a>
</td>
</tr>
</table>

</td>

<!--Message board here ------------------------------------------------------------- >
<td valign=top>

<table border=0 cellpadding=5 cellspacing=2 bgcolor=LightSteelBlue align=right>
<!-- #F0F8FF=Alice Blue (Highlighted row); #E0E0E0=a darker Grey; #F0F0F0=A lighter grey>

<tr bgcolor="AliceBlue" align=left>
<th width=75>Thread ID</th>
<th width=150>Thread Title</th>
<th width=75>Thread Posted</th>
<th width=75>User</th>

</tr>

<tr bgcolor='#F0F0F0' onMouseOver="this.bgColor='#FF4500';" onMouseOut="this.bgColor='#F0F0F0';" OnMouseDown="window.location='http://www.msn.com';">
<td>1</td>
<td>Thread 1</td>
<td>#12-22-2002#</td>
<td>Norman</td>
</tr>

<tr bgcolor='#E0E0E0' onMouseOver="this.bgColor='#FF4500';" onMouseOut="this.bgColor='#E0E0E0';" OnMouseDown="window.location='http://www.msn.com';">
<td>2</td>
<td>Thread 2: This is a very lonnnnggggg thread........ Can you see that?..... O I dont believe it!</td>
<td>#12-24-2002#</td>
<td>Jerry</td>
</tr>

<tr bgcolor='#F0F0F0' onMouseOver="this.bgColor='#FF4500';" onMouseOut="this.bgColor='#F0F0F0';" OnMouseDown="window.location='http://www.msn.com';">
<td>3</td>
<td>Thread 3</td>
<td>#1-12-2003#</td>
<td>Roman</td>
</tr>

<tr bgcolor='#E0E0E0' onMouseOver="this.bgColor='#FF4500';" onMouseOut="this.bgColor='#E0E0E0';" OnMouseDown="window.location='http://www.msn.com';">
<td>4</td>
<td>Thread 4</td>
<td>#1-14-2003#</td>
<td>Zdenka</td>
</tr>

<tr bgcolor='#F0F0F0' onMouseOver="this.bgColor='#FF4500';" onMouseOut="this.bgColor='#F0F0F0';" OnMouseDown="window.location='http://www.msn.com';">
<td>5</td>
<td>Thread 5</td>
<td>#1-16-2003#</td>
<td>Grace</td>
</tr>

</table>
</td>

<!--Banner here ------------------------------------------------------------- >
<td valign = top>
<img src="Norman.jpg">
</td>
</tr>
</table>

</body>

</html>

norm

Paul Riley23-Jan-03 0:16

Re: rename html file to asp file - problem

23-Jan-03 0:16

First thing to do: In IE, go to Tools->Internet Options, click the Advanced tab and uncheck "Show friendly HTTP error messages".

Try it again and you should get an error message that gives you a better clue.

Friendly error messages are not friendly to developers.

Paul
Pleasently caving in, I come undone - Queens of the Stone Age, No One Knows

Jonavis25-Jan-03 13:03

Jonavis

25-Jan-03 13:03

Hey Norm,

The errors were pretty much unclosed tags.

All the comments were open, ( like this ), placed the Javascript code between the <HEAD> tags and closed the <IMG SRC> tags that were not closed correctlly (<img src="x" width=x hieght=x)

Dont forget to check out my resume at:

http://www.radiostatic.net/jon/index.html

So here it is.

<html>

<head>
<TITLE>Message Board</TITLE>
<script TYPE="text/javascript">

var rollOverArr=new Array();
function setrollover(OverImgSrc,pageImageName)
{
if (! document.images)return;
if (pageImageName == null)
pageImageName = document.images[document.images.length-1].name;
rollOverArr[pageImageName]=new Object;
rollOverArr[pageImageName].overImg = new Image;
rollOverArr[pageImageName].overImg.src=OverImgSrc;
}

function rollover(pageImageName)
{
if (! document.images)return;
if (! rollOverArr[pageImageName])return;
if (! rollOverArr[pageImageName].outImg)
{
rollOverArr[pageImageName].outImg = new Image;
rollOverArr[pageImageName].outImg.src = document.images[pageImageName].src;
}
document.images[pageImageName].src=rollOverArr[pageImageName].overImg.src;
}

function rollout(pageImageName)
{
if (! document.images)return;
if (! rollOverArr[pageImageName])return;
document.images[pageImageName].src=rollOverArr[pageImageName].outImg.src;
}
//-->
</script>

<script TYPE="text/javascript">

</script>
</head>

<body bgcolor="rgb(255,255,255)">

<p align="left">
<b>
<font size=5 face=AerialNarrow color="DodgerBlue">

Some Message Board
</font>
</b>
</p>

<table cellpadding=10 cellspacing=10>

<tr>

<td align="left">


<table>
<col>
<col align=left>
<col style="color:blue">
<col width=200>


<tr>

<td height="21"> <a href="http://www.msn.com" onmouseover="rollover('admin_pics')" onmouseout="rollout('admin_pics')">
<img src="Admin_mouse_out.bmp" name="admin_pics" alt="Administrators' Message Board" border=0 height=32 width=207>
</a> </td>
</tr>


<tr>
<td>
<a href="http://www.msn.com" onmouseover="rollover('employee_pics')" onmouseout="rollout('employee_pics')">
<img src="employee_mouse_out.bmp" name="employee_pics" alt="Employees' Message Board" border=0 height=32 width=207>
</a>
</td>
</tr>


<tr>
<td>
<a href="http://www.msn.com" onmouseover="rollover('reg_user_pics')" onmouseout="rollout('reg_user_pics')">
<img
src="reg_user_mouse_out.bmp"
name="reg_user_pics"
alt="Registered Users' Message Board." border=0
height=32 width=207>
</a>
</td>
</tr>
</table>

<br>
<br>


<table>

<tr>
<td>
<a href="http://www.msn.com" onmouseover="rollover('login_pics')" onmouseout="rollout('login_pics')">
<img
src="login_mouse_out.bmp"
name="login_pics"
alt="Login." border=0
height=32 width=207>
</a>
</td>
</tr>


<tr>
<td>
<a href="http://www.msn.com" onmouseover="rollover('register_pics')" onmouseout="rollout('register_pics')">
<img
src="register_mouse_out.bmp"
name="register_pics"
alt="New user registerations." border=0
height=32 width=207>
</a>
</td>
</tr>

</table>

<br>
<br>


<table>


<tr>
<td>
<a href="http://www.msn.com" onmouseover="rollover('search_boards_pics')" onmouseout="rollout('search_boards_pics')">
<img
src="search_boards_mouse_out.bmp"
name="search_boards_pics"
alt="Search Message Boards." border=0
height=32 width=207>
</a>
</td>
</tr>


<tr>
<td>
<a href="http://www.msn.com" onmouseover="rollover('new_thread_pics')" onmouseout="rollout('new_thread_pics')">
<img
src="new_thread_mouse_out.bmp"
name="new_thread_pics"
alt="Enter new thread to message board." border=0
height=32 width=207>
</a>
</td>
</tr>

</table>

<br>
<br>


<table>
<tr>
<td>
<a href="http://www.msn.com" onmouseover="rollover('home_pics')" onmouseout="rollout('home_pics')">
<img
src="home_mouse_out.bmp"
name="home_pics"
alt="Home." border=0
height=32 width=207>
</a>
</td>
</tr>
</table>

</td>


<td valign=top>

<table border=0 cellpadding=5 cellspacing=2 bgcolor=LightSteelBlue align=right>


<tr bgcolor="AliceBlue" align=left>
<th width=75>Thread ID</th>
<th width=150>Thread Title</th>
<th width=75>Thread Posted</th>
<th width=75>User</th>

</tr>

<tr bgcolor='#F0F0F0' onmouseover="this.bgColor='#FF4500';" onmouseout="this.bgColor='#F0F0F0';" OnMouseDown="window.location='http://www.msn.com';">
<td>1</td>
<td>Thread 1</td>
<td>#12-22-2002#</td>
<td>Norman</td>
</tr>

<tr bgcolor='#E0E0E0' onmouseover="this.bgColor='#FF4500';" onmouseout="this.bgColor='#E0E0E0';" OnMouseDown="window.location='http://www.msn.com';">
<td>2</td>
<td>Thread 2: This is a very lonnnnggggg thread........ Can you see that?..... O I dont believe it!</td>
<td>#12-24-2002#</td>
<td>Jerry</td>
</tr>

<tr bgcolor='#F0F0F0' onmouseover="this.bgColor='#FF4500';" onmouseout="this.bgColor='#F0F0F0';" OnMouseDown="window.location='http://www.msn.com';">
<td>3</td>
<td>Thread 3</td>
<td>#1-12-2003#</td>
<td>Roman</td>
</tr>

<tr bgcolor='#E0E0E0' onmouseover="this.bgColor='#FF4500';" onmouseout="this.bgColor='#E0E0E0';" OnMouseDown="window.location='http://www.msn.com';">
<td>4</td>
<td>Thread 4</td>
<td>#1-14-2003#</td>
<td>Zdenka</td>
</tr>

<tr bgcolor='#F0F0F0' onmouseover="this.bgColor='#FF4500';" onmouseout="this.bgColor='#F0F0F0';" OnMouseDown="window.location='http://www.msn.com';">
<td>5</td>
<td>Thread 5</td>
<td>#1-16-2003#</td>
<td>Grace</td>
</tr>

</table>
</td>


<td valign = top>
<img src="Norman.jpg">
</td>
</tr>
</table>

</body>

</html>

hierachical data Vs relational data

devvvy22-Jan-03 23:17

22-Jan-03 23:17

hi, i'm just wondering if anyone has spent time on message boards that assumes a tree/hierachical structure - example: code project.

u can have a table of "threads". But each thread can have "child" threads and "child" threads can, in turn, have a whole bunch of child threads.

I know u can use a tree control (by the way, any suggestion?), but how can you store tree/hierachical data in a SQL server (relational database)? What's the best way to store hierachical data in this application?

Let me venture a guess... encode the structure in a char field. Say...

msgID="12-3-5"

parsing the msgID field:
(a) thread 12
(b) level one msg 3
(c) level two msg 5

Then, you'll need to build a parser. Parse, then load the data into the right place in a tree control... so clumsy... any suggestion?

Thanks!

norm

Paul Riley23-Jan-03 0:58

23-Jan-03 0:58

norm wrote:
Then, you'll need to build a parser. Parse, then load the data into the right place in a tree control... so clumsy... any suggestion?

Don't use a thread table. Have a message table which includes a "parent message" field and a datestamp. If the message is a root message then its parent is null / zero.

ie.
Message 1: Parent 0
...Message 2: Parent 1
......Message 5: Parent 2
...Message 4: Parent 1
Message 3: Parent 0
...Message 7: Parent 3
Message 6: Parent 0

Then you can use an iteration to get all the child messages in date/time sequence, starting with the root messages. The only complication is that the root messages need to be latest first and the lower levels need to be latest last.

Paul
Pleasently caving in, I come undone - Queens of the Stone Age, No One Knows

devvvy23-Jan-03 16:28

23-Jan-03 16:28

thanks for the feedback first of all. I read it last nite, and keep thinking about this thru the day.

I think what you proposed will work - theoretically. Here's what you proposed:

<msg>
<msgid>ASF24234SF34
<msgtitle>Message Title
<msgbody>Message Body
<parentid>ZKRM35AS4SF3

But... to reform the hierachical structure, you need to search for parent for all child message! This sounds like an exponential problem is this not? How do they do it in a real forum message board?

Hope to hear from you soon.

norm

Paul Riley23-Jan-03 22:19

23-Jan-03 22:19

norm wrote:
But... to reform the hierachical structure, you need to search for parent for all child message! This sounds like an exponential problem is this not?

Only if you don't put an index on the ParentID field. Indexed properly the entire thing should be almost as fast as getting all the messages for a thread and sequencing them manually, maybe slightly quicker.

Either way, in something like Access, you're going to start having problems at around 2000-3000 messages. In SQL Server/MSDE, it should go on fine for a long time.

norm wrote:
How do they do it in a real forum message board?

What is a "real" forum message board? I've had message boards work fine this way, using ASP. I'm sure you'll find that each message board works slightly differently from another.

Paul
Pleasently caving in, I come undone - Queens of the Stone Age, No One Knows

devvvy24-Jan-03 7:16

24-Jan-03 7:16

I have started implementing it. I think you are right. Loading the tree control with only a subset of the forum - msg belong to the same thread - should not be a problem at all.

By the way, I used SQL server NewID() function to add "uniqueidentifier" for MsgID column - Do you think it's a wise decision?

THanks.

norm

Paul Riley24-Jan-03 7:21