BrianJHill
asked on
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
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
I also added a field with apostrophes and quotation marks, still seems fine.
Fritz the Blank
Fritz the Blank
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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()) "
like:
SQLstr = "insert into table1 ([name],[date]) values ('123', now()) "
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.
James.
Well, if s/he feels that no one here was of help whatsoever....
FtB
FtB
Asker found his own answer. Question is PAQed and 135 points refunded.
YensidMod
Experts Exchange Moderator
YensidMod
Experts Exchange Moderator
Fritz the Blank