Re: separate by mont (search)
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 46447
interpreted = N
texte = It's quite easy. The key is that the legend that displays the month and year shouldn't be built from the data, but from static data generated in a loop. The search then does a greater than or equal month/1/year and less than month+1/1/year(possibly+1). In order to do both conditions on the same field, use th GROUP option in searching.>1. In a database I have one of the entries as a date in this format>mm/dd/yyyy.>2. This datebase has been growing for about 2 years, now is kind of hard>to view the info because of the number of records>3. The customer wants to be able to display information by month>4. A search should display the months ie: Jan, Feb, Mar, Apr, etc..>5. When clicking on a specific month it another search should display>the records for that month.>6. Do you guys think this is possible?>7. How?>>>ART>>>------------------------------------------------------------->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://webdna.smithmicro.com/-- --------------------------------- John A. Hill Oak Hill SoftwareWebsite Development/Consulting john@oakhillsoftware.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
It's quite easy. The key is that the legend that displays the month and year shouldn't be built from the data, but from static data generated in a loop. The search then does a greater than or equal month/1/year and less than month+1/1/year(possibly+1). In order to do both conditions on the same field, use th GROUP option in searching.>1. In a database I have one of the entries as a date in this format>mm/dd/yyyy.>2. This datebase has been growing for about 2 years, now is kind of hard>to view the info because of the number of records>3. The customer wants to be able to display information by month>4. A search should display the months ie: Jan, Feb, Mar, Apr, etc..>5. When clicking on a specific month it another search should display>the records for that month.>6. Do you guys think this is possible?>7. How?>>>ART>>>------------------------------------------------------------->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://webdna.smithmicro.com/-- --------------------------------- John A. Hill Oak Hill SoftwareWebsite Development/Consulting john@oakhillsoftware.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://webdna.smithmicro.com/
John Hill
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:
WCS Newbie question (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Separate SSL Server (1997)
Page Breaks in Word (2003)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Linebreak as a delimiter in listwords? (2003)
Date sorting (1997)
Re1000001: Setting up shop (1997)
Help!!!! (1997)
M$loth messes with our sites (again) 2004/02/03 (2004)
Spell Check (2000)
More on the email templates (1997)
is this how [break] works? (1998)
Auto SKU's (2000)
customers order (1999)
If Empty ? (1997)
Three new problems ... (1997)
[WebDNA] Needing a new host.... (2013)
SiteGuard Admin Feature ? (1997)
Max Record length restated as maybe bug (1997)