Re: a * question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54137
interpreted = N
texte = On Fri, 14 Nov 2003, Kalin Mintchev wrote:> >> > star.db> >> > sku name> > 1 something*here> > 2 alpha> > 3 beta> > 4 gamma> > 5 x> > 6 y> > 7 zakk wylde> > 8 zorro and his mom play chess on saturdayswhat if in the that field there are words OR numbers - that doesn'twork...like:something*herealpha0betasomething*here7gammax111ysomething*herezakk wyldezorro and his mom play chess on saturdaysaccording to ascii sorting the numbers should come first - but theydon't...i get something likesomething*here0something*here0alphabeta.........any thoughts?from the documentation:Sort FirstName Ascending (A-Z or 0-9 if numeric) = > FirstNamesdir=asis a-z first or numeric first or what?thanks...> >> > [search db=star.db&neskudatarq=[blank]&namesort=1&namesdir=as]> > [founditems]> >
[sku] - [name]
> > [/founditems]> > [/search]> >> > outputs:> >> >> > 2 - alpha> >> > 3 - beta> >> > 4 - gamma> >> > 1 - something*here> >> > 5 - x> >> > 6 - y> >> > 7 - zakk wylde> >> > 8 - zorro and his mom play chess on saturdays> >> > GK> >> > At 10:42 PM 11/13/2003, you wrote:> >> > >no....> > >> > >what happens is that a field i'm sorting on has one possible value> > >"something*here", all other possible values are either one word or words> > >separated by comma...> > >> > >when the search executes i get something like this:> > >> > >something*here> > >alpha> > >beta> > >something*here> > >gamma> > >x> > >y> > >something*here> > >zakk wylde> > >zorro and his mom play chess on saturdays> > >> > >....................> > >> > >which doesn't make sense. i already checked for spaces or other> > >'invisible' stuff that can make them 'different' but even if there were> > >such things the order above still doesn't make sense...> >> >> > -------------------------------------------------------------> > This message is sent to you because you are subscribed to> > the mailing list
.> > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/> >>>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On Fri, 14 Nov 2003, Kalin Mintchev wrote:> >> > star.db> >> > sku name> > 1 something*here> > 2 alpha> > 3 beta> > 4 gamma> > 5 x> > 6 y> > 7 zakk wylde> > 8 zorro and his mom play chess on saturdayswhat if in the that field there are words OR numbers - that doesn'twork...like:something*herealpha0betasomething*here7gammax111ysomething*herezakk wyldezorro and his mom play chess on saturdaysaccording to ascii sorting the numbers should come first - but theydon't...i get something likesomething*here0something*here0alphabeta.........any thoughts?from the documentation:Sort FirstName Ascending (A-Z or 0-9 if numeric) = > FirstNamesdir=asis a-z first or numeric first or what?thanks...> >> > [search db=star.db&neskudatarq=[blank]&namesort=1&namesdir=as]> > [founditems]> > [sku] - [name]
> > [/founditems]> > [/search]> >> > outputs:> >> >> > 2 - alpha> >> > 3 - beta> >> > 4 - gamma> >> > 1 - something*here> >> > 5 - x> >> > 6 - y> >> > 7 - zakk wylde> >> > 8 - zorro and his mom play chess on saturdays> >> > GK> >> > At 10:42 PM 11/13/2003, you wrote:> >> > >no....> > >> > >what happens is that a field i'm sorting on has one possible value> > >"something*here", all other possible values are either one word or words> > >separated by comma...> > >> > >when the search executes i get something like this:> > >> > >something*here> > >alpha> > >beta> > >something*here> > >gamma> > >x> > >y> > >something*here> > >zakk wylde> > >zorro and his mom play chess on saturdays> > >> > >....................> > >> > >which doesn't make sense. i already checked for spaces or other> > >'invisible' stuff that can make them 'different' but even if there were> > >such things the order above still doesn't make sense...> >> >> > -------------------------------------------------------------> > This message is sent to you because you are subscribed to> > the mailing list .> > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/> >>>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Kalin Mintchev
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:
OH CRAP!!!!!- Template not found error!!! (1999)
[SHOWIF]s and empty arguments (1997)
[WebDNA] Proper use of [spawn]? (2009)
OK, here goes... (1997)
Odd linefeed problem (2003)
[append] and SSL (1997)
WebCatalog Features (1997)
PSC recommends what date format yr 2000??? (1997)
test (2003)
Bug Report, maybe (1997)
Closing databaes (2002)
Some Questions (1997)
Shownext never shows next...still (1997)
[WebDNA] Unfortunate WebDNA limitation in xmlparse ... (2009)
Two prices in shoppingcart? (1997)
tax rate off by 1 cent (1997)
Forcing Paragraph Breaks on Results (1998)
WebCatalog can't find database (1997)
Indexing Web sites? (2000)
New Plug-in and Type 11 errors (1997)