Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot, bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon

Links

XODOX
Impressum

#1: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:24:55 by Legendsfan

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.

Report this message

#2: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:28:06 by dannys9

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 <dannys9 (at) gmx (dot) de>

Report this message

#3: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:32:54 by Nicholas Sherlock

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

Report this message

#4: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:36:53 by Legendsfan

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.

Report this message

#5: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:41:22 by Legendsfan

Nope, not working:

(Birthday <> null) AND
(Birthday > '06/06/1978') AND
(Birthday < '06/06/1979')

Bye,
Skybuck.

Report this message

#6: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:42:39 by Legendsfan

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.

Report this message

#7: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:44:56 by Legendsfan

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.

Report this message

#8: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:47:03 by Legendsfan

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.

Report this message

#9: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:50:52 by Nicholas Sherlock

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

Report this message

#10: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)

Posted on 2008-01-06 10:55:51 by Legendsfan

Following SQL example works:

(Birthday <> null) AND
(Birthday > #06/06/1978#) AND
(Birthday < #06/06/1979#)

Bye,
Skybuck.

Report this message

#11: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 10:59:23 by dannys9

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 <dannys9 (at) gmx (dot) de>

Report this message

#12: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 11:48:45 by Legendsfan

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.

Report this message

#13: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 12:17:17 by dannys9

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 <dannys9 (at) gmx (dot) de>

Report this message

#14: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 12:19:38 by Legendsfan

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 :)

Report this message

#15: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 13:26:59 by Rudy Velthuis

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

Report this message

#16: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 13:27:50 by Rudy Velthuis

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

Report this message

#17: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 13:34:22 by dannys9

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. <eg>

--
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 <dannys9 (at) gmx (dot) de>

Report this message

#18: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)

Posted on 2008-01-06 13:35:16 by Paul Lautman

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?

Report this message

#19: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 15:23:10 by Legendsfan

As you wish.

No more name calling from you :)

Bye,
Skybuck.

Report this message

#20: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)

Posted on 2008-01-06 15:27:20 by Legendsfan

For something as simple as comparing dates: no.

Bye,
Skybuck.

Report this message

#21: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)

Posted on 2008-01-06 15:29:30 by Zathras

On Sun, 6 Jan 2008 12:35:16 -0000, "Paul Lautman"
<paul.lautman@btinternet.com> wrote:

>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

Report this message

#22: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 16:25:04 by Legendsfan

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.

Report this message

#23: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)

Posted on 2008-01-06 16:39:55 by Paul Lautman

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.

Report this message

#24: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)

Posted on 2008-01-06 17:04:17 by Legendsfan

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.

Report this message

#25: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 20:50:56 by JIm P

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.

Report this message

#26: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 21:01:42 by 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

Report this message

#27: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problemsolved ;)

Posted on 2008-01-06 21:04:26 by 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.

Report this message

#28: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-06 21:05:52 by 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.
>
>
>

Report this message

#29: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-07 15:28:38 by David Kerber

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).

Report this message

#30: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problem solved ;)

Posted on 2008-01-07 15:29:59 by David Kerber

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).

Report this message

#31: Re: WHERE (06/06/1978 < 06/06/1979) returns false ?

Posted on 2008-01-07 15:33:19 by David Kerber

In article <b7e77$4780f24d$541983fa$15576@cache5.tilbu1.nb.home.nl>,
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).

Report this message

#32: Re: WHERE (#06/06/1978# < #06/06/1979#) works in MS Access. Problemsolved ;)

Posted on 2008-01-07 17:03:00 by geoff

Zathras wrote:
> On Sun, 6 Jan 2008 12:35:16 -0000, "Paul Lautman"
> <paul.lautman@btinternet.com> wrote:
>
>> 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

Report this message