RE: [WebDNA] Sorting -- Dealing with Blanks
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100319
interpreted = N
texte = This is a multipart message in MIME format.------=_NextPart_000_0452_01C8E738.6BB5F1D0Content-Type: text/plain;charset="windows-1250"Content-Transfer-Encoding: quoted-printableYes, they do. The thing is, there will be other fields showing as well =so Ican=92t rule out all blanks in just one field (the others may contain =info).When sorting on one field, I just wanted all blanks specific to it to bepushed to the bottom. I think the only way I can do that is by using ashowif/hidief.=20Thanks,=20Tana=20From: Gary Krockover [mailto:gary@garykrockover.com]=20Sent: Wednesday, July 16, 2008 11:36 AMTo: talk@webdna.usSubject: Re: [WebDNA] Sorting -- Dealing with Blanks=20Does your blank record have a SKU number or some other form of indexing(with blank data thereafter)? If so, the blank records should show as =youexpect with a normal search query.Example, go to HYPERLINK"http://www.garykrockover.com/dbquickview/dbquickview.html"http://www.gar=ykrockover.com/dbquickview/dbquickview.html select the "parts.db" database =andthen run this query:[search db=3Dparts.db&neskudatarq=3D[blank]&dedescriptionsort=3D1]GJKAt 01:10 PM 7/16/2008, you wrote:Hi,=20Does anyone know of a way to show all blank records for a particular =fieldat the bottom when using the sort feature? For example, I want to be =ableto sort a field, in either ascending or descending order, and always =showany blank records for that particular field at the bottom. I know I can =usea showif/hideif but I was wondering if there was actually a command for =thatthat I=92m missing within the sort feature itself.=20Thanks,=20Tana=20No virus found in this incoming message.Checked by AVG.Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/20086:43 AMNo virus found in this outgoing message.Checked by AVG.=20Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/20086:43 AM=20------=_NextPart_000_0452_01C8E738.6BB5F1D0Content-Type: text/html;charset="windows-1250"Content-Transfer-Encoding: quoted-printable
Yes, they do. The thing is, there will be other =fields showingas well so I can’t rule out all blanks in just one field (the =others maycontain info). When sorting on one field, I just wanted all blanks =specific toit to be pushed to the bottom. I think the only way I can do that =is by usinga showif/hidief.
Thanks,
Tana
From:= Gary =Krockover[mailto:gary@garykrockover.com]
Sent: Wednesday, July 16, 2008 11:36 AM
To: talk@webdna.us
Subject: Re: [WebDNA] Sorting -- Dealing with =Blanks
Does your blank record have a SKU number or some =other formof indexing (with blank data thereafter)? If so, the blank records =shouldshow as you expect with a normal search query.
Example, go to http:/=/www.garykrockover.com/dbquickview/dbquickview.htmlselect the "parts.db" database and then run this query:
[search =db=3Dparts.db&neskudatarq=3D[blank]&dedescriptionsort=3D1]
GJK
At 01:10 PM 7/16/2008, you wrote:
Hi,
Does anyone know of a way to show all blank records for a particular =field atthe bottom when using the sort feature? For example, I want to be =able tosort a field, in either ascending or descending order, and always show =anyblank records for that particular field at the bottom. I know I =can use ashowif/hideif but I was wondering if there was actually a command for =that thatI’m missing within the sort feature itself.
Thanks,
Tana
No virus found in this incoming =message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/2008 6:43AM
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/2008 6:43 AM
------=_NextPart_000_0452_01C8E738.6BB5F1D0--
Associated Messages, from the most recent to the oldest:
This is a multipart message in MIME format.------=_NextPart_000_0452_01C8E738.6BB5F1D0Content-Type: text/plain;charset="windows-1250"Content-Transfer-Encoding: quoted-printableYes, they do. The thing is, there will be other fields showing as well =so Ican=92t rule out all blanks in just one field (the others may contain =info).When sorting on one field, I just wanted all blanks specific to it to bepushed to the bottom. I think the only way I can do that is by using ashowif/hidief.=20Thanks,=20Tana=20From: Gary Krockover [mailto:gary@garykrockover.com]=20Sent: Wednesday, July 16, 2008 11:36 AMTo: talk@webdna.usSubject: Re: [WebDNA] Sorting -- Dealing with Blanks=20Does your blank record have a SKU number or some other form of indexing(with blank data thereafter)? If so, the blank records should show as =youexpect with a normal search query.Example, go to HYPERLINK"http://www.garykrockover.com/dbquickview/dbquickview.html"http://www.gar=ykrockover.com/dbquickview/dbquickview.html select the "parts.db" database =andthen run this query:[search db=3Dparts.db&neskudatarq=3D[blank]&dedescriptionsort=3D1]GJKAt 01:10 PM 7/16/2008, you wrote:Hi,=20Does anyone know of a way to show all blank records for a particular =fieldat the bottom when using the sort feature? For example, I want to be =ableto sort a field, in either ascending or descending order, and always =showany blank records for that particular field at the bottom. I know I can =usea showif/hideif but I was wondering if there was actually a command for =thatthat I=92m missing within the sort feature itself.=20Thanks,=20Tana=20No virus found in this incoming message.Checked by AVG.Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/20086:43 AMNo virus found in this outgoing message.Checked by AVG.=20Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/20086:43 AM=20------=_NextPart_000_0452_01C8E738.6BB5F1D0Content-Type: text/html;charset="windows-1250"Content-Transfer-Encoding: quoted-printable
Yes, they do. The thing is, there will be other =fields showingas well so I can’t rule out all blanks in just one field (the =others maycontain info). When sorting on one field, I just wanted all blanks =specific toit to be pushed to the bottom. I think the only way I can do that =is by usinga showif/hidief.
Thanks,
Tana
From:= Gary =Krockover[mailto:gary@garykrockover.com]
Sent: Wednesday, July 16, 2008 11:36 AM
To: talk@webdna.us
Subject: Re: [WebDNA] Sorting -- Dealing with =Blanks
Does your blank record have a SKU number or some =other formof indexing (with blank data thereafter)? If so, the blank records =shouldshow as you expect with a normal search query.
Example, go to http:/=/www.garykrockover.com/dbquickview/dbquickview.htmlselect the "parts.db" database and then run this query:
[search =db=3Dparts.db&neskudatarq=3D[blank]&dedescriptionsort=3D1]
GJK
At 01:10 PM 7/16/2008, you wrote:
Hi,
Does anyone know of a way to show all blank records for a particular =field atthe bottom when using the sort feature? For example, I want to be =able tosort a field, in either ascending or descending order, and always show =anyblank records for that particular field at the bottom. I know I =can use ashowif/hideif but I was wondering if there was actually a command for =that thatI’m missing within the sort feature itself.
Thanks,
Tana
No virus found in this incoming =message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/2008 6:43AM
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: =7/16/2008 6:43 AM
------=_NextPart_000_0452_01C8E738.6BB5F1D0--
"Tana Adams"
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:
Transfering [text] variables (2000)
Running on Empty (1999)
Emailer (1997)
Re:Emailer Set Up (1997)
Pgp&emailer (1997)
two unique banners on one page (1997)
"Advanced" Search Algorithm (2008)
[WebDNA] OT - JS help (2008)
When is unitShipCost calculated? (1998)
Showing unopened cart (1997)
fieldType=num (1997)
Banner DNA (1997)
IE problems persist (2004)
Sorting Dates in a search (2000)
Webcat 3.0.5b9, b8 trigger failures ON WEBSTAR (1999)
Nested tags count question (1997)
WriteFile Formatting (2000)
Search returns all, not 20 (1997)
Generating Searches on the fly? (1999)
Press Release hit the NewsWire!!! (1997)