DELETE FROM doesn't work

Results 1 to 2 of 2

Thread: DELETE FROM doesn't work

  1. #1
    Join Date
    Dec 1969

    Default DELETE FROM doesn't work

    Any ideas why simple statement as "DELETE FROM products where product_name='chair'" doesn't work?? The same record gets deleted just fine when referenced by ID (ie "DELETE FROM products where product_ID=24")!!?? No spelling mistakes guaranteed!

  2. #2
    Join Date
    Dec 1969

    Default RE: DELETE FROM doesn't work

    Guaranteed?<BR><BR>That&#039;s a strong word :-)<BR><BR>What database are you using? What happens if you execute that EXACT query as a Query in Access, or in Enterprise Manager in SQL Server?<BR><BR>Are there any differences in capitalisation? What about whitespace differences?<BR><BR>Have you done a response.write of your query before you execute it - are you sure that everything&#039;s correctly being filled in?<BR><BR>Craig.

Posting Permissions

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