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:
New commands in Final candidate (1997)
Exclamation point (1997)
PCS Emailer's role ? (1997)
View order not right (1997)
[NT] ie 4.0 required (1997)
Help on how to store calculated value (2002)
Snake Bites (1997)
show all problem (1997)
Sort & Shownext (1999)
Limitations on fields? Server is crashing (1997)
RE: Upload (1998)
Search in 2 or more catalogs (1997)
OT - SE robot question (2003)
WebCat 2.1beta etc (1997)
Multiple Replaces (1997)
Bug Report, maybe (1997)
RE: Languages (1997)
Multiple prices (1997)
problem with text A (2000)
process out of control....... (2002)