Date is not formatting properly. I get "12/30/189905/11/2006"
I enter a date of 04/18/2007 and it takes the previous date entered into the
database and displays it again with next entry and adds 12/30/1899. The
datatype in database is set to Date/Time.
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ
"frmAddEvents">
<cfquery datasource="member_login">
INSERT INTO Events (Events, EventDate)
VALUES (
<cfif IsDefined("FORM.Events") AND #FORM.EventDate# NEQ "">
'#FORM.Events#', #FORM.EventDate#
<cfelse>
NULL, NULL
</cfif>
)
</cfquery>
<form action="<cfoutput>#CurrentPage#</cfoutput>" method="post"
name="frmEvents" id="frmAddEvents">
<input type="text" name="eventDate" id="eventDate" size="15" maxlength="10"
class="formveld" />
<textarea name="events" cols="70" rows="10" id="events"
class="formveld"></textarea>
<input name="Reset" type="reset" id="Reset" value=" Reset " class="formveld">
<input name="Submit" type="submit" id="Submit" value=" Submit "
class="formveld">
<input type="hidden" name="MM_InsertRecord" value="frmAddEvents">
</form>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275904
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
