Re: [WebDNA] reverse rank=off

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100405
interpreted = N
texte = --Apple-Mail-49-589285475 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Can't make it work... My search context now looks like this [search db=/forum/db/ l4text .db &wsl4_txt1data = [forumsearch ]&max=[_searchvalue]&rank=off&from=end&startat=[start]&allreqd=T] The result from execution of the search context look like this... http://www.macnyt.dk/forum/?page=forumsearch_result If you eg. search for the word powerpalle it should show the result from 2008 first and the 2007 and 2006... sorry about the speed. More than 400.000 records (user entries) in this forum database. Anyway. I want the result in this order >>> 2008 >>> 2007 >>> 2006 Remember it's euro date format. Hope for help Palle On 28/07/2008, at 04.31, Gary Krockover wrote: > I believe it should be: > > &rank=off&from=end > > :) > > GJK > > At 02:15 PM 7/27/2008, you wrote: >> Hi all, >> >> In a search context you are able to set rank=off which can give a >> result where the first record ever written in the DB gets first and >> the last record ends out at the end. >> >> How can I reverse this? >> >> Unfortunately the DB in this scenario does not have a unique index... Venlig hilsen Palle Bo Nielsen (PowerPalle) --Apple-Mail-49-589285475 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable
Can't make it = work...

My search context now looks like = this

[search = db=3D/forum/db/l4text.db&wsl4_txt1data=3D[forumsearch]&max=3D[_sea= rchvalue]&rank=3Doff&from=3Dend&startat=3D[start]&allreqd=3D= T]

The result from execution of the search = context look like this...

http://www.= macnyt.dk/forum/?page=3Dforumsearch_result

If= you eg. search for the word powerpalle it should show the result from = 2008 first and the 2007 and 2006... sorry about the speed. More than = 400.000 records (user entries) in this forum = database.

Anyway. I want the result in this = order >>> 2008 >>> 2007 >>> 2006

Remember it's = euro date format.

Hope for = help

Palle




On 28/07/2008, at 04.31, Gary Krockover = wrote:

I believe it should be:

= &rank=3Doff&from=3Dend

:)

GJK

At 02:15 = PM 7/27/2008, you wrote:
Hi all,

In a search = context you are able to set rank=3Doff which can give a 
= result where the first record ever written in the DB gets first = and 
the last record ends out at the end.

How can I = reverse this?

Unfortunately the DB in this scenario does not = have a unique index...
=

Venlig hilsen

Palle Bo = Nielsen
(PowerPalle)
 =

= --Apple-Mail-49-589285475-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] reverse rank=off (Terry Wilson 2008)
  2. Re: [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
  3. Re: [WebDNA] reverse rank=off (Gary Krockover 2008)
  4. Re: [WebDNA] reverse rank=off (Donovan Brooke 2008)
  5. Re: [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
  6. Re: [WebDNA] reverse rank=off (Toby Cox 2008)
  7. Re: [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
  8. Re: [WebDNA] reverse rank=off (Toby Cox 2008)
  9. Re: [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
  10. Re: [WebDNA] reverse rank=off (Gary Krockover 2008)
  11. Re: [WebDNA] reverse rank=off (Terry Wilson 2008)
  12. Re: [WebDNA] reverse rank=off (Donovan Brooke 2008)
  13. [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
--Apple-Mail-49-589285475 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Can't make it work... My search context now looks like this [search db=/forum/db/ l4text .db &wsl4_txt1data = [forumsearch ]&max=[_searchvalue]&rank=off&from=end&startat=[start]&allreqd=T] The result from execution of the search context look like this... http://www.macnyt.dk/forum/?page=forumsearch_result If you eg. search for the word powerpalle it should show the result from 2008 first and the 2007 and 2006... sorry about the speed. More than 400.000 records (user entries) in this forum database. Anyway. I want the result in this order >>> 2008 >>> 2007 >>> 2006 Remember it's euro date format. Hope for help Palle On 28/07/2008, at 04.31, Gary Krockover wrote: > I believe it should be: > > &rank=off&from=end > > :) > > GJK > > At 02:15 PM 7/27/2008, you wrote: >> Hi all, >> >> In a search context you are able to set rank=off which can give a >> result where the first record ever written in the DB gets first and >> the last record ends out at the end. >> >> How can I reverse this? >> >> Unfortunately the DB in this scenario does not have a unique index... Venlig hilsen Palle Bo Nielsen (PowerPalle) --Apple-Mail-49-589285475 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable
Can't make it = work...

My search context now looks like = this

[search = db=3D/forum/db/l4text.db&wsl4_txt1data=3D[forumsearch]&max=3D[_sea= rchvalue]&rank=3Doff&from=3Dend&startat=3D[start]&allreqd=3D= T]

The result from execution of the search = context look like this...

http://www.= macnyt.dk/forum/?page=3Dforumsearch_result

If= you eg. search for the word powerpalle it should show the result from = 2008 first and the 2007 and 2006... sorry about the speed. More than = 400.000 records (user entries) in this forum = database.

Anyway. I want the result in this = order >>> 2008 >>> 2007 >>> 2006

Remember it's = euro date format.

Hope for = help

Palle




On 28/07/2008, at 04.31, Gary Krockover = wrote:

I believe it should be:

= &rank=3Doff&from=3Dend

:)

GJK

At 02:15 = PM 7/27/2008, you wrote:
Hi all,

In a search = context you are able to set rank=3Doff which can give a 
= result where the first record ever written in the DB gets first = and 
the last record ends out at the end.

How can I = reverse this?

Unfortunately the DB in this scenario does not = have a unique index...
=

Venlig hilsen

Palle Bo = Nielsen
(PowerPalle)
 =

= --Apple-Mail-49-589285475-- Palle Bo Nielsen

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:

WebCatalog/Mac 2.1b2 - PIXO (1997) RE: type 2 errors with ssl server (1997) [WebDNA] Format Days_To_Date (2008) Bug? (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Date format problems (1997) Fwd: Emailer & IMail List Server (1998) Moment of Thanks (1997) Nesting format tags (1997) can WC render sites out? (1997) Is this possible, WebCat2.0 and checkboxes (1997) Summary Searches (2000) DON'T use old cart file! (1997) Arbitrary limits on length of data in cart header fields? (2000) Help name our technology! (1997) WebCatalog for Postcards ? (1997) Loss in Form (1998) archives down (2001) [isfile] ? (1997) Search Form (2000)