another Error executing database query

[blu_sky]

Just when I thought I had all my forms finely tuned, I get the error below,
which has me stumped (using DrmWeaver 2004, CF7, mysql):

Error Executing Database Query.
General error: Column count doesn't match value count at row 1

The error occurred in C:\Inetpub\wwwroot\haf_cf\forms\businesses.cfm: line 81

79 : <cfelse>
80 : NULL
81 : </cfif>
82 : )
83 : </cfquery>

SQL INSERT INTO contacts (mem_type, firstname, lastname, company, address,
address2, city, ste, zip, phone, fax, email, website, biz_type) VALUES ( 'CPM'
, 'Osborne' , 'Sybex' , '2121 Chapp St' , NULL , 'Baltimore' , 'MD' , '10489' ,
'555-555-4469' , '718-998-9988' , 'bill@asdx.com' , 'www.xyz.com' , 'Home
Builder' )
DATASOURCE haf

This is the form code:

<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery datasource="fah">
INSERT INTO business_apps (mem_type, firstname, lastname, company, address,
address2, city, ste, zip, phone, fax, email, website, biz_type) VALUES (
<cfif IsDefined("FORM.mem_type") AND #FORM.mem_type# NEQ "">
'#FORM.mem_type#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.lastname") AND #FORM.lastname# NEQ "">
'#FORM.lastname#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.company") AND #FORM.company# NEQ "">
'#FORM.company#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.address") AND #FORM.address# NEQ "">
'#FORM.address#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.address2") AND #FORM.address2# NEQ "">
'#FORM.address2#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.city") AND #FORM.city# NEQ "">
'#FORM.city#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.ste") AND #FORM.ste# NEQ "">
'#FORM.ste#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.zip") AND #FORM.zip# NEQ "">
'#FORM.zip#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.phone") AND #FORM.phone# NEQ "">
'#FORM.phone#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.fax") AND #FORM.fax# NEQ "">
'#FORM.fax#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.email") AND #FORM.email# NEQ "">
'#FORM.email#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.website") AND #FORM.website# NEQ "">
'#FORM.website#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.biz_type") AND #FORM.biz_type# NEQ "">
'#FORM.biz_type#'
<cfelse>
NULL
</cfif>
)
</cfquery>
<cflocation url="../confirmation/confirm_business_mem.cfm">
</cfif>

I can't see anything wrong, but CF says that there is. I'm still going
throught the learning curve. Thanks in advance for the help.

[OldCFer]

You're specifying 14 DB fields but you're only supplying 13 form fields. You forgot
form.firstname, I believe.

[blu_sky]

Dang!! You're right! I forgot the firstname field. I learn something new everytime I visit this forum. Guess I'll hang aroung here more often. Thanks again OldCFer!