Jeg fC%r fC8lgende fejlmeddelese og ved ikke hvad jeg skal gC8re med den! :

Database operation "dml" failed (exception ORA, "ora8.c:1207:ora_exec: error in `OCIStmtExecute ()': ORA-00984: column not allowed here

SQL: insert into comments (id, url, insertdate, name, email, text) values (comment_sequence.nextval, 'http://hug.it.edu:8051/index.html', insertdate,'paul','paul@sol.dk', 'du er for fed')")

while executing "ns_db dml $db "insert into comments (id, url, insertdate, name, email, text) values (comment_sequence.nextval, '$url', insertdate,'$..." (file "/web/plyster/www/oevelse7/comments_add.tcl" line 39) invoked from within "source $file"

-- peter lyster (plyster@it-c.dk), October 25, 2000

Answers

Try using sysdate - instead of insertdate - for the value to put in the column insertdate.

-- Martin Elsman (mael@it.edu), October 26, 2000.