Re: [WebDNA] Sorting -- Dealing with Blanks

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100320
interpreted = N
texte = --Apple-Mail-2--443829591 Content-Type: text/plain; charset=cp932; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable just do 2 searches. -- Charles Kline ckline@rightcode.net http://www.rightcode.net On Jul 16, 2008, at 2:38 PM, "Tana Adams" wrote: > Yes, they do. The thing is, there will be other fields showing as =20 > well so I can=81ft rule out all blanks in just one field (the others = ma=20 > y contain info). When sorting on one field, I just wanted all blank=20= > s specific to it to be pushed to the bottom. I think the only way I=20= > 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 =20 > indexing (with blank data thereafter)? If so, the blank records =20 > should show as you expect with a normal search query. > > Example, go to = http://www.garykrockover.com/dbquickview/dbquickview.html=20 > 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 =20= > field at the bottom when using the sort feature? For example, I =20 > want to be able to sort a field, in either ascending or descending =20 > order, and always show any blank records for that particular field =20 > at the bottom. I know I can use a showif/hideif but I was wondering =20= > if there was actually a command for that that I=81fm missing within = the=20 > 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: =20 > 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: =20 > 7/16/2008 6:43 AM --Apple-Mail-2--443829591 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
just do 2 = searches. 

--
Charles Kline
ckline@rightcode.net
http://www.rightcode.net
=

On Jul 16, 2008, at 2:38 PM, "Tana Adams" <tana@volleyhut.com> = wrote:

Yes, they do.  The thing is, there will be other = fields showing as well so I can=E2=80=99t 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=E2=80=99m 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

= --Apple-Mail-2--443829591-- 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)
  9. [WebDNA] Sorting -- Dealing with Blanks ("Tana Adams" 2008)
--Apple-Mail-2--443829591 Content-Type: text/plain; charset=cp932; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable just do 2 searches. -- Charles Kline ckline@rightcode.net http://www.rightcode.net On Jul 16, 2008, at 2:38 PM, "Tana Adams" wrote: > Yes, they do. The thing is, there will be other fields showing as =20 > well so I can=81ft rule out all blanks in just one field (the others = ma=20 > y contain info). When sorting on one field, I just wanted all blank=20= > s specific to it to be pushed to the bottom. I think the only way I=20= > 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 =20 > indexing (with blank data thereafter)? If so, the blank records =20 > should show as you expect with a normal search query. > > Example, go to = http://www.garykrockover.com/dbquickview/dbquickview.html=20 > 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 =20= > field at the bottom when using the sort feature? For example, I =20 > want to be able to sort a field, in either ascending or descending =20 > order, and always show any blank records for that particular field =20 > at the bottom. I know I can use a showif/hideif but I was wondering =20= > if there was actually a command for that that I=81fm missing within = the=20 > 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: =20 > 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: =20 > 7/16/2008 6:43 AM --Apple-Mail-2--443829591 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
just do 2 = searches. 

--
Charles Kline
ckline@rightcode.net
http://www.rightcode.net
=

On Jul 16, 2008, at 2:38 PM, "Tana Adams" <tana@volleyhut.com> = wrote:

Yes, they do.  The thing is, there will be other = fields showing as well so I can=E2=80=99t 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=E2=80=99m 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

= --Apple-Mail-2--443829591-- Charles Kline

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:

about this server and links to who (1997) Exclamation point (1997) WebCat2 several catalogs? (1997) Languages (1997) Problem with 2.1b3 (1997) Make sure I understand this??? (1997) [WebDNA] Poll: Discussion Forum (2009) Separate SSL Server (1997) Multiple download orders of the same product? (1997) Press Release hit the NewsWire!!! (1997) webmerch and serials - almost there (1997) Help with Shipping Costs (1997) [WebDNA] HTTP crashes (2010) RE: Error: template (1997) PC Cookie Problem? (2003) Trigger Error (2001) NetForms for email (1998) WebCat2 beta 11 - new prefs ... (1997) Behind the Scenes. . . (1998) M$loth messes with our sites (again) (2004)