updating info in access database

Results 1 to 2 of 2

Thread: updating info in access database

  1. #1
    Opal Guest

    Default updating info in access database

    I have the following code to update/modify e-mail address but for some reason it&#039s not writing to the database or printing out my sql when i do &#039response.write. Here is the code. What am I not doing or doing. I&#039m desperate.<BR><BR>&#060;%<BR>&#039**************** **************************<BR>&#039* Change EmailAddress<BR>&#039***************************** *************<BR>if ucase(request("action"))="SUBMIT" then<BR> if CheckEmailAddress(request("EmailAddress"))=True then<BR><BR> Set Conn = Server.CreateObject("ADODB.Connection")<BR> Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath ("/") & "opal_privatememberinfo.mdb"<BR> <BR> sql = "select * from memberinfo where EmailAddress= &#039" & request("EmailAddress") & "&#039"<BR> &#039response.write sql<BR> <BR> set rs=server.createobject("adodb.recordset")<BR><BR> rs("EmailAddress") = request("emailaddress")<BR> rs.Update<BR> msg="Your e-mail has been updated."<BR><BR> end if <BR> rs.close<BR> Set rs = Nothing <BR>Conn.close<BR><BR>End If <BR>%&#062;<BR>

  2. #2
    jimmy wang Guest

    Default RE: updating info in access database

    set rs=server.createobject("adodb.recordset")<BR>rs.op en ??????????????????? &#039&#039missing stuff here<BR><BR>jimm w<BR>megamicro.com

Posting Permissions

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