save file

Results 1 to 2 of 2

Thread: save file

  1. #1
    Join Date
    Dec 1969

    Default save file

    I can&#039;t seem to figure out what&#039;s wrong with my file. In either case it save&#039;s on top of the current record. I have trie to add rs.addnew for one case as well and that does not work as well. Any ides???<BR><BR>If request.querystring("q")="add" then<BR> SQL="SELECT * FROM " &MyTableName&";"<BR>elseif request.querystring("q")="edit" then<BR> SQL="SELECT * FROM "&MyTableName&_<BR> " WHERE Year=&#039;"&session("year")&"&#039;"&_<BR> " AND club="&session("clubID")&";"<BR>end if<BR><BR>set rs = Server.CreateObject("ADODB.Recordset")<BR>rs.OPEN sql, conn, 3, 3<BR>&#039;response.write sql<BR>For each Item in Request.Form<BR> If Item &#060;&#062; "Submit" Then<BR> rs.fields(Item) = Request.Form(Item)<BR> End If<BR>Next<BR>rs.Update <BR>rs.close

  2. #2
    Join Date
    Dec 1969

    Default RE: save file

    Shot in the dark here but would rs.movenext help?

Posting Permissions

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