Re: Search a date field by month only...
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24352
interpreted = N
texte = Thanks I figured it would be better to seperate the fields... Faster searching!-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Kenneth Grome Sent: Saturday, November 13, 1999 7:31 PM To: WebCatalog Talk Subject: Re: Search a date field by month only... >I want to be able to search a date field by either the month or year. Do I >have to have independent fields for month & year?Normall it's best to use separate fields for month and year, but if you would be satisfied to retrieve all records while displaying only the ones for certain months and years, you can put a couple of [showif] contexts inside your founditems context like this:[founditems] [showif [getchars start=7&end=10][eventdate][/getchars]=1999] [showif [getchars start=1&end=2][eventdate][/getchars]=11] fields to display here [/showif] [/showif] [/founditems]If your search context retrieves all records in the db, this example will display only those records in the month of November 1999, assuming your dates are stored in the default mm/dd/yyyy format. If your dates are stored in another format, simply adjust the start and end values in the getchars contexts appropriately ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
Thanks I figured it would be better to seperate the fields... Faster searching!-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Kenneth Grome Sent: Saturday, November 13, 1999 7:31 PM To: WebCatalog Talk Subject: Re: Search a date field by month only... >I want to be able to search a date field by either the month or year. Do I >have to have independent fields for month & year?Normall it's best to use separate fields for month and year, but if you would be satisfied to retrieve all records while displaying only the ones for certain months and years, you can put a couple of [showif] contexts inside your founditems context like this:[founditems] [showif [getchars start=7&end=10][eventdate][/getchars]=1999] [showif [getchars start=1&end=2][eventdate][/getchars]=11] fields to display here [/showif] [/showif] [/founditems]If your search context retrieves all records in the db, this example will display only those records in the month of November 1999, assuming your dates are stored in the default mm/dd/yyyy format. If your dates are stored in another format, simply adjust the start and end values in the getchars contexts appropriately ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Vince Medina
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:
Location of Browser Info.txt file (1997)
Directory Overload (1998)
writing orders to a db (1997)
[WebDNA] WebDNA version 6.2 to install on 64 bit CentOS 5 server? (2015)
Setting up the server (1997)
No Data Results (1997)
File Upload (1997)
[WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (2012)
WebCat2 beta 11 - new prefs ... (1997)
WebCat2 Append problem (B14Macacgi) (1997)
payflowpro problem #3 (2003)
What date is it anyway? (2004)
Quit revisited (1997)
more ! testing (1997)
Protect Tage and Groups (1998)
Windows XP and cookies (2004)
emailer (1997)
Alpha List for Catagory (1998)
Windows nt service pack 3 upgrade (1997)
multiple search commands (1997)