Based on the query you provided:
UPDATE tblCouncilMember
SET Fname = '#Arguments.Fname#',
Lname = '#Arguments.Lname#',
Address = '#Arguments.Address#',
City = '#Arguments.City#',
State = '#Arguments.State#',
Zip = '#Arguments.Zip#',
Phone = '#Arguments.Phone#',
Email = '#Arguments.Email#',
Status = '#Arguments.Status#',
NC_ID = #Arguments.NC_ID#,
IssuesOfConcern =
'#Arguments.IssuesOfConcern#',
DateElected = '#Arguments.DateElected#',
DateAppointed = '#Arguments.AppointedDate#',
ResignDate = '#Arguments.ResignDate#',
TermLength = '#TermLength#'
WHERE CouncilMemberID =
#Arguments.CouncilMemberID#
If for example you pass 'DateElected' but DateAppointed and ResignDate
are not filled out the resulting query is passing an empty string to
SQL, which as Teddy said will cause it to be stored as 1/1/1900. If you
change all your date fields to one of the following it will solve your
problem:
1. For example DateElected
<cfqueryparam cfsqltype="cf_sql_date" value="#arguments.DateElected#"
null="#len(arguments.DateElected)#">
2.
<cfif
len(arguments.DateElected)>#arguments.DateElected#<cfelse>NULL</cfif>
This will cause NULL to be passed to the database if the DateElected
variable is an empty string.
HTH,
Rich Kroll
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267503
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
