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:
[LOOKUP] (1997)
RE: Re:Signal Raised (1997)
UPDATE PROBLEM (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
NetSplat and WebCat2 (1997)
OT: CT Scan might have saved my life!! (2006)
[isfile] ? (1997)
subtotal (2000)
[HIDEIF] inside [FOUNDITEM] (1997)
For Grant: Webcatalog 4.0 - When will we be able to betatest it? (2000)
ShowNext - This is Killing me! (1998)
Frames and WebCat (1997)
pc (1997)
[WebDNA] An actual attempt to get WebDNA and MAMP Pro to work - assistance (2018)
Can webcat 3.0/4.0 handle 1,000,000 hits a day? (2000)
& in Lookups (1997)
X etc.... (1999)
Formating found categories (1997)
So what ya working on? (or have you completed?) (2004)
[WebDNA] Microsoft Server 2008 installation.... so close (2011)