On-Call Calendar - Query of Query stumpage

2004-01-29 Thread Candace Cottrell
Hey folks, I am officially stumped. I am still working on this on-call calendar. Here's what I am trying to accomplish: If the day (number) is the first day of the shift and the shift start hour is not equal to 8, then I'd like to output ON: 7AM under the doctor's name. Likewise, if

Re: On-Call Calendar - Query of Query stumpage

2004-01-29 Thread Jochem van Dieten
Candace Cottrell said: cfloop from=1 to=#rows# index=i tr height=15% cfloop from=1 to=7 index=j td align=left valign=top cfif #page[j][i]# is -1 nbsp; cfelse !-- Outputting the DAY number-- h2cfoutput#page[j][i]#/cfoutput /h2 span class=bodyCopy cfquery name=getByDay

Re: On-Call Calendar - Query of Query stumpage

2004-01-29 Thread Candace Cottrell
Ok, it worked so was there a problem with my cfif's? I see that you combined them into one. Jochem, thanks, as always, for your help. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org

Re: On-Call Calendar - Query of Query stumpage

2004-01-29 Thread Jochem van Dieten
Candace Cottrell said: Ok, it worked so was there a problem with my cfif's? Apparently ;-) It just seemed easier to replace the QofQ's with simple comparisons. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]