Test it see if is blank or undefined with a cfif block in your SQL.
Something like:
<CFQUERY Name="update_query" datasource="#application.dsn#">
Update table_name
Set
<cfif isDefined("form.MiddleInit ") and form.MiddleInit is not "">
MiddleInit = '#form.MiddleInit #',
</cfif>
field = form.field
....
Where
....
</cfquery>
-Bill
www.brainbox.tv
----- Original Message -----
From: "Hubert Earl" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, April 28, 2001 7:05 PM
Subject: How can I get CF to ignore a form field with no data?
> Hi,
>
> How can I get CF to ignore a form field with no data? I have a form with a
field called MiddleInit which will not always be filled in. At the moment,
however, an error message is generated if that field is blank.
>
> Sincerely,
> ---
> Hubert Earl
>
> ICQ#: 16199853
> AIM: hubertfme
>
> My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
