Make sure you haven't misspelled the table name where you are inserting
the data:
You have:
<CFQUERY NAME="insert new employee" datasource="Wherewolf">
INSERT INTO empolyee_data
Values (blah....)
</cfquery>
Is the table name "employee_data"?
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner & NetObjects Reseller
210-490-3249/888-745-7603 Fax 210-490-4692
Find a Job in San Antonio http://www.sajobnet.com
>-----Original Message-----
>From: Luke Kearney [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 22, 2000 9:49 AM
>To: [EMAIL PROTECTED]
>Subject: CFTRANSACTION
>
>
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0009_01C00C93.8BCD5770
>Content-Type: text/plain;
> charset="iso-2022-jp"
>Content-Transfer-Encoding: quoted-printable
>
>Hello CF'ers
>
>Can anyone see any problems with the syntax below. The form
>fields match =
>as do the names of fields (including spelling errors ) in the
>DB but I =
>get an error complaining of missing parameters. The goal is really to =
>get data from one form on to two tables as part of a timecard
>app for an =
>intranet project. DB is MS Access. Perhaps someone with
>fresher eyes wil =
>spot my mistake immediately
>
>
>
>
>
><CFTRANSACTION>
>
><CFQUERY NAME=3D"insert new employee" datasource=3D"Wherewolf">
>INSERT INTO empolyee_data=20
>Values (#form.user_id#, #form.given_name#, #form.family_name#, =
>#form.position#, #form.supervisor#, #form.ext_number#, =
>#form.ah_contact#, #form.memo#, #form.status#, #form.return#, =
>#form.comment# )
></cfquery>
>
><CFQUERY NAME=3D"insert in_out" datasource=3D"wherewolf">
>Insert Into in_out=20
>Values (#form.user_id#, #form.given_name#, #form.family_name#, =
>#form.status#, #form.return#, #form.comment# )
></cfquery>
>
></cftransaction>
>*******************************************************************
>
>ODBC Error Code =3D 07001 (Wrong number of parameters)=20
>
>
>[Microsoft][ODBC Microsoft Access Driver] Too few parameters.
>Expected =
>8.
>
>*******************************************************************
>
>Luke Kearney
>
>
------------------------------------------------------------------------------
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.
