Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Help with a delete statement

Help with a delete statement

Thread began 4/27/2011 6:46 pm by bjgarner241692 | Last modified 4/27/2011 6:52 pm by bjgarner241692 | 879 views | 1 replies

4/27/2011 6:46 pmbjgarner241692

Help with a delete statement

This is not a PHP issue, it is ASP with Access and it has nothing at all to do with WA products, but I'm hopeful that someone can help.

Why does this work?
WADAcounter_cmd.CommandText = "SELECT * FROM viewcounter WHERE extra1 Like '%+http://%'"

But not this?
WADAcounter_cmd.CommandText = "DELETE * FROM viewcounter WHERE extra1 Like '%+http://%'"

I've tried * instead of % because if you were to run it in ACCESS you would use *.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.