hi everybody and i am new to this workgroup..
i have a doubt regarding the insertion into the Access database..
i am even new to ASP and hence ..
i have done my html front end and need to insert the info into my Access database..
i have date of birth field which i have designed in Select option that is in a pull down menu to select.
so how to collect the data using Request.Form command and place it into my Access .
and how should i design my database for this field that is is that i have to create a separate field for day , month, year or a single field DOB with date/time datatype .

   plz help me and need a response quicker as i have to construct this module within a week time..



MuthuKumar.AL

__________________
MuthuKumar.AL

Following code shows how to insert record in the Access database after getting in the form:

<%
' Declaring variables
Dim cname, email, add, data_source, con, sql_insert

' Receiving values from Form
cname = ChkString(Request.Form("comname"))
email = ChkString(Request.Form("email"))
add = ChkString(Request.Form("address"))
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("sample.mdb")
sql_insert = "INSERT INTO enquiry (cname, address, email) values ('" & _
cname & "', '" & add & "', '" & email & "')"
' 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
%>

You can use drop down or single field. If you are using text box then you have to validate the date entered.

Om Prakash

Hi MuthuAl,

I feel it will be best if you create a single field with a date/time datatype for date of birth.

cheers and all the best.

don baroo

thx for the code i will try with that and if problem persists i will post it and an another one that is i have three seperate fields in my front end for date of birth and is that enough to create one field for date of birth in the database Access with type date/time and if yes how to insert those values into the database with just one field for date of birth

MuthuKumar.AL

sir i executed the code you posted to me and i have an error which i tried but in vain so i put forward the error and if you aware of this error please give me the solution
   "Conn.Execute sql_insert" ----> This is the place where it had shown me a error.

MuthuKumar.AL

What is the error you are getting?

Om Prakash

MuthuKumar.AL

Comment the connection.execute method and do a response.write sql_insert before execute() method and post what comes along with the sql_insert string. Post the same here. Lets have a look at it.

Cheers!

_________________________
- Vijay G
Strive for Perfection

here i have written my code which i am having an error saying syntax error in INSERT INTO statement....

"The CoDe"

 isql ="insert into User(User_Name,MonthOfBirth,DayOfBith,YearOfBirth, Address,City,State,Pincode,************,Exp\Fre\Finalyr,Yr Of Exp,Walk-In,Telephone,eMail,Details/ClarificationsAskedFor,Person Contacted,IsDoubtsClarified) values('" & sname & "','" & mont & "','" & daay &"','" & yeear & "','" & addrr & "','" & citty & "','" & statt & "', '" & pinc & "', '" & ssex & "', '" & exxp & "', '" & yofexp & "','" & walk & "','" & tele & "','" & eemail & "','" & clarif & "','" & personn & "','" & doubt & "')"

'Connection Opening
  Set Conn = Server.CreateObject("ADODB.Connection")
  Conn.ConnectionString = "Provider =Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Enquiry.mdb") & ";"
  Conn.Open
'Opening A RecordSet
  Set Rs=server.CreateObject("ADODB.Recordset")
  Set Rs=Conn.Execute(isql)

plz i need Answers...
i am really fed up with this plz someone clear my doubts...
bye for now


MuthuKumar.AL

In the statement "Insert into user.."
Dont use "User" as the table name. This is the keyword. Please rename it. I think it will erase this error.

Thanks
Suresh