>- see footer for list info -<
How are your dates formatted? Try CreateODBCDate() instead of
LSDateFormat(), you should only use the DateFormat() functions for
display purposes and not for actual data.
On 7/22/05, Paul Swingewood <[EMAIL PROTECTED]> wrote:
> >- 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 -<
>
--
Simon Baynes
www.simonbaynes.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 -<
