Re: [WebDNA] Sorting -- Dealing with Blanks
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100318
interpreted = N
texte = --=====================_138579750==.ALTContent-Type: text/plain; charset="us-ascii"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=parts.db&neskudatarq=[blank]&dedescriptionsort=1]GJKAt 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--=====================_138579750==.ALTContent-Type: text/html; charset="us-ascii"
Does your blank record have a SKU number or some other formof indexing (with blank data thereafter)? If so, the blank recordsshould show as you expect with a normal search query.
Example, go tohttp://www.garykrockover.com/dbquickview/dbquickview.html select the"parts.db" database and then run this query:
[searchdb=parts.db&neskudatarq=[blank]&dedescriptionsort=1]
GJK
At 01:10 PM 7/16/2008, you wrote:
Hi,
Does anyone know of a way to show all blank records for a particularfield at the bottom when using the sort feature? For example, Iwant to be able to sort a field, in either ascending or descending order,and always show any blank records for that particular field at thebottom. I know I can use a showif/hideif but I was wondering ifthere was actually a command for that that I’m missing within the sortfeature itself.
Thanks,
Tana
--=====================_138579750==.ALT--
Associated Messages, from the most recent to the oldest:
--=====================_138579750==.ALTContent-Type: text/plain; charset="us-ascii"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=parts.db&neskudatarq=[blank]&dedescriptionsort=1]GJKAt 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--=====================_138579750==.ALTContent-Type: text/html; charset="us-ascii"
Does your blank record have a SKU number or some other formof indexing (with blank data thereafter)? If so, the blank recordsshould show as you expect with a normal search query.
Example, go tohttp://www.garykrockover.com/dbquickview/dbquickview.html select the"parts.db" database and then run this query:
[searchdb=parts.db&neskudatarq=[blank]&dedescriptionsort=1]
GJK
At 01:10 PM 7/16/2008, you wrote:
Hi,
Does anyone know of a way to show all blank records for a particularfield at the bottom when using the sort feature? For example, Iwant to be able to sort a field, in either ascending or descending order,and always show any blank records for that particular field at thebottom. I know I can use a showif/hideif but I was wondering ifthere was actually a command for that that I’m missing within the sortfeature itself.
Thanks,
Tana
--=====================_138579750==.ALT--
Gary Krockover
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:
Separate SSL Server (1997)
Shell context. (2002)
searchable list archive (1997)
M$loth messes with our sites (again) 2004/02/03 (2004)
Interfacing WebMerchant to www.fedex.com (1997)
WebCatalog for Postcards ? (1997)
tabs as delimiters (2004)
OT: Javascript help (2003)
cc auth with [purchase] (1998)
WCS Newbie question (1997)
Multiple SSL Keys (1998)
WEBCAT HIERARCHY (1999)
& in Lookups (1997)
Plugin or CGI or both (1997)
Location of Browser Info.txt file (1997)
html delivery (1997)
Process SSI and WebCatalog.acgi (1998)
Help! WebCat2 bug (1997)
Pull Down Search (2000)
Stats (2004)