Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Rochester, NY
    Posts
    2

    Question Unanswered: ASP application - MySQL update problem

    Hello,
    I would like to use an asp application in MySQL that was origionally set up for access db. Connection is fine and pages work good with data already entered but i does not add data through the forms... i do not get any errors. i'm not very farmiliar with MySQL. do i need to add something to the db to get this to work? any help would be great...

    UserUpdate()

    Function UserUpdate()
    On Error Resume Next

    Set rsUser = Server.CreateObject("ADODB.Recordset")
    rsUser.open "users", conn, 3, 3
    rsUser.AddNew
    rsUser("username") = username
    rsUser("password") = password
    rsUser("firstname") = firstname
    rsUser("surname") = surname
    rsUser("email") = email
    rsUser("dob") = dob
    rsUser("starsign") = starsign
    rsUser("sex") = sex
    rsUser("icon") = icon
    rsUser("sendemail") = sendemail
    rsUser.Update

  2. #2
    Join Date
    Oct 2003
    Posts
    2
    Why dont you just import it into MSSQL... It would be much easier... and it would be faster, because ASP plays well w/ MSSQL

    But yea.. That is what you should do if you can.

  3. #3
    Join Date
    Oct 2003
    Location
    Rochester, NY
    Posts
    2
    ahh i scrapped that idea... the application is great but just too many issues with .asp and MySQL for me.

Posting Permissions

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