Re: separate by mont (search)

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 46449
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?> >Why not use the range comparison in the search?rnTheDateFielddatarq=1/1/2002 1/31/2002This should get you every record with a date in January.-- Sam LewisSamLewis.comTel: 626-852-0956 Fax: 916-404-5698-------------------------------------------------------------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:

Re: separate by mont (search) (John Hill 2002) Re: separate by mont (search) (Sam Lewis 2002) Re: separate by mont (search) (Kenneth Grome 2002) Re: separate by mont (search) (John Hill 2002) separate by mont (search) (Arturo Vargas 2002)

>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?> >Why not use the range comparison in the search?rnTheDateFielddatarq=1/1/2002 1/31/2002This should get you every record with a date in January.-- Sam LewisSamLewis.comTel: 626-852-0956 Fax: 916-404-5698-------------------------------------------------------------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/ Sam Lewis

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:

Public Beta for WebCatalog 4.0 is Available (2000) select multiple 2 more cents (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Unauthorized User trouble (1998) 'does not contain' operator needed ... (1997) emails sent twice (2001) WebCat2b12 forgets serial # (1997) syntax question, not in online refernce (1997) search for non-unique question (2001) shipCost (1998) W* 4.2 / WebCat (TPro) 3.0.5b / OS 8.5.1 / BW G3 (2000) [ot] ShowIf & HideIf Question (1998) [ModDate] & [ModTime] ? (1997) Checking for blank form fields 2nd idea (1998) OBDC Support (1997) unable to launch acgi in WebCat (1997) Taget _top (2000) emailer setup (1997) Modifying order output (1997) Multiple Merchant Accounts? (1997)