inserting a record?

Results 1 to 3 of 3

Thread: inserting a record?

  1. #1
    Join Date
    Dec 1969

    Default inserting a record?

    friends,<BR>help me about how to insert a record into table through ASP.<BR>thanky.

  2. #2
    Join Date
    Dec 1969

    Default RE: inserting a record?

    there&#039;s a beginners tutorial in the ASP section of<BR><BR>j

  3. #3
    NPKumar Guest

    Default RE: inserting a record?

    &#060;%<BR>dim oForm<BR>set oForm=Request.Form() <BR>dim Conn,Rs<BR>set Conn=server.CreateObject("ADODB.Connection") <BR>Conn.Open Connection_String<BR>set Rs=server.CreateObject("ADODB.Recordset") <BR>Rs.Open "Tablename",Conn,2,3<BR>Rs.AddNew <BR><BR>Rs("Heading")=oForm("txt_Heading")<BR>Rs(" SubHeading")=oForm("txt_SubHeading")<BR>Rs("Text") =oForm("txt_Text")<BR><BR>Rs("Source")=oForm("txt_ Source")<BR>if oForm("txt_Date")&#060;&#062;"" then<BR>Rs("Date")=oForm("txt_Date")<BR>end if<BR>if oForm("txt_SourceDate")&#060;&#062;"" then<BR>Rs("SourceDate")=oForm("txt_SourceDate")<B R>end if<BR>Rs.update<BR>Rs.close<BR>set Rs=nothing<BR>Conn.close<BR>set Conn=nothing<BR>%&#062;<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts