This is a multi-part message in MIME format.
------=_NextPart_000_0028_01BFE84F.B1E887D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Michael, Ken, Jim, Jennifer, et al,
Thank you ALL very very very..... much for all your help. I'll not make =
this brief in hopes that my efforts will help others not to make the =
same mistakes.
I first tried CFTable but because of the lack of functions for =
date/number and font size control I tried CFGrid. The default font for =
CFGrid is quite adequate. Smaller than "normal" font both horizontally =
and vertically. But I couldn't get NumberFormat to work with CFGrid and =
I can't use Michael's suggestion for checking for date GT 1901 because I =
can't insert a CFIF tag in CFTable or CFGrid.=20
I reconfigured my datasource by converting the date fields to text and =
the number fields to text with commas. This was easy using the VFP CTOD =
and the Translate functions in the SELECT. Only the numbers worked with =
CFTable, neither worked with CFGrid. CFGrid displayed the text date =
fields as 1899-12-30 and the numbers without commas even though they are =
part of the data.
You can imagine my frustration at this point. Although this is my first =
major CF app, I've been attending the CFUG-MD for years, since it =
started. I believed that it was the best. I have both Forta's books plus =
one by Sybex. I convinced my personal clients to go with CF. I've also =
attended the FoxPro sigs here for years. I've convinced my friends there =
to consider CF instead of Web Conection or FoxWeb. THEY ARE GOING TO =
HANG ME.=20
Where did I wind up? With you help and encouragement I'm using TABLE =
successfully. Using the attributes Align, Font Size, Width, etc. and =
DateFormat and NumberFormat. Using the original datasource (unconverted) =
and Michaels suggestion for checking for GT 1901 and otherwise =
displaying a variable of ' / / '.
The table fits the page horizontally but I may want to change to a font =
style that is smaller in height so I can fit more rows comfortably. That =
was one of the advantages of CFGrid. I tried TR Height=3D??. 100 works =
but 2 doesn't. That is I can increase the row height but not reduce it.
So I'm back to where I started out weeks ago; trying to displaying the =
policy data in a table. Successfully now - thanks to you all, albiet =
Table instead of CFTable. And I expect to deliver the app Monday. Thanks =
again for your concern and suggestions. Have a nice weekend. I'm going =
to get a tall drink.
Regards,
Paige
------=_NextPart_000_0028_01BFE84F.B1E887D0
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 Michael, Ken, Jim, Jennifer, et =
al,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thank you ALL very very very..... much =
for all your=20
help. I'll not make this brief in hopes that my efforts will help others =
not to=20
make the same mistakes.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I first tried CFTable but because of =
the lack of=20
functions for date/number and font size control I tried CFGrid. The =
default=20
font for CFGrid is quite adequate. Smaller than "normal" font both =
horizontally=20
and vertically. But I couldn't get NumberFormat to work with CFGrid and =
I can't=20
use Michael's suggestion for checking for date GT 1901 because I can't =
insert a=20
CFIF tag in CFTable or CFGrid. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I reconfigured my datasource by =
converting the date=20
fields to text and the number fields to text with commas. This was =
easy=20
using the VFP CTOD and the Translate functions in the SELECT. Only the =
numbers=20
worked with CFTable, neither worked with CFGrid. CFGrid displayed the =
text date=20
fields as 1899-12-30 and the numbers without commas even though they are =
part of=20
the data.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>You can imagine my frustration at this =
point.=20
Although this is my first major CF app, I've been attending the CFUG-MD =
for=20
years, since it started. I believed that it was the best. I have =
both=20
Forta's books plus one by Sybex. I convinced my personal clients to go =
with CF.=20
I've also attended the FoxPro sigs here for years. I've convinced my =
friends=20
there to consider CF instead of Web Conection or FoxWeb. THEY ARE GOING =
TO HANG=20
ME. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Where did I wind up? With you =
help and=20
encouragement I'm using TABLE successfully. Using the attributes Align, =
Font=20
Size, Width, etc. and DateFormat and NumberFormat. Using the original =
datasource=20
(unconverted) and Michaels suggestion for checking for GT 1901 and =
otherwise=20
displaying a variable of ' / / '.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The table fits the page horizontally =
but I may want=20
to change to a font style that is smaller in height so I can fit more =
rows=20
comfortably. That was one of the advantages of CFGrid. I tried TR =
Height=3D??. 100=20
works but 2 doesn't. That is I can increase the row height but not =
reduce=20
it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>So I'm back to where I started out =
weeks ago;=20
trying to displaying the policy data in a table. Successfully now =
- thanks=20
to you all, albiet Table instead of CFTable. And I expect =
to deliver the=20
app Monday. Thanks again for your concern and suggestions. Have a =
nice=20
weekend. I'm going to get a tall drink.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Paige</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0028_01BFE84F.B1E887D0--
------------------------------------------------------------------------------
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.
