Solved

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

Posted on 2003-12-07
8
566 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
8 Comments
 
LVL 46

Expert Comment

by:fritz_the_blank
Comment Utility
I just tried it , and it seemed to work without error...

Fritz the Blank
0
 
LVL 46

Expert Comment

by:fritz_the_blank
Comment Utility
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
Comment Utility
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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 49

Expert Comment

by:Ryan Chong
Comment Utility
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
Comment Utility
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
Comment Utility
Well, if s/he feels that no one here was of help whatsoever....

FtB
0
 

Expert Comment

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

YensidMod
Experts Exchange Moderator
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now