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:
Typo in the Online Docs ... (1997)
Where's 3.0 Online Docs? (1999)
Displaying text and populating form fields (2005)
Alternating colors (1997)
access denied problem (1997)
Browser Info.txt (1997)
WC2.0 Memory Requirements (1997)
AND/OR searches in WebCat 3.07 (2003)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
OT - help.. (2003)
Ok here is a question? (1997)
Help name our technology! I found it (1997)
Hello??? (1997)
[isfolder] and [filename] (1997)
replacing items in a db (2000)
Server Freeze (1998)
WC2b15 File Corruption (1997)
BinaryBody problem ...... (2003)
Ok here is a question? (1997)