• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • Last Modified:

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

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
BrianJHill
Asked:
BrianJHill
1 Solution
 
fritz_the_blankCommented:
I just tried it , and it seemed to work without error...

Fritz the Blank
0
 
fritz_the_blankCommented:
I also added a field with apostrophes and quotation marks, still seems fine.

Fritz the Blank
0
 
BrianJHillAuthor Commented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Ryan ChongCommented:
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
 
Jimby_AusCommented:
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
 
fritz_the_blankCommented:
Well, if s/he feels that no one here was of help whatsoever....

FtB
0
 
YensidModCommented:
Asker found his own answer.  Question is PAQed and 135 points refunded.

YensidMod
Experts Exchange Moderator
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now