Hi Tammy,
<INPUT TYPE="text" Name"Parent_ID" SIZE="5" MAXLENGTH="5">
Mother's ID number
If this is exact the code you used , then you forgot the "=" sign between
"Name" and " the Parent_ID" in the <input> tag.
Sima
Tammy
Schilling To: CF-Talk <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
om> Subject: form passes all fields, except
one?
11/22/00
10:05 AM
Please
respond to
cf-talk
--------------CF871434F10C748D047F62D1
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi all, I'm struggling with a form and query problem. There are four form
fields to be inserted into a table. All
seem to pass just fine, except one. I can't figure out why. I've checked
how I've spelled it in both templates
and the database, even to the point of retyping it to be sure.
This is the form field that won't seem to pass:
<FORM ACTION="process_newchild.cfm" METHOD="POST">
<INPUT TYPE="text" Name"Parent_ID" SIZE="5" MAXLENGTH="5">
Mother's ID number
This is the query that I'm using
<CFQUERY DATASOURCE="LLL">
INSERT INTO Children (Parent_ID , FirstName, LastName, Birthday_DueDate)
VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#', '
#form.Birthday_DueDate#')
</cfquery>
This is the error that I get
Error resolving parameter FORM.PARENT_ID
The specified form field cannot be found. This problem is very likely due
to the fact that you
have misspelled the form field name.
The error occurred while evaluating the expression:
#form.Parent_ID#
The error occurred while processing an element with a general identifier
of
(#form.Parent_ID#), occupying document position (7:10) to (7:25).
Any idea what I'm doing wrong?
Thanks!
Tammy
--
personal copy designs
better living through computer graphics
http://www.personal-copy.com
410 219 5300
--------------CF871434F10C748D047F62D1
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi all, I'm struggling with a form and query problem. There are four
form fields to be inserted into a table. All seem to pass just fine,
except one. I can't figure out why. I've checked how I've
spelled
it in both templates and the database, even to the point of retyping it
to be sure.
<p><b><u>This is the form field that won't seem to pass:</u></b>
<br><FORM ACTION="process_newchild.cfm" METHOD="POST">
<p><INPUT TYPE="text" Name"Parent_ID" SIZE="5" MAXLENGTH="5">
<br>Mother's ID number
<p><b><u>This is the query that I'm using</u></b>
<br><CFQUERY DATASOURCE="LLL">
<br>INSERT INTO Children (Parent_ID , FirstName, LastName,
Birthday_DueDate)
<br>VALUES ('#form.Parent_ID#' , '#form.FirstName#', '#form.LastName#',
'#form.Birthday_DueDate#')
<br></cfquery><b><u></u></b>
<p><b><u>This is the error that I get</u></b>
<br>Error resolving parameter FORM.PARENT_ID
<p> The specified form field cannot be found. This problem is very
likely due to the fact that you
<br> have misspelled the form field name.
<p> The error occurred while evaluating the expression:
<p> #form.Parent_ID#
<p> The error occurred while processing an element with a general
identifier of
<br> (#form.Parent_ID#), occupying document position (7:10) to (7:25).
<br>
<p>Any idea what I'm doing wrong?
<p>Thanks!
<p>Tammy
<br>--
<br>personal copy designs
<br>better living through computer graphics
<br><A HREF="http://www.personal-copy.com">http://www.personal-copy.com</A>
<br>410 219 5300
<br> </html>
--------------CF871434F10C748D047F62D1--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
