Paige,
No reason to use CFTable. Just code the HTML for the table directly. You'll
write more code but you'll have a lot more flexibility and you can format
the dates any way you like.
<table>
<CFLoop query="MyQuery>
<CFoutput><tr><td>#DateFormat(mydate,"mm/dd/yyyy")#</td></tr></CFoutput>
</CFLoop>
</table>
I gave up trying to use CFGrid because of numerous formatting issues,
including the one you mentioned with dates.
Chris
---------------------------------------------------
Christopher P. Maher
mailto:[EMAIL PROTECTED]
Maher Associates, Inc.
Actuarial and Computer Consulting
http://www.maherassociates.com
> -----Original Message-----
> From: Paige Chandler [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 07, 2000 10:18 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Why does blank dates default to 1899-12-30?
>
>
> 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. 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
>
>
------------------------------------------------------------------------------
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.
