Sortere efter delindhold af string (Dato)

Well I would have though that IF you soreted after date then it WOULD be sorted as you want :o)

The way you display dates is one thing, but the way they are stored is always the same, and I am sure it will be soreted after this. If not there are functions which you can use to extract each part of the date as columns, and you can sort after these.

SELECT DATEPART(yy, TheDateField) AS Y, DATEPART(m, TheDateField) AS M, DATEPART(d, TheDateField) AS D ORDER BY Y, M, D

Det er nu også et dumt format du har valgt! - Husk altid at vælge US ie. yyyymmdd, så har du ingen problemer overhovedet. Jeg ville lave det om med det samme hvis jeg var dig :O)

spejder man :o) hows it going here?

Looking into it now.... -Thanks

Hi again...

the databse is datbase
the tabel is kalender
the colum datofra

and the datoformat for chrismas is  24-12-02
Were are my mistake...



my code ís

Set kalpunkt = Server.CreateObject ("ADODB.Recordset")
kalpunkt.open "SELECT DATEPART(yy, datofra) AS Y, DATEPART(m, datofra) AS M, DATEPART(d, datofra) AS D ORDER BY Y, M, D FROM kalender", datbase

You dont say what the problem is! If you are not getting the correct records then try your SQL in the query analyser.

If it works in the query analyser then you have a problem with your code, and this is another problem from your original.

Ikke for at genere, men det er et meget underligt skoleengelsk du holder dig Terry!.

FEJLEN ER

Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access-driver] SELECT-sætningen indeholder et reserveret ord eller argument, der er stavet forkert eller mangler, eller tegnsætningen er ikke korrekt.
/kalender/kalender.asp, line 22


Linie 22 er netop:
kalpunkt.open "SELECT DATEPART(yy, datofra) AS Y, DATEPART(m, datofra) AS M, DATEPART(d, datofra) AS D ORDER BY Y, M, D FROM kalender", datbase

Du skal bytte om på order by og from...
SELECT DATEPART(yy, datofra) AS Y, DATEPART(m, datofra) AS M, DATEPART(d, datofra) AS D FROM kalender ORDER BY Y, M, D

janus_007>I'm not quite sure what the problem is, but am in fact english, although I have lived in DK for a number of years now :o)

spejder leon, well its obvious what your problem is now that we see some code!

You have placed your question in MS SQL server BUT you are using an Access driver! Can we please have some more info? IF you are in Access and are selecting from an SQL Server then you use Access SQL syntax unless you are making a passthrough query.

I have this:

dim Y, MDR, DAY
kalpunkt.open "SELECT DATEPART(yy, datofra) AS Year, DATEPART(m, datofra) AS Mdr, DATEPART(d, datofra) AS Day FROM kalender ORDER BY Year, Mdr, Day DESC", datbase

And get the fault
Fejltype:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access-driver] Der er for få parametre. Der var ventet 6.
/kalender/kalender.asp, line 17

Which means some think like:

to few parametres, excpectet 6

and now we find we are in ASP!!!!!!! spejder, is this access database or SQL SERVER??
Please read my comment 10/12-2002 15:48:16

Yes, And sorry. But Im working on a ASP site. wich get the information frow a access database.

But I belive that we only are working on a syntax error right now.

Sorry if I have misplaced my question.

In access there is a BIG difference!

"SELECT DATEPART("yyyy", datofra) AS Y, DATEPART("m", datofra) AS M, DATEPART("d", datofra) AS D FROM kalender ORDER BY Y, M, D DESC"

You must also be carefull using field names such as Day and Year they may very well be reserved words in Access and you may get an error!

stil get an error---:

Fejltype:
Der opstod en Microsoft VBScript-kompileringsfejl (0x800A0401)
Slut på sætning var ventet
/kalender/kalender.asp, line 17, column 32
kalpunkt.open "SELECT DATEPART("yyyy", datofra) AS Y, DATEPART("m", datofra) AS M, DATEPART("d", datofra) AS D FROM kalender ORDER BY Y, M, D DESC" , datbase


In english. End of sentence were expected

The problem is more than likley because " is used in the string

"SELECT DATEPART(""yyyy"", datofra) AS Y, DATEPART(""m"", datofra) AS M, DATEPART(""d"", datofra) AS D FROM kalender ORDER BY Y, M, D DESC"

Notice I have used two " in the datepart function. If is still doesnt work try three
another idea is
DIM sSQL

sSQL = "SELECT DATEPART("yyyy", datofra) AS Y, DATEPART("m", datofra) AS M, DATEPART("d", datofra) AS D FROM kalender ORDER BY Y, M, D DESC"

I know almost nothing about ASP but I think you can use this to display the contents of sSQL on the screen


response.write sSQL

and what we are after is the following. The you should be able to copy this to th equery builder in Access and see if it works.

SELECT DATEPART("yyyy", datofra) AS Y, DATEPART("m", datofra) AS M, DATEPART("d", datofra) AS D FROM kalender ORDER BY Y, M, D DESC

Sorry,

the ansver should be.

kalpunkt.open "SELECT * FROM kalender ORDER BY CDate(datofra) asc",datbase

But I'm a scout and althow good work should make people happy, and that schould be enough payment, it is Christmas, And you fellows have helped and worked... so I will Pay ;-)

Look at the result at http://roskilde.dbs.dk/kalender/kalender.asp

Thanks. And have a Marry Christmas

Hope you are satisfied, else please write me

Hi scout, no problems with the points. Notice my answer 08/12-2002 14:11:04! This is in my mind the same as what you are doing here. IF your field is a date/time type then CDATE should NOT be necessary. But if say it is a text then it may be necessary althoug hyou may get incorrect results!!!!

EXAMPLE>
If its a text field and you have entered in mm/dd/yyyy format then

06/07/2002 is 7th june 2002
But CDate doesnt know that, it thinks its 6th July!!!!

Anyway if yousay its working now then fine :o)

You are right about 06/07/2002 is 7th june 2002. BUT! 6 juli 2003 worked when i testted....