adding to a database

gmoney060 · April 8th, 2004, 09:17 PM

Hello, I am starting to learn ASP and I ran into a problem that is completley stumping me. I can not figure out what is wrong! I keep on getting a "500 Internal server error"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
</head>
<body>
<%
   ' Declaring variables
   Dim Date, News, sql_insert

   ' Receiving values from Form
   Date = (Request.Form("Date"))
   News = (Request.Form("News"))

   data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
            Server.MapPath("update_news.mdb")
   sql_insert = "insert into News (Date, News) values ('" & _Date & "', '" & News & "')"

   ' Creating Connection Object and opening the database
   Set con = Server.CreateObject("ADODB.Connection")
   con.Open data_source
   con.Execute sql_insert
   ' Done. Close the connection
   con.Close
   Set con = Nothing
   Response.Write "All records were successfully entered into the database."
%>
</body>
</html>

if you could please email me at scoremaster25@msn.com or respond to this post with anything that could be wrong with this.

happygv · April 8th, 2004, 09:24 PM

500 Internal error, is shown because, you need to make some changes in your browser settings, I am not sure about what to be changed, so I cannot help you on that.

AFAICS, In your insert statement, you should embed the DATE value with #, as in access db, date values should be passed in the format of #DATEVALUE#. Please check Access help for passing date values during insert.

Cheers!

-Vijay G

stacy · April 8th, 2004, 09:52 PM

Go to Internet Options...Click the advanced tab...and UNcheck the "Show friendly HTTP error messages"...

This will allow you to get rid of the "500 Internal server error" message and you'll be able to see where the actual problem is!

gmoney060 · April 8th, 2004, 10:10 PM

Thanks for the help!
This is the acutal ASP error:

Microsoft VBScript compilation error '800a0408'

Invalid character

/add_news.asp, line 17

sql_insert = "insert into News (Date, News) values ('" & _Date & "', '" & News & "')"

stacy · April 8th, 2004, 10:17 PM

I am just starting out too....and I've had SO many problems! I wish I could help you out with this problem. This website has helped me out with some of my errors...

http://www.adopenstatic.com/faq/

Imar · April 9th, 2004, 02:21 AM

Hi there,

Were you trying to split your code over two lines using the _, or are you trying to use a variable called _Date?
Since Date can be a reserved word, I suggest the following fix:

Code:

' Receiving values from Form
MyDate = (Request.Form("Date"))
MyNews = (Request.Form("News"))

...
sql_insert = "insert into News (Date, News) values ('" & _
   MyDate & "', '" & MyNews & "')"

HtH,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Schism by Tool (Track 5 from the album: Lateralus)