Delete Query??? Please Help

Results 1 to 4 of 4

Thread: Delete Query??? Please Help

  1. #1
    Vince Carter Guest

    Default Delete Query??? Please Help

    delsql="Delete * FROM Materialsubscription WHERE Materialsubscription.Loginid=&#039;& strloginname &&#039; AND Materialsubscription.Password=&#039;& strloginpasswd &&#039;;"<BR><BR><BR>objConnection.Execute(delsql) <BR><BR>Can some one tell me why my delete query is not working?? i have 5 insert queries right after that, all that works. <BR><BR>FYI This delete query will have more than 1 match<BR>

  2. #2
    New ASP Guest

    Default try this pls

    delsql="Delete FROM Materialsubscription WHERE Materialsubscription.Loginid=&#039;" & strloginname & "&#039; AND Materialsubscription.Password=&#039;" & strloginpasswd & "&#039;"<BR>

  3. #3
    Vince Carter Guest

    Default RE: try this pls

    It Worked Thanks

  4. #4
    New ASP Guest

    Default Any time.<eof>


Posting Permissions

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