Re: oddball sorting problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 55050
interpreted = N
texte = I put group1field in because I want to have the entry show up if date2 is valid and date1 is past. But not all records will have a date2. So combining them into one field was the only way it worked. You can't require date2, or even date1 (if date 2 would be valid). Not requiring either returns all the records, because another requirement in the search allows all but one of the records (I could probably lose that though). Terry >If you have field names of date1 and date2, then you don't need to use >group1field. That's only if you want to use separate search parameters on >the same field. > >Regards, >Tim >-- >Tim Robinson >IDFK Web Developments >tim@idfk.com.au >114a/40 Yeo Street >Neutral Bay 2089 >Australia >Phone +612 9908 2134 >Fax +612 9908 4837 > >> From: Terry Wilson
>> Reply-To: (WebDNA Talk) >> Date: Wed, 17 Dec 2003 23:22:00 -0500 >> To: (WebDNA Talk) >> Subject: oddball sorting problem >> >> I have this: >> >> [search >> >>...group1field=date1+date2&group1type=date&gegroup1datarq=[date]&date1type=dat >> e&date1sort=1] ------------------------------------------------------------- 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:
I put group1field in because I want to have the entry show up if date2 is valid and date1 is past. But not all records will have a date2. So combining them into one field was the only way it worked. You can't require date2, or even date1 (if date 2 would be valid). Not requiring either returns all the records, because another requirement in the search allows all but one of the records (I could probably lose that though). Terry >If you have field names of date1 and date2, then you don't need to use >group1field. That's only if you want to use separate search parameters on >the same field. > >Regards, >Tim >-- >Tim Robinson >IDFK Web Developments >tim@idfk.com.au >114a/40 Yeo Street >Neutral Bay 2089 >Australia >Phone +612 9908 2134 >Fax +612 9908 4837 > >> From: Terry Wilson >> Reply-To: (WebDNA Talk) >> Date: Wed, 17 Dec 2003 23:22:00 -0500 >> To: (WebDNA Talk) >> Subject: oddball sorting problem >> >> I have this: >> >> [search >> >>...group1field=date1+date2&group1type=date&gegroup1datarq=[date]&date1type=dat >> e&date1sort=1] ------------------------------------------------------------- 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/
Terry Wilson
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:
Last Minute addition to WildWebCAT98... (1999)
WC1.6 to WC2 date formatting (1997)
[OT] test (2002)
form data submission gets truncated (1997)
Help formatting search results w/ table (1997)
why .HTML pages no processing? - More Info2 (2000)
OH MY GOD! (1998)
Leap Day Triggers? -confirmation- (2000)
Credit Card Verification.... (1998)
2.0 Info (1997)
[WriteFile] problems (1997)
exclusive db lock with webcat-3 ? (2000)
Locking up with WebCatalog... (1997)
Caching problem... (2000)
Hiding URL ? (1998)
verify email address (1998)
Multiple products Multiple price (2000)
[BULK] [WebDNA] Clean URLS job - will pay (2010)
RE: Unexceling (was I need a smart quote...) (1999)
Comments in db? (1997)