select by dato

prøv med nogle # foran og bagved dato\'en...

hey tpiil :)
I tried that before also and heres the response.write from it
SELECT * FROM photobase WHERE type = \'Duo tone\' AND kategori = \'Natur\' AND dato >= #07-06-2001# AND (beskrivelse LIKE \'%a%\') ORDER BY dato DESC

however none of the results are then shown

I have a whole bunch of results that should get shown from the 09-06-2001 but the dont

however if i change the date to the 06-06-2001
then i get all my results back ?? I had this problem before that why I was trying a something diffrent

Guzzie :]

sikker på at din > vender rigtigt??

hmmm if I changed it around then I would only recieve results the would be less than <  the date searched for ?? woulnt I or ...??
hmmm...
me do a quick test :)
Guzzie

nope that didnt work :(
Im off home now so will be back online in 2 hours
Guzzie

I have two two pretty silly questions:

1) What fieldtype is dato?
2) What DBMS(or worst case Access) are you using?

Jakob

moonduck//
1 = dato is a date colume and not text or notat
2 = access
Guzzie

Try something like this:

strSQL = \"SELECT * FROM photobase WHERE type = \'\" & type_pic & \"\' AND kategori = \'\" & kat & \"\' AND CDate(dato) >= #\" & Mydato & \"# AND Beskrivelse LIKE \'%\" & Search & \"%\' ORDER BY dato DESC

k will try tomorrow im off to bed
guzzie <--- must go to work soon :(
sniff
nat nat

Morning :)
moonduck// nope sorry that didnt work I still have the same problem
tpiil// if I choose the date as the 6 of june then it can find all my post ??

So now i am wondering if the \"day\" that it is finding is not the 9 day of the month but the 9th month - An I think this is way that whenever I choose the date as the 6 og june then it can find all my results, the 6th also being the 6th month ??
Any ideas :( sniff
Guzzie

FormatDateTime() function.. Read more at:
http://msdn.microsoft.com/scripting/vbscript/doc/vsfctFormatDateTime.htm

Or else set the Language in the database to te same as the one on the webserver.

Moonduck// I tried using the GetCurrentDate funchion the Microsoft has but still am getting the same results :(
You said before that I should try setting the language in the database to the one one my server ?
How is that done ?? or is it some simple script that I should insert into my asp page ??
Thanks
Guzzie

hmmm
nobody home ??
think I am gonna close this question soon :(

?

Try use the Session.LCID = \"countrycode\" and use the same language settings as the DB.

hmmm sorry moonduck I dont understand
how do I use the same language settings as the DB
what i mean is where is do I set the language settings ?
I assume you mean I insert
<% Session.LCID = \"countrycode\" %>
into my asp page but the language setup I dont get ?
Guzzie

Look in the documentation for Session.LCID on the microsoft website.

//moonduck  thanks for the help
I want to give you the points but you name dosn\'t appear in the \"Accepter\" field ?
Should I just make a new question and you can get your points there ?
Guzzie

It would be nice :-)

I will close this then and make a new question :)

hvorfor skriver Tpiil til ham på dansk, og han svarer på engelsk ???

I am English :p I live in Denmark and read danish but my written Danish is not a so Fantastic *gg