article custom - title ascending with numbers

mrtunes · 2009-08-12 18:44:20

if i have a set of articles that say:

article #1
article #2…
article #10
article #11
article #12

if i set the sort value to title ascending, it will go article #1, article #10, article #11
does anyone know how to fix this?

ruud · 2009-08-12 19:50:26

sort="Title+0 ASC"

The +0 part forces the Title string into a number, so it sorts numerically instead of alphabetically as a string would.

mrtunes · 2009-08-12 20:29:22

awesome, thanks will try that out soon

mrtunes · 2009-08-13 01:24:32

hmm i just tried it out and it made it so that #6 was the top of the list. strange eh?

mrtunes · 2009-08-14 19:41:30

just to follow up, i still have not resolved this problem. thanks

joebaich · 2009-08-14 20:27:36

You could rename the articles to:

article #001
article #002
article #010
article #011
article #012

to achieve the result you want.

mrtunes · 2009-08-14 20:39:26

ok in that case i should make a custom field to achieve that because adding the 0 in front will detract from the appearance. thank you

ruud · 2009-08-14 22:31:48

What exactly is the value of the title field you’re using… is it #1 or just 1 or something like 1 some text?

joebaich · 2009-08-14 22:49:59

mrtunes wrote:

adding the 0 in front will detract from the appearance.

Well, they do say beauty is in the eye of the beholder :-).

mrtunes · 2009-08-14 23:34:01

ruud wrote:

What exactly is the value of the title field you’re using… is it #1 or just 1 or something like 1 some text?

the artist didn’t name the photos so we just left them at textures #1, textures #2… and up to textures #16

ruud · 2009-08-15 12:38:17

Try this (not tested):

sort="SUBSTRING_INDEX(Title, CHAR(35), -1)+0 ASC"

Textpattern CMS