WHERE (06/06/1978 < 06/06/1979) returns false ?
Clearly 1978 is smaller than 1979 ?
These are dates...
Why is the comparision failing ?
Bye,
Skybuck.
Skybuck Flying schrieb:
> WHERE (06/06/1978 < 06/06/1979) returns false ?
Stick to the subject. This is not a SQL group.
--
Military intelligence is a contradiction in terms.
-- Groucho Marx
....und wech
Danny
Skybuck Flying wrote:
> WHERE (06/06/1978 < 06/06/1979) returns false ?
>
> Clearly 1978 is smaller than 1979 ?
>
> These are dates...
BUT, is 5.0556e-4 smaller than 5.0530-4? NO.
Nicholas Sherlock
Maybe quotes are needed,
So far this seems to be working:
AND (''06/06/1978'' < ''06/06/1979'')
I'll try using quotes one more time ;)
Bye,
skybuck.
Nope, not working:
(Birthday <> null) AND
(Birthday > '06/06/1978') AND
(Birthday < '06/06/1979')
Bye,
Skybuck.
You need to:
1. Fuck off
2. Get a clue what the problem is.
Because you have no idea what the problem is, It could be a Delphi problem
it could be wrong SQL statement.
More information will follow relating to delphi if the problems is not
solved with correct sql statements.
Bye,
Skybuck.
Besides DIPSHIT,
Delphi is a PRODUCT FOR DATABASE DEVELOPMENT.
It's not that far OFF.
PHP-SQL
DELPHI-SQL
LOTS OF OVERLAP.
Besides there is no SQL ONLY NEWSGROUP.
Bye,
Skybuck.
To all others I say:
EXCUSE ME FOR MY FILTHY LANGUAGE.
BUT SOME ASSHOLES BEEN STALKING ME ON THE DELPHI NEWSGROUP FOR THESE LAST
FEW DAYS.
They need some harsh language to get them to fuck off.
Bye,
Skybuck.
Skybuck Flying wrote:
> Maybe quotes are needed,
>
> So far this seems to be working:
>
> AND (''06/06/1978'' < ''06/06/1979'')
>
> I'll try using quotes one more time ;)
How is it supposed to know that the text you've provided forms a date?
It doesn't look any different to any other string. In MySQL, dates are
formatted like 2007-01-01, without quotes. In Oracle, you use a to_date
function to convert a string with a format that you supply to a date.
Every database provider has a slightly different flavor. SQL questions
should go to the DBMS provider's forums.
Nicholas Sherlock
Following SQL example works:
(Birthday <> null) AND
(Birthday > #06/06/1978#) AND
(Birthday < #06/06/1979#)
Bye,
Skybuck.
Skybuck Flying schrieb:
> EXCUSE ME FOR MY FILTHY LANGUAGE.
>
> BUT SOME ASSHOLES BEEN STALKING ME ON THE DELPHI NEWSGROUP FOR THESE LAST
> FEW DAYS.
YOU are the ASSHOLE around here and are stalking everyone for over
years. Get it into your mind, that this is the reason why now everyone
strikes back. YOU ARE THE PROBLEM, NOT WE!
> More information will follow
Don't let any information follow anymore. Get a life and shut up at last.
--
Spend extra time on hobby. Get plenty of rolling papers.
....und wech
Danny
YOU ARE THE ASSHOLE YOU DO NOTHING BUT NAG ABOUT ME
PLONK.
IF YOU KEEP THAT UP YOU MIGHT BE THE FIRST PERSON IN HISTORY TO END UP ON MY
KILLFILE.
UNTIL NOW I HAVE BE VERY TORELANT AGAINST TROLLS AND ASSHOLES LIKE YOU AND
JIM.
Mostly for my own entertainment but now I want to develop something and your
nagging is no longer required for my entertainment purposes.
You should look at yourself and what you are doing and don't listen to what
other says.
Just because others say that I spam or whatever doesn't give you the right
to start hitting on me.
I am not even sure if that is the reason why you do this and I don't care
what the reason is.
All I see you do is nag, nag, nag, nag ABOUT ME !
I NAG ABOUT BUGS AND STUFF THERE IS A DIFFERENCE.
Bye,
Skybuck.
Actually I am going to killfile you right now because I am done.
Skybuck Flying schrieb:
> All I see you do is nag, nag, nag, nag ABOUT ME !
Now the little boy is crying, awh!
> I NAG ABOUT BUGS AND STUFF THERE IS A DIFFERENCE.
Yes, you never get personal.
--
"Sage nicht ja, bevor ich zuende gesprochen habe."
-- Darryl F. Zanuck
....und wech
Danny
I am gonna give you a 4 week ban ;)
Because you nagged a lot.
But you also wrote some stuff about Delphi.
After 4 weeks I shall remove you from the killfile and see how you do.
Bye,
Skybuck :)
Skybuck Flying wrote:
> To all others I say:
>
> EXCUSE ME FOR MY FILTHY LANGUAGE.
>
> BUT SOME ASSHOLES BEEN STALKING ME ON THE DELPHI NEWSGROUP FOR THESE
> LAST FEW DAYS.
You deserve it. You have been terrorizing this group for ages with the
inane junk you post, while gratuitously insulting people along the line.
And yes, please, "ban" me too. Not 4 weeks, forever.
--
Rudy Velthuis http://rvelthuis.de
"We don't like their sound, and guitar music is on the way out."
-- Decca Recording Co. rejecting the Beatles, 1962
Skybuck Flying wrote:
> After 4 weeks I shall remove you from the killfile and see how you do.
LOL! Who cares?
--
Rudy Velthuis http://rvelthuis.de
"Mit der Dummheit kämpfen Götter selbst vergebens"
"Against stupidity the (very) gods themselves contend in vain"
-- Friedrich von Schiller
Rudy Velthuis schrieb:
> You deserve it. You have been terrorizing this group for ages with the
> inane junk you post, while gratuitously insulting people along the line.
Oh-oh, remember he's a researcher, discussing only advanced,
experimental, scientific code.
--
Real software engineers don't debug programs, they verify correctness.
This process doesn't necessarily involve execution of anything on a
computer, except perhaps a Correctness Verification Aid package.
....und wech
Danny
Skybuck Flying wrote:
> Following SQL example works:
>
> (Birthday <> null) AND
> (Birthday > #06/06/1978#) AND
> (Birthday < #06/06/1979#)
>
> Bye,
> Skybuck.
Have you ever considered reading a manual?
As you wish.
No more name calling from you :)
Bye,
Skybuck.
For something as simple as comparing dates: no.
Bye,
Skybuck.
On Sun, 6 Jan 2008 12:35:16 -0000, "Paul Lautman"
>Have you ever considered reading a manual?
Do a search on Usenet and you'll find that is a question often put to
the infamous Skybuck. He prefers people to do his work for him and
then calls it collaboration.
--
Z
The finally code would have looked something like:
(Birthdate < '06/06/1979')
Since Birthdate is a date field the SQL interpreter could have known the
string should contain a date.
Anything else would not make any sense ?!?
Bye,
Skybuck.
Skybuck Flying wrote:
> For something as simple as comparing dates: no.
>
> Bye,
> Skybuck.
You obviously aren't finding it that simple. Using the manual tells you how
to do these things properly in an instant.
No need for manuals, others mention it on the internet.
I have never before seen such a weird way of specifieing a date so I tried
out many things to see what would work and what not.
Apperently the other ones don't work and # has to be used for ms access.
However I am switching to mysql so sooner or later I might have to use a
different date string (?)
Bye,
Skybuck.
Danny Strümpel wrote:
> Skybuck Flying schrieb:
>> EXCUSE ME FOR MY FILTHY LANGUAGE.
>>
>> BUT SOME ASSHOLES BEEN STALKING ME ON THE DELPHI NEWSGROUP FOR THESE
>> LAST FEW DAYS.
>
> YOU are the ASSHOLE around here and are stalking everyone for over
> years. Get it into your mind, that this is the reason why now everyone
> strikes back. YOU ARE THE PROBLEM, NOT WE!
>
>> More information will follow
>
> Don't let any information follow anymore. Get a life and shut up at last.
>
sooner or later - - - -
a person has to realize that if they whole world is against him
that all are saying the same thing about him - - -
that there might some truth to what is being said.
we are tired of you and your stuff - - -
listen and learn - - -
take your med's
it is not one saying this - - - it is all - - - -
you are the only one thinking differently - - - -
you are the problem - - -
Jim P.
Rudy Velthuis wrote:
> Skybuck Flying wrote:
>
>> After 4 weeks I shall remove you from the killfile and see how you do.
>
> LOL! Who cares?
very true
why not ban yourself and make all happy
and then you will not have to put up with abuse from us
as we return what you give
Jim P
Skybuck Flying wrote:
> For something as simple as comparing dates: no.
>
> Bye,
> Skybuck.
>
>
but then you would have the answer instead of making us your manual.
Jim P.
Skybuck Flying wrote:
> The finally code would have looked something like:
>
> (Birthdate < '06/06/1979')
>
> Since Birthdate is a date field the SQL interpreter could have known the
> string should contain a date.
>
Why?
> Anything else would not make any sense ?!?
>
> Bye,
> Skybuck.
>
>
>
In article <15e0d$4780a0b4$541983fa$1580@cache3.tilbu1.nb.home.nl>,
spam@hotmail.com says...
> Maybe quotes are needed,
>
> So far this seems to be working:
>
> AND (''06/06/1978'' < ''06/06/1979'')
>
> I'll try using quotes one more time ;)
It's comparing them as strings, not dates. If you put them in the
format yyyy-mm-dd, either one will work.
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
In article <90be5$4780a525$541983fa$11100@cache2.tilbu1.nb.home.nl>,
spam@hotmail.com says...
> Following SQL example works:
>
> (Birthday <> null) AND
> (Birthday > #06/06/1978#) AND
> (Birthday < #06/06/1979#)
The #'s tell me you're working with Access, which is probably the least
standards-compliant database you can find.
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
In article
spam@hotmail.com says...
> The finally code would have looked something like:
>
> (Birthdate < '06/06/1979')
>
> Since Birthdate is a date field the SQL interpreter could have known the
> string should contain a date.
Or did it think you wanted to convert the date to a string and compare
as strings? It has no way of knowing what you want.
>
> Anything else would not make any sense ?!?
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
Zathras wrote:
> On Sun, 6 Jan 2008 12:35:16 -0000, "Paul Lautman"
>
>
>> Have you ever considered reading a manual?
>
> Do a search on Usenet and you'll find that is a question often put to
> the infamous Skybuck. He prefers people to do his work for him and
> then calls it collaboration.
>
tell me about it
at least he's not as bad as the mi5 guy......
ish