Please send some code.
In the meantime, I am going to make a stab at this. I forecast a 95% chance
of my being wrong but what the hey. What is the primary key of the table
you are trying to insert to and are you inserting a value for that column.
At 02:19 PM 8/18/00 +0900, you wrote:
>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_01C008D3.D44DE410
>Content-Type: text/plain;
> charset="shift_jis"
>Content-Transfer-Encoding: quoted-printable
>
>I am very very new to CF and programming in general. I have been using =
>CF
>for a couple of months all up. I am trying to create a form that inputs =
>data
>into my DB. The data to be entered will be along the lines of company =
>news.
>the app is an intranet. The idea is that users can enter news items and =
>then
>these will be displayed and dynamically updated on the main pages.=20
>=20
>So I have a DB called news2c and the form is also called news2c. I =
>tried to
>code the page on the go but it did not work, so like all good cheats =
>and
>novices I used the CF wizard to create the input form and action form.
>Simple enough I thought but it still does not work at all. I get an =
>error as
>follows:-
>=20
>=20
>
>Error Occurred While Processing Request
>
>
>
>
>
>Error Diagnostic Information
>
>
>ODBC Error Code =3D S1000 (General error)=20
>
>
>
>[Microsoft][ODBC Microsoft Access Driver] Operation must use an =
>updateable
>query.=20
>
>
>
>
>The error occurred while processing an element with a general =
>identifier of
>(CFINSERT), occupying document position (1:1) to (1:49).
>
>
>Date/Time: 08/18/00 14:12:51
>Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
>Remote Address: 127.0.0.1
>HTTP Referer: <http://127.0.0.1/Intranet/newsplease_EntryForm.cfm>
>http://127.0.0.1/Intranet/newsplease_EntryForm.cfm=20
>
>
>=20
>
>can anyone suggest what it is that I am doing wrong here ????
>
>=20
>
>Thanks
>
>=20
>=20
>Luke Kearney
>=83=8B=81[=83N =83J=81[=83j=81[
>East West Technology Service Inc.
>Tel (03) 3222 7459
>Fax (03) 3222 5591
>=20
>
>------_=_NextPart_001_01C008D3.D44DE410
>Content-Type: text/html;
> charset="shift_jis"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>I am = very very new to=20 CF and programming in general. I have been
>using CF for a couple of = months all=20 up. I am trying to create a form
>that inputs data into my DB. The = data to=20 be entered will be along the
>lines of company news. the app is an = intranet. The=20 idea is that users
>can enter news items and then these will be = displayed and=20 dynamically
>updated on the main pages.
>
>So I = have a DB called=20 news2c and the form is also called news2c. I
>tried to code the page on = the go=20 but it did not work, so like all
>good cheats and novices I used the CF = wizard to=20 create the input form
>and action form. Simple enough I thought but it = still does=20 not work
>at all. I get an error as follows:-
>
>
>
>
>Error Occurred While Processing = Request
>
>
>
>
>
>
>Error Diagnostic = Information
>
>
>
>ODBC Error Code =3D S1000 (General = error)
>
>[Microsoft][ODBC Microsoft Access = Driver]=20 Operation must use an
>updateable query.
>
>The error occurred while processing = an element=20 with a general
>identifier of (CFINSERT), occupying document = position (1:1)=20 to (1:49).
>
>Date/Time: 08/18/00 = 14:12:51
>Browser:=20 Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
>Remote = Address:=20 127.0.0.1
>HTTP Referer:
>
>
>
>can anyone = suggest what=20 it is that I am doing wrong here ????
>
>
>
>Thanks
>
>
>Luke Kearney
>=83=8B=81[=83N = =83J=81[=83j=81[
>East West Technology Service = Inc.
>Tel (03) 3222 7459
>Fax (03) 3222 5591
>
>
>------_=_NextPart_001_01C008D3.D44DE410--
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>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.mail-archive.com/[email protected]/
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.
