|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Database linking??
Hi,
I would be very grateful if anyone could help me in this regard as I need this to be done as soon as possible. I have created a form using HTML and Javascript. When I click on the submit button I need the Selected Answers to be sent to an Excel or MS-access or any database. I need to know whether this is possible using CGI/ASP. I guess ASP would be better. If not which one do you think is the best way to carry out. If anyone has any idea as to how can I go about in scripting this I would be very grateful. Hope to hear soon. Thank you |
|
#2
|
|||
|
|||
|
hello:
what are the fields you have in your html form? assumming that your using access: try this code to call the asp program to add data to access DB code : <% dim adoconn dim myquery dim author Set adoconn = Server.CreateObject("ADODB.Connection") adoconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("YOURACCESSDB.mdb") author = request.form("author") myquery = "INSERT INTO article FIELD_NAME VALUES ('" & author & "')" adoConn.execute myquery author = replace(trim("author"), "'", "''") Set adoconn = Nothing 'asp that shows the newly added data response.redirect "articles.asp" %> : kindly inform if it works. thanks |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Database linking?? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|