Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    23

    Unanswered: delete file not working

    It worked fine with access db's but now it's giving me this error...

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM releases WHERE title = 'Cabela's Big Game Hunter 2005 Ad

    /releaseerase.asp, line 16

    Code:
    <%
    Option Explicit
    Dim username,sql,rsdelete, game, console
    
    game = request.querystring("game")
    console = request.querystring("console")
    
    username = Request.Cookies("username")
    
    if username = "" then
      Response.Redirect("default.asp")
    end if
    %>
    <!--#include file="conn.asp"-->
    <%
    conn.Execute("DELETE * FROM releases WHERE title = '" & Request.querystring("game") & "'")
    response.redirect("releases.asp?console="& console &"")
    
    conn.close
    set conn = nothing
    %>
    Line 16 is....

    Code:
    conn.Execute("DELETE * FROM releases WHERE title = '" & Request.querystring("game") & "'")

  2. #2
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95
    [Code]
    <%
    Option Explicit
    Dim username,sql,rsdelete, game, console

    game = replace(request.querystring("game"), "'","''")
    console = request.querystring("console")

    username = Request.Cookies("username")

    if username = "" then
    Response.Redirect("default.asp")
    end if
    %>
    <!--#include file="conn.asp"-->
    <%
    conn.Execute("DELETE FROM releases WHERE title = '" & game & "'")
    response.redirect("releases.asp?console="& console &"")

    conn.close
    set conn = nothing
    %>
    Sorry to be terse
    some say it's a curse
    I know it's worse
    I'm just diverse

  3. #3
    Join Date
    Jan 2005
    Posts
    23
    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''gcnreleases' WHERE title = 'NBA Street V3'' at line 1

    /releaseerase.asp, line 16

Posting Permissions

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