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.6BB5F1D0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable Yes, they do. The thing is, there will be other fields showing as well = so I can=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 be pushed to the bottom. I think the only way I can do that is by using a showif/hidief. =20 Thanks, =20 Tana =20 From: Gary Krockover [mailto:gary@garykrockover.com]=20 Sent: Wednesday, July 16, 2008 11:36 AM To: talk@webdna.us Subject: Re: [WebDNA] Sorting -- Dealing with Blanks =20 Does 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 = you expect with a normal search query. Example, go to HYPERLINK "http://www.garykrockover.com/dbquickview/dbquickview.html"http://www.gar= ykr ockover.com/dbquickview/dbquickview.html select 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, =20 Does anyone know of a way to show all blank records for a particular = field at the bottom when using the sort feature? For example, I want to be = able to sort a field, in either ascending or descending order, and always = show any blank records for that particular field at the bottom. I know I can = use a showif/hideif but I was wondering if there was actually a command for = that that I=92m missing within the sort feature itself. =20 Thanks, =20 Tana =20 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:43 AM No virus found in this outgoing message. Checked by AVG.=20 Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: = 7/16/2008 6:43 AM =20 ------=_NextPart_000_0452_01C8E738.6BB5F1D0 Content-Type: text/html; charset="windows-1250" Content-Transfer-Encoding: quoted-printable

Yes, they do.  The thing is, there will be other = fields showing as well so I can’t 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 be pushed to the bottom.  I think the only way I can do that = is by using a 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 form of indexing (with blank data thereafter)?  If so, the blank records = should show as you expect with a normal search query.

Example, go to http:/= /www.garykrockover.com/dbquickview/dbquickview.html select 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 at the bottom when using the sort feature?  For example, I want to be = able to sort a field, in either ascending or descending order, and always show = any blank records for that particular field at the bottom.  I know I = can use a showif/hideif but I was wondering if there was actually a command for = that that I’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:43 AM


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:

    
  1. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  2. Re: [WebDNA] Sorting -- Dealing with Blanks (Matthew Bohne 2008)
  3. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  4. Re: [WebDNA] Sorting -- Dealing with Blanks (Donovan Brooke 2008)
  5. Re: [WebDNA] Sorting -- Dealing with Blanks (Donovan Brooke 2008)
  6. Re: [WebDNA] Sorting -- Dealing with Blanks (Charles Kline 2008)
  7. RE: [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
  8. Re: [WebDNA] Sorting -- Dealing with Blanks (Gary Krockover 2008)
This is a multipart message in MIME format. ------=_NextPart_000_0452_01C8E738.6BB5F1D0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable Yes, they do. The thing is, there will be other fields showing as well = so I can=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 be pushed to the bottom. I think the only way I can do that is by using a showif/hidief. =20 Thanks, =20 Tana =20 From: Gary Krockover [mailto:gary@garykrockover.com]=20 Sent: Wednesday, July 16, 2008 11:36 AM To: talk@webdna.us Subject: Re: [WebDNA] Sorting -- Dealing with Blanks =20 Does 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 = you expect with a normal search query. Example, go to HYPERLINK "http://www.garykrockover.com/dbquickview/dbquickview.html"http://www.gar= ykr ockover.com/dbquickview/dbquickview.html select 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, =20 Does anyone know of a way to show all blank records for a particular = field at the bottom when using the sort feature? For example, I want to be = able to sort a field, in either ascending or descending order, and always = show any blank records for that particular field at the bottom. I know I can = use a showif/hideif but I was wondering if there was actually a command for = that that I=92m missing within the sort feature itself. =20 Thanks, =20 Tana =20 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:43 AM No virus found in this outgoing message. Checked by AVG.=20 Version: 7.5.524 / Virus Database: 270.5.0/1555 - Release Date: = 7/16/2008 6:43 AM =20 ------=_NextPart_000_0452_01C8E738.6BB5F1D0 Content-Type: text/html; charset="windows-1250" Content-Transfer-Encoding: quoted-printable

Yes, they do.  The thing is, there will be other = fields showing as well so I can’t 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 be pushed to the bottom.  I think the only way I can do that = is by using a 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 form of indexing (with blank data thereafter)?  If so, the blank records = should show as you expect with a normal search query.

Example, go to http:/= /www.garykrockover.com/dbquickview/dbquickview.html select 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 at the bottom when using the sort feature?  For example, I want to be = able to sort a field, in either ascending or descending order, and always show = any blank records for that particular field at the bottom.  I know I = can use a showif/hideif but I was wondering if there was actually a command for = that that I’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:43 AM


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)