View Single Post
 
Old January 21st, 2005, 12:33 AM
Santhi Santhi is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Chennai, TamilNadu, India.
Posts: 326
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to Santhi Send a message via MSN to Santhi
Default

Picco you have to create database connection and execute the query.I think you are beginner in ASP.
Below is the code.
<%
adv_book_time = Trim(Request.Form(adv_book_time))
If adv_book_time <> ""
   Set oConn = Server.CreateObject("ADODB.Connection")
   oConn.ConnectionString = "DSN=UrDSNName;UID=sa"
   OConn.Open
   string strSql ="INSERT INTO company(adv_book_time) VALUES('" & adv_book_time & "');"
   oConn.Execute strSql
   oConn.Close
End If
%>