well, that may be the case, not sure. I can do just the time by itself,
works fine. I can not do the date by itself because it says that it cant
have two values the same in the same column or something like that.
Since time is displayed down to the seconds just a Time(Now()) insert
works. I need bothr Time and Date.
am i making any sense?
Robert Everland wrote:
>
> Also double check to see if your AS/400 is set to accept the data you are
> sending in that field. The error you are getting looks as though it's
> expecting a different kind of data format so either quotes are where they
> shouldn't be or it needs quotes.
>
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
>
> -----Original Message-----
> From: jamesa {James Alexander} [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 28, 2000 2:02 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Custom Tag for Date and Time
>
> or #CreateODBCDateTime(now())#
>
> -----Original Message-----
> From: Olive, Christopher M Mr NMR
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 28, 2000 10:44 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Custom Tag for Date and Time
>
> why not just insert
>
> '#DateFormat(Now())# #TimeFormat(Now())#'
>
> ?
>
> Chris Olive,
> DOEHRS Website Administrator
>
> -----Original Message-----
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 28, 2000 11:22 AM
> To: [EMAIL PROTECTED]
> Subject: Custom Tag for Date and Time
>
> Any one have a custom tag that retrieves both the DateFormat (Now()) and
> TimeFormat (Now()) as one function that can be inserted into a database?
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
