HOLD! Don't panic. This can be done. Don't give up yet.
At 10:18 AM 7/7/00 -0400, you wrote:
>Hi Michael,
>
>Thanks for the suggestion. This is very bad news. My app displays the status
>of a list of insurance policies for a particular piece of property: Date
>Issued, Date Canceled, Date Expired. Most of the time the last two are
>blank. And there may be from 1 to 9 policies listed for a property: General
>Liability, Auto, Umbrella, etc. I don't believe that I can insert CFIF tags
>within CFTable or CFGrid. The only workaround for me (other than to use ASP)
>is to convert all date fields to text fields. This is possible now because I
>prepare a special data file for web access. If I were allowing the clients
>to hit the live database, which is in future plans, I may not be able to use
>CF.
>
>I'm don't believe I can use <TABLE> because there is no functions available
>to format date and dollar amounts.
ColdFusion has functions to format dates and dollar amounts. They can be
used outside other CF functions or within them. There is a DateFormat
function and a DollarFormat function. You can use those just about
anywhere. I've never used CFTable, personally. I just looked up some info
on it and it seems as though most of the functionality can be done with
<table> (according to CFWACK it may even look better with <table>). The
main differences between <table> and <cftable> are that you don't have to
put HMTL in <cftable> and that <cftable> doesn't actually output HTML, so
if the user doesn't have proper browser that doesn't matter.
> Other than that, this app was done and
>ready to go live Monday. What a kick in rear. Thanks again. Have a nice day.
>See you Tuesday eve.
>
>Regards,
>
>Paige
>
>
>
>----- Original Message -----
>From: Michael Smith <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, July 07, 2000 12:04 AM
>Subject: Re: Why does blank dates default to 1899-12-30?
>
>
> >
> > --------------106E292EBC4B30F10F8DC269
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > I had the same problem with FoxPro 2.0 data. The workaround I came up with
>was to not display dates older than 1901:
> >
> > <cfif year(followup) gt
>1901>#DateFormat(followup,'dd-mm-yyyy')#</cfif>
> > I was displaying the date field directly, not using CFGrid, so your milage
>may vary...
> >
> > - Michael Smith, TeraTech http://www.cfconf.org/
> > MDCFUG http://www.cfug-md.org/
> >
> > Paige Chandler wrote:
> >
> > > This is a multi-part message in MIME format.
> > >
> > > ------=_NextPart_000_0009_01BFE76E.D7462320
> > > Content-Type: text/plain;
> > > charset="iso-8859-1"
> > > Content-Transfer-Encoding: quoted-printable
> > >
> > > Hi All,
> > >
> > > I'm "Selecting * From..." using a Visual FoxPro free table. Some of the
>=
> > > date fields (VFP date format) are blank. When displayed with CFTable or
>=
> > > CFGridCol they appear "1899-12-30". I must resolve this. Any =
> > > suggestions? TIA.
> > >
> > > Regards,
> > >
> > > Paige
> > >
> > > ------=_NextPart_000_0009_01BFE76E.D7462320
> > > Content-Type: text/html;
> > > charset="iso-8859-1"
> > > Content-Transfer-Encoding: quoted-printable
> > >
> > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > > <HTML><HEAD>
> > > <META content=3D"text/html; charset=3Diso-8859-1" =
> > > http-equiv=3DContent-Type>
> > > <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
> > > <STYLE></STYLE>
> > > </HEAD>
> > > <BODY bgColor=3D#ffffff>
> > > <DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>I'm "Selecting * From..." using a =
> > > Visual FoxPro=20
> > > free table. Some of the date fields (VFP date format) are blank. When =
> > > displayed=20
> > > with CFTable or CFGridCol they appear "1899-12-30". I must resolve this.
>=
> > > Any=20
> > > suggestions? TIA.</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
> > > <DIV> </DIV>
> > > <DIV><FONT face=3DArial size=3D2>Paige</FONT></DIV></BODY></HTML>
> > >
> > > ------=_NextPart_000_0009_01BFE76E.D7462320--
> > >
> >
> > --------------------------------------------------------------------------
>----
> > > Archives: http://www.mail-archive.com/[email protected]/
> > > 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.
> >
> > --
> > Michael Smith, TeraTech Inc - Tools for Programmers(tm)
> > VB, CF/ASP Web, Telephony, Math, Access programming tools & consulting
> > 100 Park Ave Ste 360, Rockville MD 20850 USA
> > Voice: +1-301-424-3903, 800-447-9120 x500 Fax:301-762-8185
>BBS:301-762-8184
> > Web: http://www.teratech.com/sig/
> > Email: mailto:[EMAIL PROTECTED]
> >
> >
> > --------------106E292EBC4B30F10F8DC269
> > Content-Type: text/html; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> > <html>
> > I had the same problem with FoxPro 2.0 data. The workaround I came up with
> > was to not display dates older than 1901:
> > <p> <cfif year(followup) gt
>1901>#DateFormat(followup,'dd-mm-yyyy')#</cfif>
> > <br>I was displaying the date field directly, not using CFGrid, so your
> > milage may vary...
> > <p>- Michael Smith, TeraTech <A
>HREF="http://www.cfconf.org/">http://www.cfconf.org/</A>
> >
><br>
> &nbs
>p;
> > MDCFUG <A HREF="http://www.cfug-md.org/">http://www.cfug-md.org/</A>
> > <p>Paige Chandler wrote:
> > <blockquote TYPE=CITE>This is a multi-part message in MIME format.
> > <p>------=_NextPart_000_0009_01BFE76E.D7462320
> > <br>Content-Type: text/plain;
> > <br> charset="iso-8859-1"
> > <br>Content-Transfer-Encoding: quoted-printable
> > <p>Hi All,
> > <p>I'm "Selecting * From..." using a Visual FoxPro free table. Some of
> > the =
> > <br>date fields (VFP date format) are blank. When displayed with CFTable
> > or =
> > <br>CFGridCol they appear "1899-12-30". I must resolve this. Any =
> > <br>suggestions? TIA.
> > <p>Regards,
> > <p>Paige
> > <p>------=_NextPart_000_0009_01BFE76E.D7462320
> > <br>Content-Type: text/html;
> > <br> charset="iso-8859-1"
> > <br>Content-Transfer-Encoding: quoted-printable
> > <p><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <br><HTML><HEAD>
> > <br><META content=3D"text/html; charset=3Diso-8859-1" =
> > <br>http-equiv=3DContent-Type>
> > <br><META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
> > <br><STYLE></STYLE>
> > <br></HEAD>
> > <br><BODY bgColor=3D#ffffff>
> > <br><DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
> > <br><DIV>&nbsp;</DIV>
> > <br><DIV><FONT face=3DArial size=3D2>I'm "Selecting * From..." using
> > a =
> > <br>Visual FoxPro=20
> > <br>free table. Some of the date fields (VFP date format) are blank. When
> > =
> > <br>displayed=20
> > <br>with CFTable or CFGridCol they appear "1899-12-30". I must resolve
> > this. =
> > <br>Any=20
> > <br>suggestions? TIA.</FONT></DIV>
> > <br><DIV>&nbsp;</DIV>
> > <br><DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
> > <br><DIV>&nbsp;</DIV>
> > <br><DIV><FONT face=3DArial
>size=3D2>Paige</FONT></DIV></BODY></HTML>
> > <p>------=_NextPart_000_0009_01BFE76E.D7462320--
> >
><p>-------------------------------------------------------------------------
>-----
> > <br>Archives: <a
>href="http://www.mail-archive.com/[email protected]/">http://www.mai
>[EMAIL PROTECTED]/</a>
> > <br>To Unsubscribe visit <a
>href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_ta
>lk</a>
> > or send a message to [EMAIL PROTECTED] with 'unsubscribe'
> > in the body.</blockquote>
> >
> > <p>--
> > <br>Michael Smith, TeraTech Inc - Tools for Programmers(tm)
> > <br>VB, CF/ASP Web, Telephony, Math, Access programming tools &
>consulting
> > <br>100 Park Ave Ste 360, Rockville MD 20850 USA
> > <br>Voice: +1-301-424-3903, 800-447-9120 x500 Fax:301-762-8185
> > BBS:301-762-8184
> > <br>Web: <A
>HREF="http://www.teratech.com/sig/">http://www.teratech.com/sig/</A>
> > <br>Email: <A
>HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>
> > <br> </html>
> >
> > --------------106E292EBC4B30F10F8DC269--
> >
> > --------------------------------------------------------------------------
>----
> > Archives: http://www.mail-archive.com/[email protected]/
> > 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/[email protected]/
>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/[email protected]/
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.
