This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFCA69.CA642360
Content-Type: text/plain;
charset="iso-8859-1"
what does your schema look like for this table? I dunno if those '' are
being interpretted as NULLS, so check to see if linkpage and imagename allow
nulls or not....
also, you may have to surround your dates in single quotes too.....
just things to try really. Oracle error messages are usually a joke.
post your schema and I will see if I can spot anything....
--b
-----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.
------_=_NextPart_001_01BFCA69.CA642360
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: oracle error</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>what does your schema look like for this table? =
I dunno if those '' are being interpretted as NULLS, so check to see if =
linkpage and imagename allow nulls or not....</FONT></P>
<P><FONT SIZE=3D2>also, you may have to surround your dates in single =
quotes too.....</FONT>
</P>
<P><FONT SIZE=3D2>just things to try really. Oracle error =
messages are usually a joke.</FONT>
</P>
<P><FONT SIZE=3D2>post your schema and I will see if I can spot =
anything....</FONT>
</P>
<P><FONT SIZE=3D2>--b</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Deanna L. Schneider [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:deanna.schneider@ce=
s.uwex.edu</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, May 30, 2000 2:54 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>Subject: oracle error</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>I'm relatively new to oracle. I've looked at the =
oracle site and not been</FONT>
<BR><FONT SIZE=3D2>able to figure this out. Help anyone? The oracle =
site says that the error</FONT>
<BR><FONT SIZE=3D2>usually means a column name was used in the =
"values" section of an insert</FONT>
<BR><FONT SIZE=3D2>query, but none of those values are also column =
names...</FONT>
</P>
<P><FONT SIZE=3D2>Oracle Error Code =3D 984</FONT>
</P>
<P><FONT SIZE=3D2>ORA-00984: column not allowed here</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>SQL =3D "INSERT INTO =
coopep.coopwebnews(articleid, headline, fulltext,</FONT>
<BR><FONT SIZE=3D2>linkpage, imagename, publishdate, archivedate, =
sortorder) VALUES (4, 'Test</FONT>
<BR><FONT SIZE=3D2>Insert Article',</FONT>
<BR><FONT =
SIZE=3D2>'ldkjflaskjdflaskjdfla;ksjdflkajsfdlkasjdflkjasfldkjasklfdjlsak=
jfdlaskjdflka</FONT>
<BR><FONT =
SIZE=3D2>sjfdlkjsadfljsalfdjlsajflkjasflkjsafdlkjsaflkjaslfdkjalskjfdlaj=
sld;fjalskfjd</FONT>
<BR><FONT SIZE=3D2>lsakjfdlaskjfdlskajfdThisistheend.', '', '', =
04-Apr-2000, 10-Oct-2000, 3)"</FONT>
</P>
<P><FONT SIZE=3D2>Data Source =3D "d815a"</FONT>
</P>
<P><FONT SIZE=3D2>The error occurred while processing an element with a =
general identifier of</FONT>
<BR><FONT SIZE=3D2>(CFQUERY), occupying document position (17:1) to =
(17:91).</FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT =
SIZE=3D2>************************************************************</F=
ONT>
<BR><FONT SIZE=3D2>Deanna Schneider</FONT>
<BR><FONT SIZE=3D2>Interactive Media Developer</FONT>
<BR><FONT SIZE=3D2>UWEX Cooperative Extension Electronic Publishing =
Group</FONT>
<BR><FONT SIZE=3D2>103 Extension Bldg</FONT>
<BR><FONT SIZE=3D2>432 N. Lake Street</FONT>
<BR><FONT SIZE=3D2>Madison, WI 53706</FONT>
<BR><FONT SIZE=3D2>(608) 265-7923</FONT>
</P>
<BR>
<BR>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.eGroups.com/list/cf-talk" =
TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01BFCA69.CA642360--
------------------------------------------------------------------------------
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.
