I can not get my insert query to work, I get the following ERROR MESSAGE:
*******************************************************************************
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
The error occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (18:1) to (18:44).
Date/Time: 08/31/00 09:24:10
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95)
*******************************************************************************
Everything in the form is spelled correctly and everything in the database
correspondes with the query. So I don't know what is wrong. Here is my CFM page.
----------------------------------------------------------------------------------------------------------
<html>
<head>
<title>Your Form Was Successfully Sent</title>
</head>
<body bgcolor="#FFFFFF" link="#0000CC" vlink="#0000CC" alink="#0000CC" text="#FFFFFF">
<cftransaction>
<cfif isdefined("Fashion")><cfset Fashion=1><cfelse><cfset Fashion=0></cfif>
<cfif isdefined("Print")><cfset Print=1><cfelse><cfset Print=0></cfif>
<cfif isdefined("Runway")><cfset Runway=1><cfelse><cfset Runway=0></cfif>
<cfif isdefined("Glamour")><cfset Glamour=1><cfelse><cfset Glamour=0></cfif>
<cfif isdefined("TV")><cfset TV=1><cfelse><cfset TV=0></cfif>
<cfif isdefined("Swimwear")><cfset Swimwear=1><cfelse><cfset Swimwear=0></cfif>
<cfif isdefined("Sportswear")><cfset Sportswear=1><cfelse><cfset Sportswear=0></cfif>
<cfif isdefined("None")><cfset None=1><cfelse><cfset None=0></cfif>
<cfquery datasource="#DSN#" name="AddPerson">
INSERT into Person (First_Name, Last_Name, Address, City, State, Zip, Country,
Phone, Email, Occupation, Registering_For, Birth_Date, Eye_Color, Hair_Color, Height,
Weight, Chest_Size, Neck_Size, Waist_Size, Skin_Tone, Shoe_Size, Experience1, Fashion,
Print, Runway, Glamour, TV, Swimwear, Sportswear, None, Agency1, Agency2,
Additional_Information, Send_Picture)
VALUES ('#Form.First_Name#', '#Form.Last_Name#', '#Form.Address#',
'#Form.City#', '#Form.State#', '#Form.Zip#', '#Form.Country#', '#Form.Phone#',
'#Form.Email#', '#Form.Occupation#', '#Form.Registering_For#', '#Form.Birth_Date#',
'#Form.Eye_Color#', '#Form.Hair_Color#', '#Form.Height#', '#Form.Weight#',
'#Form.Chest_Size#', '#Form.Neck_Size#', '#Form.Waist_Size#', '#Form.Skin_Tone#',
'#Form.Shoe_Size#', '#Form.Experience1#', '#Fashion#', '#Print#', '#Runway#',
'#Glamour#', '#TV#', '#Swimwear#', '#Sportswear#', '#None#', '#Form.Agency1#',
'#Form.Agency2#', '#Form.Additional_Information#', '#Form.Send_Picture#')
</cfquery>
</cftransaction>
<cfquery datasource="#DSN#" name="ID">
select max(Person_ID) as MaxPersonID
from Person
</cfquery>
<cfmail from="#Form.Email#" to="[EMAIL PROTECTED]" subject="Registration Form">
>From #Form.First_Name#:
GENERAL INFORMATION
Person ID: #ID.MaxPersonID#
Name: #Form.First_Name# #Form.Last_Name#
Address: #Form.Address#
City: #Form.City#
State: #Form.State#
Zip: #Form.Zip#
Country: #Form.Country#
Phone: #Form.Phone#
Email: #Form.Email#
Occupation: #Form.Occupation#
Registering For: #Form.Registering_For#
MEASUREMENTS AND STATS
Birth Date: #Form.Birth_Date#
Eye Color: #Form.Eye_Color#
Hair Color: #Form.Hair_Color#
Height: #Form.Height#
Weight: #Form.Weight#
Chest Size: #Form.Chest_Size#
Neck Size: #Form.Neck_Size#
Waist Size: #Form.Waist_Size#
Skin Tone: #Form.Skin_Tone#
Shoe Size: #Form.Shoe_Size#
EXPERIENCE
Level: #Form.Experience1#
TYPES:
Fashion: #Fashion#
Print: #Print#
Runway: #Runway#
Glamour: #Glamour#
TV: #TV#
Swimwear: #Swimwear#
Sportswear: #Sportswear#
None: #None#
Agency: #Form.Agency1#
Agency Name: #Form.Agency2#
Add Info: #Form.Additional_Information#
Sending Pictures: #Form.Send_Picture#
</cfmail>
Thank you for submitting your information.
</body>
</html>
----------------------------------------------------------------------------------------------------------
Well, I guess I need someones help.
Thanks again,
Jeremy Toevs
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
