[SOLVED] ASP-MySQL Delete By Checkbox

Monie · #1 Nov 10th, 2007, 00:57

Hai,

I manage to do/use this code with Access Database but ended up with this error when I use MySQL Database.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC driver does not support the requested properties.
/my-pm-inbox.asp, line 24

This is my code to delete by checkbox:

Code: Select all

    Dim connectionString, pm, conn, rsCount
    connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=monieweb; OPTION=4; UID=root; PASSWORD=monie;"
    Set conn = Server.CreateObject("ADODB.Connection")
    Set pm = Server.CreateObject("ADODB.Recordset") 
    conn.Open(connectionString)
   
    Dim comment
    For Each comment In Request("delete")
         pm.Open "DELETE * FROM userpm WHERE pmNo = "& comment &"", conn,3,3
    Next 
        pm.Open "SELECT * FROM userpm WHERE username = '"& user &"' ORDER BY pmNo DESC", conn

Code: Select all

<input type="checkbox" name="delete" title="Select" value="<%=pm("pmNo")%>">

This method of deleting using check box works marvelously if I use Access Database. How to twist this code for MySQL Database? Any idea?

Monie · #2 Nov 10th, 2007, 01:51

I solved them myself, what a stupid error!

Code: Select all

    Dim connectionString, pm, conn, rsCount
    connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=monieweb; OPTION=4; UID=root; PASSWORD=monie;"
    Set conn = Server.CreateObject("ADODB.Connection")
    Set pm = Server.CreateObject("ADODB.Recordset") 
    conn.Open(connectionString)

    Dim comment
    For Each comment In Request("delete")
        pm.Open "DELETE FROM userpm WHERE pmNo = "& comment &"", conn,3,3
        'Set pm = conn.Execute ("DELETE FROM userpm WHERE pmNo = "& comment &"") Can be done like this too, I don't have idea what is the different??
     Next 
        pm.Open "SELECT * FROM userpm WHERE username = '" & Session ("name") & "' ORDER BY pmNo DESC", conn
        'Set pm = conn.Execute ("DELETE FROM userpm WHERE pmNo = "& comment &"") Can be done like this too, I don't have idea what is the different??

Error is in this line of SQL Statement:

Code: Select all

pm.Open "DELETE FROM userpm WHERE pmNo = "& comment &"", conn,3,3

throw away the '*' after the DELETE

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] help with checkbox and textfield in form	BRONIC	JavaScript Forum	8	Apr 22nd, 2008 16:08
delete by checkbox	FlashO	Classic ASP	3	Mar 30th, 2008 08:42
checkbox[] array into mysql... OUT?	ppgpilot	PHP Forum	1	Mar 13th, 2008 20:37
[SOLVED] Form to email with checkbox	itsdesign	PHP Forum	4	Oct 29th, 2007 00:57
A Solved Checkbox	snow	Webforumz Suggestions and Feedback	14	Sep 25th, 2007 20:11

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
[SOLVED] ASP-MySQL Delete By Checkbox