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
------=_NextPart_000_0009_01C00C93.8BCD5770
Content-Type: text/html;
charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-2022-jp" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3D"MS PMincho" size=3D2>Hello CF'ers</FONT></DIV>
<DIV><FONT face=3D"MS PMincho" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"MS PMincho" size=3D2>Can anyone see any problems with =
the syntax=20
below. The form fields match as do the names of fields (including =
spelling=20
errors ) in the DB but I get an error complaining of missing parameters. =
The=20
goal is really to get data from one form on to two tables as part of a =
timecard=20
app for an intranet project. DB is MS Access. Perhaps someone with =
fresher eyes=20
wil spot my mistake immediately</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS PMincho" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"MS PMincho" =
size=3D2><CFTRANSACTION></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS PMincho" size=3D2><CFQUERY NAME=3D"insert new =
employee"=20
datasource=3D"Wherewolf"><BR>INSERT INTO empolyee_data <BR>Values=20
(#form.user_id#, #form.given_name#, #form.family_name#, #form.position#, =
#form.supervisor#, #form.ext_number#, #form.ah_contact#, #form.memo#,=20
#form.status#, #form.return#, #form.comment# =
)<BR></cfquery></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS PMincho" size=3D2><CFQUERY NAME=3D"insert =
in_out"=20
datasource=3D"wherewolf"><BR>Insert Into in_out <BR>Values =
(#form.user_id#,=20
#form.given_name#, #form.family_name#, #form.status#, #form.return#,=20
#form.comment# )<BR></cfquery></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS PMincho" =
size=3D2></cftransaction></FONT></DIV>
<DIV><FONT face=3D"MS PMincho" size=3D2>
<P>*******************************************************************
<P>ODBC Error Code =3D 07001 (Wrong number of parameters)=20
<P>
<P>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. =
Expected=20
8.</P></FONT></DIV>
<DIV><FONT face=3D"MS PMincho"=20
size=3D2>****************************************************************=
***</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3D"MS PMincho" size=3D2>Luke =
Kearney<BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_0009_01C00C93.8BCD5770--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
