>- see footer for list info -<
I had something like this a few weeks ago...
Try putting 's around the dates and see if it fixes it.
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#',''),
Oh, and good use of NULLIF - a very underused function ;-)
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul Swingewood
Sent: 22 July 2005 12:15
To: [email protected]
Subject: [CF-Dev] Help - PLEASE..!!
>- 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
--
>- 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 -<
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of the
intended recipient(s). If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
_______________________________________________
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 -<
