Hello Jeremy,
'#Form.Birth_Date#'
_Date is a reserved word...
try to rename it and see if it works then..
Birgit
Thursday, August 31, 2000, 12:40:09 PM, you wrote:
> 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?sidebarlists&bodylists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
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.
