?
Solved

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

Posted on 2003-12-07
8
Medium Priority
?
575 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 53

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

801 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