- see footer for list info -<
This is driving me nuts and I just can't figure out whats going on ....?
I have two variables #request.startdate# #request.enddate#
If I run this
<cfoutput>
INC_EVENT_BEGIN_PROCESS
<p>
START - #Request.StartDate#<br>
END - #Request.EndDate#
</p>
</cfoutput>
<cfabort>
I see that dates correctly as expected
This part of a query inserts to an SQL table with the fields set as datetime
VALUES (
#Request.EventTypeID#,
'#Request.EventName#',
'#Request.EventShortDesc#',
NULLIF('#Request.EventDescription#',''),
'#Request.Location#',
NULLIF('#Request.EventURL#',''),
#lsdateformat(Request.StartDate, 'dd/mm/yyyy')#,
#lsdateformat(Request.EndDate, 'dd/mm/yyyy')#,
NULLIF('#Request.ContactName#',''),
When I look in the table both dates are set to 01/01/1900
AGhhhh! - Im tearing my hair out on this one. Can anyone help me please.
(I've tried removing the lsdateformat but that didn't do anything :(
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
