avatar

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

bounty icon
$15
Single winner
Asked  9 months 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

  • add comment
avatar

conn.execute"delete from upfile where FilePath in('"&FilePath&"')"

This FilePath you have to do the splicing process yourself.

After it is done, it should look like this:

conn.execute"delete from upfile where FilePath in('FilePath1',' FilePath2','FilePath3')"

  • Taken
  • add comment
  • 0
Sign In
Sign In
avatar

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

bounty icon
$15
Single winner
Asked  9 months 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

  • add comment
avatar

conn.execute"delete from upfile where FilePath in('"&FilePath&"')"

This FilePath you have to do the splicing process yourself.

After it is done, it should look like this:

conn.execute"delete from upfile where FilePath in('FilePath1',' FilePath2','FilePath3')"

  • Taken
  • add comment
  • 0