This topic is locked

Order by

1/21/2008 1:31:24 PM
ASPRunnerPro General questions
R
rutzi author

Hallo!!!
I have a database whit many table and. My problem is in the Order by in the list page.

I have a post that I call ROM and one that IS called KODE. It's more field but it's this I won't to order it by. It tries to give an exemplas under here..

Inn field ROM I put ex. KJØKKEN and I have Rom as the first in Order by.

and after the KODE. The problem is that the code never seams to order like I wont.

The number that is under kode don't go from lower to higher.
ROM..........................KODE

KJØKKEN...................5.2.4 (This nummber should go to the end at post KJØKKEN

KJØKKEN...................1.1.2 (This on the top at post KJØKKEN)

KJØKKEN...................3.6.9
STUE.........................5.6.5

STUE.........................3.5.7

STUE.........................4.6.8
How can I make this to go in the right order in the Kode field???
Hope someone can help me as soon as possible
Regard

Rune Hagen <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7318&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />

M
Michael7 1/22/2008

Try to edit your ../output/includes/yourfile_variables.asp with
from
gstrOrderBy="whatever you have"
to
gstrOrderBy="ORDER BY [ROM] ASC, [KODE] ASC"

R
rutzi author 1/22/2008

Hallo and thanks but this didn't help. Still the same problem
Regards

Rune Hagen