Web Development

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

CDONTS Message Layout Problem

24-Jan-03 7:21

norm wrote:
I have started implementing it.

Cool!

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

Always. Big Grin | :-D

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

what is octet-stream?

murali_utr22-Jan-03 0:03

murali_utr

22-Jan-03 0:03

Mail having attachment type "octet-stream"? and encoding base64. how to decode this?

Thanks in advance
Murali

Kevin McFarlane21-Jan-03 23:46

Kevin McFarlane

21-Jan-03 23:46

Hi,

I am using CDONTS to allow customers to send web mail. How do you get the message body to recognise new lines when the user types "Enter."

For example, suppose the user writes the following:

Hello,

I'm interested in booking a villa for two weeks in April. Do you have any vacancies?

Regards,

Kevin McFarlane

When this is sent using CDONTS it is received looking like this:

Hello, I'm interested in booking a villa for two weeks in April. Do you have any vacancies? Regards, Kevin McFarlane

My code looks like this:

Set oMail = Server.CreateObject("CDONTS.NewMail")
.
.
.
oMail.Body = bodytext
oMail.MailFormat = CdoMailFormatMime
oMail.BodyFormat = CdoBodyFormatHTML
.
.

where bodytext =
"Hello, I'm interested in booking a villa for two weeks in April. Do you have any vacancies? Regards, Kevin McFarlane"

Kevin

Re: CDONTS Message Layout Problem

Jon Sagara22-Jan-03 4:42

Jon Sagara

22-Jan-03 4:42

I don't remember exactly how to do it, but I think it involves replacing Carriage Return\Newline pairs with "<br>" tags.

Try this before assigning the body text to the CDONTS object:

...
bodytext = Replace(bodytext, vbCrLf, vbCr)
bodytext = Replace(bodytext, vbLf, vbCr)
bodytext = Replace(bodytext, vbCr, "<br>")
...

I think this will only work for HTML emails. I haven't tested it.

Jon Sagara

Hi! I'm Melanoma, Moley Russell's wart.
-- Uncle Buck

Re: CDONTS Message Layout Problem

Kevin McFarlane22-Jan-03 8:08

Kevin McFarlane

22-Jan-03 8:08

Hi Jon,

I solved this problem after a bit of trial and error by removing this line:

oMail.MailFormat = CdoMailFormatMime

Kevin

Re: Need freelance ASP/JS/SQL developer for overflowing work!

Jonavis25-Jan-03 14:49

Jonavis

25-Jan-03 14:49

Hi.

I think I might be able to help...I mean, Im no DEVGURU, but between some Libraries I have, the internet and a couple of books I have around the house, Im sure I can help out.

heres my resume:
http://www.radiostatic.net/jon/index.html

I also work with Flash, Photoshop, Ilustrator, Swift 3d & Openwave SDK (wap)

Let me know if I can be of any help and what forms of payment you work with (Im ok with the per-job pay).

Talk soon,
Jon

GET TO KNOW ME

Re: Need freelance ASP/JS/SQL developer for overflowing work!

Nathan Ridley25-Jan-03 15:23

Nathan Ridley

25-Jan-03 15:23

Hello,

I tried to look at your resume site and the flash won't load. I have flash MX installed, and am using IE5.5. Is something wrong with the file perhaps?

Nathan

NATHAN RIDLEY
Web Application Developer
generalgherkin@yahoo.com

Another CDONTS question

vlusardi21-Jan-03 13:19

21-Jan-03 13:19

trying to send an email using CDONTS on entry to a page, by using the Window_Onload() Sub routine...

The page is initiated by another page with a form "submit" button... I get the following error when the page attempts to open:

Cannot run the FrontPage Server Extensions' Smart HTML interpreter on this non-HTML page: "http://stage/email_con.html"

Basically, all this page does is thank the user for contacting me and allows them to click a "close window" button, which does a window.close()

Here's the code for the sub:

<%
Sub Window_OnLoad()

Dim objMail

Set objMail = CreateObject("CDONTS.Newmail")

objMail.TO = "vlusardi@sdcera.org"

objmail.Subject = "HTML EMAIL!"

objMail.MailFormat = cdoMailFormatMime

objMail.BodyFormat = cdoBodyFormatHTML

objMail.Body = "this is a test"

objMail.send

set objMail = Nothing

alert("mail sent")

End Sub
%>

can someone tell me how to correct the error message?..... thanks very much...

Jon Sagara21-Jan-03 13:30

Jon Sagara

21-Jan-03 13:30

Is this code in email_con.html? Is your server configured to run ASP code from files with *.html extensions?

Jon Sagara

Hi! I'm Melanoma, Moley Russell's wart.
-- Uncle Buck

vlusardi21-Jan-03 13:33

21-Jan-03 13:33

jon,

thanks for the reply... not sure if it's configured for that or not, but it runs javascript just fine so I'm assuming it will run vbscript as well... is this an incorrect assumption...??? so to answer you question, yes, it's in the email_con.html file... thanks for any input

Jon Sagara21-Jan-03 13:41

Jon Sagara

21-Jan-03 13:41

Normally .html files are static with regards to server-side processing. You are right, JavaScript does execute in .html files, but it executes on the client side (unless you explicitly specify for it to run on the server). VBScript will run on the client side, but only in Internet Explorer. For ASP processing, you want the script to execute on the server side.

Try renaming the file to email_con.asp and run it again. This tells the Web server that your file potentially contains ASP code that it needs to execute.

This page[^] will give you an introduction to ASP programming. I haven't read any of the material, but it should clarify server-side vs. client-side if you have any further questions. Or ask me, and I'll try to answer them. Smile | :)

Jon Sagara

Hi! I'm Melanoma, Moley Russell's wart.
-- Uncle Buck

vlusardi21-Jan-03 13:47

21-Jan-03 13:47

jon,

thanks again for the reply... I renamed the file to a .asp extension and got the exact same error message... could there be a server configuration issue, or is there something I'm missing in my code....???

thanks again...

vlusardi21-Jan-03 13:52