Oracle wants dates enclosed in single quotes ('04-Apr-2000' instead of
04-Apr-2000) and is trying to interpret 04-Apr-2000 as a column name since
it doesn't think it's a date value.
-----Original Message-----
From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2000 2:54 PM
To: [EMAIL PROTECTED]
Subject: oracle error
I'm relatively new to oracle. I've looked at the oracle site and not been
able to figure this out. Help anyone? The oracle site says that the error
usually means a column name was used in the "values" section of an insert
query, but none of those values are also column names...
Oracle Error Code = 984
ORA-00984: column not allowed here
SQL = "INSERT INTO coopep.coopwebnews(articleid, headline, fulltext,
linkpage, imagename, publishdate, archivedate, sortorder) VALUES (4, 'Test
Insert Article',
'ldkjflaskjdflaskjdfla;ksjdflkajsfdlkasjdflkjasfldkjasklfdjlsakjfdlaskjdflka
sjfdlkjsadfljsalfdjlsajflkjasflkjsafdlkjsaflkjaslfdkjalskjfdlajsld;fjalskfjd
lsakjfdlaskjfdlskajfdThisistheend.', '', '', 04-Apr-2000, 10-Oct-2000, 3)"
Data Source = "d815a"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (17:1) to (17:91).
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
