Solved

Keep getting "HTTP 500 Internal Server Error" on my insert record page. Why?

Posted on 2003-12-07
8
574 Views
Last Modified: 2010-08-05
As you can probably guess from the title, I'm trying to figure out why I keep getting an HTTP 500 Error whenever I try to insert a record into my Access 2000 database from my web page.

The database is writable as I can add / remove users, and modify other records. Basically I had a simple 2 field "Add News" page setup built in DreamWeaver MX. Title & Story were the fields. This worked fine. But I didn't feel like displaying a 3 paragraph news item on the home page, so I decided to add an "Introductory" field. This way only a small portion of the news is displayed, then the user clicks on then news item and it takes them to the "news.asp" page where the full story is displayed. I added the appropriate field to the table in the database and added an extra field in my form on the ASP page. I updated the "Insert Recordset" function to include the new field, and now my page gives me an HTTP 500 Error whenever I click the "Add News" button.

I'm including a link to a .txt with the code for the "add_news.asp" page. I have tried different database connection options as well.

Code: http://www.epic-graphics.com/instatel.ca/add_news.txt

To see the live example, go to: http://www.epic-graphics.com/instatel.ca/admin
Login: admin
Pass: admin

Thanks for any help!
Brian
0
Comment
Question by:BrianJHill
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 9893627
I just tried it , and it seemed to work without error...

Fritz the Blank
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 9893632
I also added a field with apostrophes and quotation marks, still seems fine.

Fritz the Blank
0
 

Accepted Solution

by:
BrianJHill earned 0 total points
ID: 9893728
yeah, I figured it out after I posted here on my own. I had some text field names on the page named with protected names like "title, date, etc..." and I also had a few of the table fields name similar, so all I did was rename the fields and it worked fine.

Thanks anyways.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 52

Expert Comment

by:Ryan Chong
ID: 9894175
try add in branket [] in your insert SQL statement as field names like date, name are reserved words.

like:

SQLstr = "insert into table1 ([name],[date]) values ('123', now()) "
0
 
LVL 1

Expert Comment

by:Jimby_Aus
ID: 9894648
This error description might be generated by Internet Explorer rather than the server.  If you go into Explorer Options and turn OFF "Show friendly HTTP error messages", you should be able to see the actual script error, to assist with debugging.

James.
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 9896242
Well, if s/he feels that no one here was of help whatsoever....

FtB
0
 

Expert Comment

by:YensidMod
ID: 9923270
Asker found his own answer.  Question is PAQed and 135 points refunded.

YensidMod
Experts Exchange Moderator
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question