Re: Solve the Problem, get the code!

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37789
interpreted = N
texte = Sorry Charles Kline solved the problem and got the code.Jeff Logan >On 8/7/01 1:07 PM, Jeff Logan wrote: > >>>> [showif 6=[lookup >>>> db=days.db&lookinfield=number&value=[math]({[the_month]/[index]/[the_y >>>> ear]})%7[/math]&returnfield=skip¬found=Day]][/showif] >>>> [/loop] >>>> >>>> So inserting a space does not make the extra cell's show up. The >>>> just don't show up because know code is written for them. >>> > >Without writing the code here is a logic that I think will work for you. > >(show if the index is greater than the number of days in the month (which >you used a lookup to do earlier)) > If it is greater than the total days (and it will be the 1st cell after >the end) then check to see if: > >[showif 6=[lookup >db=days.db&lookinfield=number&value=[math]({[the_month]/[index]/[the_y >ear]})%7[/math]&returnfield=skip¬found=Day]] > >[/showif] >[/loop] > >If not insert a cell with spaces... And perform this check again. > ========== >What will happen? >The code will check to see if the cell is > the total number of days in >month. > Yes it is greater: > Check index to see if %6 > If that is then > If not create with space > No not greater: > as usual. > >This logic should work beautifully. >Let me know if you need hacking any of the showif codes. > >Alex > >Alex J McCombie New World Media >Chief Information Officer Drawer 607 >800/724.8973 Fair Haven, NY 13064 >Alex@NewWorldMedia.com http://OurClients.com > >Interface Designer WebDNA Programmer Database Designer > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Solve the Problem, get the code! (Jeff Logan 2001)
  2. Re: Solve the Problem, get the code! (Marc Kaiwi 2001)
  3. Re: Solve the Problem, get the code! (Marc Kaiwi 2001)
  4. Re: Solve the Problem, get the code! (Alex McCombie 2001)
  5. Re: Solve the Problem, get the code! (Jeff Logan 2001)
  6. Re: Solve the Problem, get the code! (Alex McCombie 2001)
  7. Re: Solve the Problem, get the code! (Stuart Tremain 2001)
  8. Re: Solve the Problem, get the code! (Jeff Logan 2001)
  9. Re: Solve the Problem, get the code! (Daniel Smith 2001)
  10. Re: Solve the Problem, get the code! (Jeff Logan 2001)
  11. Re: Solve the Problem, get the code! (Dale Therio 2001)
  12. Re: Solve the Problem, get the code! (Marc Kaiwi 2001)
  13. Re: Solve the Problem, get the code! (Jeff Logan 2001)
  14. Re: Solve the Problem, get the code! (Anne Varner 2001)
  15. Re: Solve the Problem, get the code! (Brian Fries 2001)
  16. Re: Solve the Problem, get the code! (Celeste Paul 2001)
  17. Re: Solve the Problem, get the code! (Tom Duke 2001)
  18. Re: Solve the Problem, get the code! (Jeff Logan 2001)
  19. Re: Solve the Problem, get the code! (Jeff Logan 2001)
  20. Re: Solve the Problem, get the code! (Marc Kaiwi 2001)
  21. Re: Solve the Problem, get the code! (adam@inos.com (O'Connor, Adam) 2001)
  22. Re: Solve the Problem, get the code! (adam@inos.com (O'Connor, Adam) 2001)
  23. Re: Solve the Problem, get the code! (Marc Kaiwi 2001)
  24. Solve the Problem, get the code! (Jeff Logan 2001)
Sorry Charles Kline solved the problem and got the code.Jeff Logan >On 8/7/01 1:07 PM, Jeff Logan wrote: > >>>> [showif 6=[lookup >>>> db=days.db&lookinfield=number&value=[math]({[the_month]/[index]/[the_y >>>> ear]})%7[/math]&returnfield=skip¬found=Day]][/showif] >>>> [/loop] >>>> >>>> So inserting a space does not make the extra cell's show up. The >>>> just don't show up because know code is written for them. >>> > >Without writing the code here is a logic that I think will work for you. > >(show if the index is greater than the number of days in the month (which >you used a lookup to do earlier)) > If it is greater than the total days (and it will be the 1st cell after >the end) then check to see if: > >[showif 6=[lookup >db=days.db&lookinfield=number&value=[math]({[the_month]/[index]/[the_y >ear]})%7[/math]&returnfield=skip¬found=Day]] > >[/showif] >[/loop] > >If not insert a cell with spaces... And perform this check again. > ========== >What will happen? >The code will check to see if the cell is > the total number of days in >month. > Yes it is greater: > Check index to see if %6 > If that is then > If not create with space > No not greater: > as usual. > >This logic should work beautifully. >Let me know if you need hacking any of the showif codes. > >Alex > >Alex J McCombie New World Media >Chief Information Officer Drawer 607 >800/724.8973 Fair Haven, NY 13064 >Alex@NewWorldMedia.com http://OurClients.com > >Interface Designer WebDNA Programmer Database Designer > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Jeff Logan

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[WebDNA] Problem with SendMail - seems succesfull but nothing to (2016) Replacing entry (1998) Multiple prices (1997) Question about replacing words (1998) WebCat2 Append problem (B14Macacgi) (1997) Location of Webcat site in folder hierarchy (1997) Tax & Shipping (1997) form data submission gets truncated (1997) Sorry WebDNA server not running (2002) read and write you own cookies with webcat (1997) Sending E-mail (1997) WC Database Format (1997) Grep Help (2003) Cold Fusion Warm and Fuzzy? (1999) [isfile] ? (1997) NT - Thanks and Taxes (1997) ups quickcost [repost] (1999) Problems when user hit back (2000) WebCatb15 Mac CGI -- [purchase] (1997) WebCatalog can't find database (1997)