deleting of song - 8D

greenspun.com : LUSENET : WebdesignII : One Thread

I get this error message when trying to delete a song:
Database operation "dml" failed 
 (exception ORA, "ora8.c:1207:ora_exec: 
  error in `OCIStmtExecute ()': 
  ORA-00933: SQL command not properly ended SQL: 
  delete sang_titel from sangtitel  
  where  sang_titel = 'Grace' and plade_id = '10' ")
 while executing "ns_db dml $db $insert_sql.

Can you help me?

-- Tino Hyldig (tino@it-c.dk), November 02, 2000

Answers

You need to write instead:
  delete from sangtitel 
  where sang_titel = 'Grace' and plade_id = '10'


-- Martin Elsman (mael@it.edu), November 02, 2000.

Moderation questions? read the FAQ