It's your CFQuery. Look at the SQL generated:
Insert into tlnkPolicy (DistrictID, District, school, PolicyNumber) Values
('xMe', '0', '0', OUPNUMBER)
"OUPNUMBER" is specified as a string with no quotes around it. In most
RDBMS's, this would mean it's a function, unless it's a number. Obviously
it's not a function; I'm assuming it's supposed to be a number. Look to
your loop: you're building #policynumber# as X number of characters
(depending on the length) of the field NAME; I'm assuming you're wanting to
compile it from field values. To do that, reference #Evaluate("form.#i#")#
instead of #i#
>From: "Susan N. Klos" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "DFWCFUG (E-mail)" <[EMAIL PROTECTED]>
>Subject: Processing a list
>Date: Tue, 7 Aug 2001 13:08:33 -0400
>
>I have two lists and a text area on a form page. The lists are tables with
>checkboxes. On the action page, the first list processes fine, however,
>the
>second does not (I haven't gotten to checking the text area yet). Here is
>the form:
><html>
><head>
><title>Page 7</title>
></head>
>
><body>
><form name="TargetGroups" action="ProcessPage7.cfm" method="post">
><table cellspacing="0" cellpadding="0" ><tr><td align="justify" ><font
>color="Navy" ><b>
>
>B. Target Groups -- Indicate with a check mark the target groups that
>received project services during the 2000 - 2001 SDFS Project
>period.</b></font>
></td></tr></table><br>
>
><cfoutput query="qryTargetGroup">
><table border="1"><tr><td>
><!--- <input type="Hidden" name="DistrictId" value="#session.DistrictID#">
>--->
><td><input type="Checkbox" value="#Groupnumber#" name="Groupnumber"></td>
></td><td><font size="-1" style="TimesNewRoman">
>#groupname#</font></td></tr></table>
></cfoutput>
><br><br>
>
><b><font color="Navy">
>
>C. District/School Policies/Practices</font></b><br><font color="Navy">
>1. In the chart below, place a check mark in the boxes that reflect the
>ATOD
>use and violence prevention policies enforced in your district, or in some
>schools in your district. Indicate whether the policy is a district policy
>or a school option. (Note: The district Safe Schools Survey responses
>should provide information on many of these.)</font>
>
><table border="1"><tr><th>District Policy</th><th>School
>Option</th></tr><tr>
><cfoutput query="qryPolicy">
><!--- <td><input type="hidden" value="#Policynumber#"
>name="Policynumber"></td> --->
><td><input type="checkbox" value="Yes" name="d_#policynumber#"> </td>
><td><input type="Checkbox" value="Yes" name="s_#policynumber#"> </td>
><td><font size="-1" style="TimesNewRoman"> #Policyname#</font></td></tr>
></cfoutput>
></table><br><br>
><table>
><tr><td><font color="navy">
>
>C. 2. List the "Hot Topics" offered in the district through the 2000-2001
>SDFS Project. (Use this format: Hot Topic1, Hot Topic2, Hot Topic3, etc.)
>When you are finished typing in the information click SUBMIT at the end.
></font></td></tr>
>
>
> <cfoutput query="qryHotTopics">
> <tr><td><textarea NAME="HotTopic" ROWS="10" COLS="40"
>Wrap="virtual">#HotTopic#
> </textarea></td></tr>
></table>
></cfoutput>
>
><input type="Submit" value="SUBMIT">
>
></form>
>
>
></body>
></html>
>Here is the processing page:
><cfif isdefined("GroupNumber")>
><cfloop list="#GroupNumber#" index="x">
><cfquery datasource="#application.db#">
>Insert into tlnkTargetGroups (DistrictID, GroupNumber)
>Values ('#session.DistrictID#', #x#)
>
></cfquery>
>
></cfloop>
></cfif>
>
><cfif isdefined("form.fieldnames")>
><cfloop list="#form.fieldnames#" index="i">
><cfset PolicyNumber = right(i, len(i) - 2)>
><cfif left(i, 1) IS "d">
> <cfset district = 1>
><cfelse>
> <cfset district = 0>
></cfif>
><cfif left(i, 1) IS "s">
> <cfset School = 1>
><cfelse>
> <cfset School = 0>
></cfif>
>
><!--- <cfoutput>#session.DistrictID# #right(i, len(i) - 2)# #district#
>#School#</cfoutput><br> --->
>
><cfquery datasource="#application.db#">
> Insert into tlnkPolicy (DistrictID, District, school, PolicyNumber)
> Values ('#session.DistrictID#', '#District#', '#School#', #PolicyNumber#)
></cfquery>
>
>
><!--- </cfif> --->
></cfloop>
>
><cfif isdefined("form.HotTopics")
><cfupdate datasource="#Application.db#" tablename="tblDistrictInfo"
>dbtype="ODBC"
> formfields="DistrictID, HotTopic">
></cfif>
>The first <cfloop list="#GroupNumber#" index="i"> processes fine. The
>second one <cfloop list="#Form.FieldNames#" index="i"> does not. I haven't
>even gotten to processing the text area yet. I think the processing is
>breaking down because of the list="#Form.fieldnames#". It loops through
>all
>the fieldnames on the form not just the second group. I am sure this is
>true because if I do not put any checkmarks in the first group it processes
>fine. I feel I have tried every combination of list=(something) and I
>can't
>seem to come up with the solution. When I try the above code and put
>checkmarks in both groups, I get the following error:
>
>Error Diagnostic Information
>
>
>ODBC Error Code = 07001 (Wrong number of parameters)
>
>
>
>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
>
>
>Hint: The cause of this error is usually that your query contains a
>reference to a field which does not exist. You should verify that the
>fields
>included in your query exist and that you have specified their names
>correctly.
>
>
>SQL = "Insert into tlnkPolicy (DistrictID, District, school, PolicyNumber)
>Values ('xMe', '0', '0', OUPNUMBER)"
>
>
>Data Source = "SDFS"
>
>
>
>The error occurred while processing an element with a general identifier of
>(CFQUERY), occupying document position (62:1) to (62:39) in the template
>file C:\Inetpub\ccDir\WebPage2001\ProcessPage7.cfm.
>
>
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
