conn.execute"delete from upfile where FilePath in('"&FilePath&"')" cannot delete multiple records
conn.execute"delete from upfile where FilePath in('"&FilePath&"')" cannot delete multiple records
$15
Single winner
Asked a year ago
Viewed 0 times
FilePath is a selection of checkboxes
conn.execute"delete from upfile where FilePath in('"&FilePath&"')" The value of this checkbox is FilePath.
If you choose one, you can delete successfully. If you choose more than two, you can't delete Up. Weird.
But if you change the ID back, you can delete more than two records:
conn.execute"delete from upfile where id in("&id&")" The value of this check box is id The
upfile database record looks like this:
id FilePath
1 b5.jpg
2 a1.jpg
3 b2 .jpg
conn.execute"delete from upfile where FilePath in('"&FilePath&"')" cannot delete multiple records
conn.execute"delete from upfile where FilePath in('"&FilePath&"')" cannot delete multiple records
FilePath is a selection of checkboxes
conn.execute"delete from upfile where FilePath in('"&FilePath&"')" The value of this checkbox is FilePath.
If you choose one, you can delete successfully. If you choose more than two, you can't delete Up. Weird.
But if you change the ID back, you can delete more than two records:
conn.execute"delete from upfile where id in("&id&")" The value of this check box is id The
upfile database record looks like this:
id FilePath
1 b5.jpg
2 a1.jpg
3 b2 .jpg