Dave B
|
| Posted: 07/29/2003, 9:11 PM |
|
As a rookie with CCS I would be interested in feedback from users on how
they would tackle ( in general terms) a piece of code to obtain the output
in the attached file.
I would normally tackle it along the very general lines like
startinput
endinput
foreach item qualified by input
foreach day from startinput to endinput
select item startdate finishdate
if day is between startdate finishdate
print red
else print white
next
--
---------------------------------------------------------------
Dave
Life goes on ...and on ...and on
begin 666 example.html
M/"%$3T-465!%($A434P@4%5"3$E#("(M+R]7,T,O+T141"!(5$U,(#0N,"!4
M<F%N<VET:6]N86PO+T5.(CX-"CQH=&UL/@T*/"$M+2 @0W)E871E9"!W:71H
M('1H92!#;V9F965#=7 @2%1-3"!%9&ET;W(@("TM/@T*/"$M+2 @(" @(" @
M:'1T<#HO+W=W=RYC;V9F965C=7 N8V]M+R @(" @(" @("TM/@T*/"$M+2 @
M(" @("!"<F5W960@;VX@,S O,#<O,#,@,#0Z,3,Z,# @(" @(" @("TM/@T*
M/&AE860^#0H@(#QT:71L93X\+W1I=&QE/@T*/"]H96%D/@T*/&)O9'D^#0I5
M<V5R(')E<75E<W1S(&$@<F5P;W)T(&9R;VT@82!I;G!U=" A#0H\(2TM(%-T
M87)T(&]F($9/4DT@+2T^#0H\9F]R;2!M971H;V0](E!/4U0B(&%C=&EO;CTB
M(CX-"CQI;G!U="!T>7!E/2)T97AT(B!N86UE/2(B('9A;'5E/2)3=&%R="!$
M871E(CX\8G(^#0H\:6YP=70@='EP93TB=&5X="(@;F%M93TB(B!V86QU93TB
M16YD($1A=&4B/CQB<CX-"CQI;G!U="!T>7!E/2)T97AT(B!N86UE/2(B('-I
M>F4@/3,P('9A;'5E/2)/<'1I;VYA;"!1=6%L:69I97(@9F]R($E414TB/CQB
M<CX-"CQI;G!U="!T>7!E/2)S=6)M:70B/@T*/"]F;W)M/@T*/"$M+2!%;F0@
M;V8@1D]232 M+3X-"@T*/&)R/@T*/&AR/@T*#0I297-U;'1S('1O(&)E('-H
M;W=N(&EN('1H92!F;W)M870@;&EK92!T:&ES( T*#0H\8G(^#0H\8G(^#0H-
M"CQT86)L92!B;W)D97(](C$B("!W:61T:#TB,C P(CX-"B @/'1R/CPA+2T@
M4F]W(#$@+2T^#0H@(" @(#QT9#Y)5$5-/"]T9#X\(2TM($-O;" Q("TM/@T*
M(" @(" \=&0^36]N(#(Q/"]T9#X\(2TM($-O;" R("TM/@T*(" @(" \=&0^
M5'5E(#(R/"]T9#X\(2TM($-O;" S("TM/@T*(" @(" \=&0^5V5D(#(S/"]T
M9#X\(2TM($-O;" T("TM/@T*(" @(" \=&0^5&AU<B R-#PO=&0^/"$M+2!#
M;VP@-2 M+3X-"B @(" @/'1D/D9R:2 R-3PO=&0^/"$M+2!#;VP@-B M+3X-
M"B @(" @/'1D/E-A=" R-CPO=&0^/"$M+2!#;VP@-R M+3X-"B @/"]T<CX-
M"B @/'1R/CPA+2T@4F]W(#(@+2T^#0H@(" @(#QT9#Y4:&EN9S$\+W1D/CPA
M+2T@0V]L(#$@+2T^#0H@(" @(#QT9#XF;F)S<#L\+W1D/CPA+2T@0V]L(#(@
M+2T^#0H@(" @(#QT9#XF;F)S<#L\+W1D/CPA+2T@0V]L(#,@+2T^#0H@(" @
M(#QT9"!B9V-O;&]R/2(C1D8P,# P(CXF;F)S<#L\+W1D/CPA+2T@0V]L(#0@
M+2T^#0H@(" @(#QT9"!B9V-O;&]R/2(C1D8P,# P(CXF;F)S<#L\+W1D/CPA
M+2T@0V]L(#4@+2T^#0H@(" @(#QT9#XF;F)S<#L\+W1D/CPA+2T@0V]L(#8@
M+2T^#0H@(" @(#QT9#XF;F)S<#L\+W1D/CPA+2T@0V]L(#<@+2T^#0H@(#PO
M='(^#0H@(#QT<CX\(2TM(%)O=R S("TM/@T*(" @(" \=&0^5&AI;F<R/"]T
M9#X\(2TM($-O;" Q("TM/@T*(" @(" \=&0^)FYB<W [/"]T9#X\(2TM($-O
M;" R("TM/@T*(" @(" \=&0@8F=C;VQO<CTB(T9&,# P,"(^)FYB<W [/"]T
M9#X\(2TM($-O;" S("TM/@T*(" @(" \=&0@8F=C;VQO<CTB(T9&,# P,"(^
M)FYB<W [/"]T9#X\(2TM($-O;" T("TM/@T*(" @(" \=&0@8F=C;VQO<CTB
M(T9&,# P,"(^)FYB<W [/"]T9#X\(2TM($-O;" U("TM/@T*(" @(" \=&0^
M)FYB<W [/"]T9#X\(2TM($-O;" V("TM/@T*(" @(" \=&0^)FYB<W [/"]T
M9#X\(2TM($-O;" W("TM/@T*(" \+W1R/@T*/"]T86)L93X-"@T*#0H-"CPO
28F]D>3X-"CPO:'1M;#X-"@T*
`
end
|
|
|
 |
Robert Sorrells
|
| Posted: 07/30/2003, 4:30 PM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0102_01C356C8.FE8FA2E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi David,=20
I'm a rookie at CCS also, so here's how I'd attack the problem. CCS's =
strength is rapidly generating a search / table, and a maintenance form =
with authentication. To me, this problem seems to be a little outside =
the scope of CCS, but here's how I'd approach it. =20
I'd go to http://www.asp101.com/samples/calendar.asp (or a php =
equivalent site) and use that to generate the calendar matrix. Then =
I'd insert a CCDLookup in the code in the calendar table to lookup =
values from the database, and color the rectangles if a value is =
present. Your 3 query values could be inputted into the SQL statement =
by a request.form("startdate"), etc, since it looks as if you're using a =
form.
I'm not sure how to get all of the data-aware code that CCDLookup would =
need in the blank form. Maybe some others could comment.=20
See ya,
Bob
"Dave B" <david@procyberscripts.com> wrote in message =
news:bg7gid$jik$1@news.codecharge.com...
As a rookie with CCS I would be interested in feedback from users on =
how
they would tackle ( in general terms) a piece of code to obtain the =
output
in the attached file.
I would normally tackle it along the very general lines like
startinput
endinput
foreach item qualified by input
foreach day from startinput to endinput
select item startdate finishdate
if day is between startdate finishdate
print red
else print white
next
--=20
---------------------------------------------------------------
Dave
Life goes on ...and on ...and on
------=_NextPart_000_0102_01C356C8.FE8FA2E0
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 http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi David, </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm a rookie at CCS also, so here's how =
I'd attack=20
the problem. CCS's strength is rapidly generating a =
search /=20
table, and a maintenance form with =
authentication. To me,=20
this problem seems to be a little outside the scope of CCS, but =
here's how=20
I'd approach it. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial =
size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'd go to </FONT><FONT face=3DArial =
size=3D2><A=20
href=3D"http://www.asp101.com/samples/calendar.asp">http://www.asp101.com=
/samples/calendar.asp</A> (or=20
a php equivalent site) and use that to generate the calendar =
matrix. =20
Then I'd insert a CCDLookup in the code in the calendar table to=20
lookup values from the database, and color the rectangles if a =
value is=20
present. </FONT><FONT face=3DArial size=3D2>Your 3 query =
values could be=20
inputted into the SQL statement by a request.form("startdate"), =
etc, since=20
it looks as if you're using a form.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm not sure how to get all of the =
data-aware code=20
that CCDLookup would need in the blank form. Maybe some others =
could=20
comment. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial =
size=3D2></FONT><FONT=20
face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>See ya,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Bob</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Dave B" <<A=20
=
href=3D"mailto:david@procyberscripts.com">david@procyberscripts.com</A>&g=
t;=20
wrote in message <A=20
=
href=3D"news:bg7gid$jik$1@news.codecharge.com">news:bg7gid$jik$1@news.cod=
echarge.com</A>...</DIV>As=20
a rookie with CCS I would be interested in feedback from users on =
how<BR>they=20
would tackle ( in general terms) a piece of code to obtain the =20
output<BR>in the attached file.<BR><BR>I would normally tackle =
it along=20
the very general lines like<BR>startinput<BR>endinput<BR><BR>foreach =
item=20
qualified by input<BR><BR>foreach day from startinput to=20
endinput<BR><BR>select item startdate finishdate<BR><BR>if day =
is=20
between startdate finishdate<BR><BR>print red<BR><BR>else print=20
white<BR><BR>next<BR><BR><BR><BR><BR><BR>--=20
=
<BR>---------------------------------------------------------------<BR><B=
R>Dave<BR><BR>Life=20
goes on ...and on ...and on<BR><BR><BR></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0102_01C356C8.FE8FA2E0--
|
|
|
|
Dave B
|
| Posted: 07/30/2003, 6:10 PM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0014_01C35708.C0AB1BE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Robert
Thanks for your input.
I would agree on the strengths of CCS in the areas you state.
I shall certainly code all the data entry update etc with CCS
I was planning on creating a seperate script to produce the reports but =
thought I might just ask if this sort of thing was possible to be coded =
with CCS out of interest especially as the program has so many features =
to learn. I thought I might get insight on the more advanced features by =
opening this discussion.
Thanks again
Dave
--=20
---------------------------------------------------------------
Dave=20
Life goes on ...and on ...and on
"Robert Sorrells" <rsorrellsU@KNOWmindspring.com> wrote in message =
news:bg9kfi$ha1$1@news.codecharge.com...
Hi David,=20
I'm a rookie at CCS also, so here's how I'd attack the problem. =
CCS's strength is rapidly generating a search / table, and a maintenance =
form with authentication. To me, this problem seems to be a little =
outside the scope of CCS, but here's how I'd approach it. =20
I'd go to http://www.asp101.com/samples/calendar.asp (or a php =
equivalent site) and use that to generate the calendar matrix. Then =
I'd insert a CCDLookup in the code in the calendar table to lookup =
values from the database, and color the rectangles if a value is =
present. Your 3 query values could be inputted into the SQL statement =
by a request.form("startdate"), etc, since it looks as if you're using a =
form.
I'm not sure how to get all of the data-aware code that CCDLookup =
would need in the blank form. Maybe some others could comment.=20
See ya,
Bob
"Dave B" <david@procyberscripts.com> wrote in message =
news:bg7gid$jik$1@news.codecharge.com...
As a rookie with CCS I would be interested in feedback from users on =
how
they would tackle ( in general terms) a piece of code to obtain the =
output
in the attached file.
I would normally tackle it along the very general lines like
startinput
endinput
foreach item qualified by input
foreach day from startinput to endinput
select item startdate finishdate
if day is between startdate finishdate
print red
else print white
next
--=20
---------------------------------------------------------------
Dave
Life goes on ...and on ...and on
------=_NextPart_000_0014_01C35708.C0AB1BE0
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 http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi Robert</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks for your input.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I would agree on the strengths of CCS in =
the areas you=20
state.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I shall certainly code all the data entry update etc =
with=20
CCS</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I was planning on creating a seperate script to =
produce the=20
reports but thought I might just ask if this sort of thing was possible =
to be=20
coded with CCS out of interest especially as the program has so =
many=20
features to learn. I thought I might get insight on the more =
advanced=20
features by opening this discussion.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks again</FONT></DIV>
<DIV><FONT size=3D2>Dave</FONT></DIV>
<DIV><BR>--=20
<BR>---------------------------------------------------------------</DIV>=
<DIV> </DIV>
<DIV>Dave </DIV>
<DIV> </DIV>
<DIV>Life goes on ...and on ...and on</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Robert Sorrells" <<A=20
=
href=3D"mailto:rsorrellsU@KNOWmindspring.com">rsorrellsU@KNOWmindspring.c=
om</A>>=20
wrote in message <A=20
=
href=3D"news:bg9kfi$ha1$1@news.codecharge.com">news:bg9kfi$ha1$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi David, </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm a rookie at CCS also, so here's =
how I'd=20
attack the problem. CCS's strength is rapidly =
generating a=20
search / table, and a maintenance form with=20
authentication. To me, this problem seems =
to be a=20
little outside the scope of CCS, but here's how I'd approach it. =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial=20
size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'd go to </FONT><FONT face=3DArial =
size=3D2><A=20
=
href=3D"http://www.asp101.com/samples/calendar.asp">http://www.asp101.com=
/samples/calendar.asp</A> (or=20
a php equivalent site) and use that to generate the calendar=20
matrix. Then I'd insert a CCDLookup in the code in the =
calendar=20
table to lookup values from the database, and color the =
rectangles if a=20
value is present. </FONT><FONT face=3DArial size=3D2>Your =
3 query=20
values could be inputted into the SQL statement by=20
a request.form("startdate"), etc, since it looks as if you're =
using a=20
form.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm not sure how to get all of the =
data-aware=20
code that CCDLookup would need in the blank form. Maybe some =
others=20
could comment. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial =
size=3D2></FONT><FONT=20
face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>See ya,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Bob</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Dave B" <<A=20
=
href=3D"mailto:david@procyberscripts.com">david@procyberscripts.com</A>&g=
t;=20
wrote in message <A=20
=
href=3D"news:bg7gid$jik$1@news.codecharge.com">news:bg7gid$jik$1@news.cod=
echarge.com</A>...</DIV>As=20
a rookie with CCS I would be interested in feedback from users on=20
how<BR>they would tackle ( in general terms) a piece of code to =
obtain=20
the output<BR>in the attached file.<BR><BR>I would normally=20
tackle it along the very general lines=20
like<BR>startinput<BR>endinput<BR><BR>foreach item qualified by=20
input<BR><BR>foreach day from startinput to endinput<BR><BR>select=20
item startdate finishdate<BR><BR>if day is between startdate=20
finishdate<BR><BR>print red<BR><BR>else print=20
white<BR><BR>next<BR><BR><BR><BR><BR><BR>--=20
=
<BR>---------------------------------------------------------------<BR><B=
R>Dave<BR><BR>Life=20
goes on ...and on ...and =
on<BR><BR><BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0014_01C35708.C0AB1BE0--
|
|
|
|
|
