I have a dataobject having 5 fields. One among them is a date time
field. This dataobject
is bound to a repeated object in a ND page. The repeated object has 5
display fields all of which
are href's. The requirement is the date time object should be formatted like
this:
'MM/DD/YYYY HH:MM PM ' CST
Eg: 05/05/1999 10:00 AM CST
I have set the partial text override and the sql text select is being
overwritten in the wizard
whenever I give TO_CHAR(DateField, 'MM/DD/YYYY HH:MM PM') || ' CST' , it
gives me the following
software messages in my page.
doWFRptDetail.convertDataFieldValue: Unexpected Exception
(spider.session.CSpDatetimeParsingException: parseTimeFromString: invalid
substring (CST) when
parsing '09:05 AM CST' [null]) caught in 'doWFRptDetail'(a
NewsWeb.doWFRptDetail) [Parent:
'NewsWeb'(a NewsWeb.NewsWeb)]. Top of stack:
|spider.session.CSpDatetimeParsingException:
parseTimeFromString: invalid substring (CST) when parsing '09:05 AM CST'
[null] at
java.lang.Throwable.<init>(Compiled Code) at
java.lang.Exception.<init>(Compiled Code) at
spider.util.CSpSpiderException.<init>(Compiled Code) at
spider.util.CSpSpiderException.<init>(Compiled Code) at
spider.session.CSpValueConversionException.<init>(Compiled Code) at
spider.session.CSpDatetimeParsingException.<init>(Compiled Code) at
spider.session.CSpDatetime.parseTimeFromString(Compiled Code) at
Can anyone please help me on this.
Thanks in advance,
Prasad
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
