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:

WebCatalog 2.0 b 15 mac (1997) Purchase Plugin Missing (1996) [math] are you there? (1999) Negative number search (2000) ssl support WDNA 5.0 (2003) Site Builder & IE Mac (2004) [WebDNA] Fix your browser settings (2017) [convertchars] (2000) Error Lob.db records error message not name (1997) RAM variables (1997) Format Thousands Looks Busted (2000) Re[2]: 2nd WebCatalog2 Feature Request (1996) Single Link browsing (1997) No spaces allowed in text variable names ... ? (2002) Getting total number of items ordered (1997) question: webmerchant connection (1997) Moving a record from one dataabse to another. (2000) [ot] G5 Desktop as Server (2004) OLD ORDERS (1998) [WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010)